Oracle Advanced Replication
To all,
I have a 5-way multi-master replication set up on Oracle 817 and Sun Solaris
2.7.
In the replication group, we would like to add a new column to a replicated
table.
Not only that, we would like to add this new column to the primary key of this
replicated table.
What are the steps that I would need to do?
I seems to remember that if we add any new columns in the replicated object, we
would need to
1) quieced the whole environment
2) drop this object from the replication group
3) add the new column in the MDS as well as all other master sites
4) add this table back to the replication group
5) generate replication support
6) resume replication again
Would some replication expert tell me if I am correct or not? (I did try to look
in the doc, but I can't find it any where)
Thanks for your help!
Winnie
--
\ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~
(@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~
/ V \ Oracle Database Administrator`~`~
o--m-m--o Infonet Services Corporation `~`~
# mailto:[EMAIL PROTECTED]`~`~
~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Oracle Advanced Replication
Is there some reason that you can't use DBMS_REPCAT.EXECUTE_DDL? See
the Supplied PL/SQL Packages reference; here's the description:
EXECUTE_DDL Procedure
This procedure supplies DDL that you want to have executed at some or
all master sites. You can call this procedure only from the master
definition site.
This package is intended to replicate changes made to objects that
belong to a replication group, so it should be suitable for use here,
as well as being a whole lot simpler than the approach you'd otherwise
have to take.
HTH.
--- [EMAIL PROTECTED] wrote:
To all,
I have a 5-way multi-master replication set up on Oracle 817 and Sun
Solaris
2.7.
In the replication group, we would like to add a new column to a
replicated
table.
Not only that, we would like to add this new column to the primary
key of this
replicated table.
What are the steps that I would need to do?
I seems to remember that if we add any new columns in the replicated
object, we
would need to
1) quieced the whole environment
2) drop this object from the replication group
3) add the new column in the MDS as well as all other master sites
4) add this table back to the replication group
5) generate replication support
6) resume replication again
Would some replication expert tell me if I am correct or not? (I did
try to look
in the doc, but I can't find it any where)
Thanks for your help!
Winnie
--
\ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~
(@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~
/ V \ Oracle Database Administrator`~`~
o--m-m--o Infonet Services Corporation `~`~
# mailto:[EMAIL PROTECTED]`~`~
~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Oracle Advanced Replication
The only reason is that we have to change the primary key constraint. That's
mean, we got to drop and recreate the primary key constraint. And if the
replicated object is still in the replication group, it probably won't allow me
to drop the primary key though. (or maybe I got it all wrong?)
Thanks for your help anyway,
Winnie
--
\ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~
(@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~
/ V \ Oracle Database Administrator`~`~
o--m-m--o Infonet Services Corporation `~`~
# mailto:[EMAIL PROTECTED]`~`~
~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~
Paul Baumgartel
treegarden@yahooTo: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
.comcc:
Sent by: Subject: Re: Oracle Advanced
Replication
[EMAIL PROTECTED]
12/11/02 04:58 PM
Please respond to
ORACLE-L
Is there some reason that you can't use DBMS_REPCAT.EXECUTE_DDL? See
the Supplied PL/SQL Packages reference; here's the description:
EXECUTE_DDL Procedure
This procedure supplies DDL that you want to have executed at some or
all master sites. You can call this procedure only from the master
definition site.
This package is intended to replicate changes made to objects that
belong to a replication group, so it should be suitable for use here,
as well as being a whole lot simpler than the approach you'd otherwise
have to take.
HTH.
--- [EMAIL PROTECTED] wrote:
To all,
I have a 5-way multi-master replication set up on Oracle 817 and Sun
Solaris
2.7.
In the replication group, we would like to add a new column to a
replicated
table.
Not only that, we would like to add this new column to the primary
key of this
replicated table.
What are the steps that I would need to do?
I seems to remember that if we add any new columns in the replicated
object, we
would need to
1) quieced the whole environment
2) drop this object from the replication group
3) add the new column in the MDS as well as all other master sites
4) add this table back to the replication group
5) generate replication support
6) resume replication again
Would some replication expert tell me if I am correct or not? (I did
try to look
in the doc, but I can't find it any where)
Thanks for your help!
Winnie
--
\ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~
(@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~
/ V \ Oracle Database Administrator`~`~
o--m-m--o Infonet Services Corporation `~`~
# mailto:[EMAIL PROTECTED]`~`~
~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ: http
RE: Oracle Advanced Replication
I will write my comments in your response. Scroll down. One point I would like to stress: We are planing to drop replication and work with the live DB in case one DB goes down. In this case we will work for some days without replication until we rebuild the dba machine and then do an export/import from the live DB to the new one and rebuild the replication again. See my comments bellow. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Rahul Dandekar [SMTP:[EMAIL PROTECTED]] Sent: Mon, February 18, 2002 7:03 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Advanced Replication Adar, How do you take care of backups? I mean, what kind of backups do you take? How are you addressing the scenario of incomplete recovery? Following are some of my doubts. 1. What kind of Backup should be taken? Online or Offline? Does replication would generate substantially higher redo? [ADAR]We do online backups using Veritas backupexec + some exports at key points. Ø Lets analyze the possibility of Online Backups : q Redo Generation Apparently, a database in replicated environment would generate significantly more redo if the same database was not in replicated environment. Is there sufficient bandwidth (diskspace, tapes) for the additional redo? [ADAR] We are doing synchronous replication (2 phase commit). In this case oracle use a trigger to update the backup DB without writing anything to the redo log. The redo log will inflate in case of asynchronous replication because of the updates to the replication tables. q Need for Complete Recovery If we need to recover one of the databases then it should be complete recovery. Incomplete recovery will not be permissible since the databases are in replicated environment. (Lets not consider 'All' the databases restored from their backups till a certain SCN.) [ADAR] We are doing full backup just in case of both system failure. If one system fails we continue to work with the other and synchronize later. q Quick Recovery Also, the recovery must be done quickly. This is because as one of the databases in replicated environment is down, the DEFTRAN queues in other master sites would start getting larger and larger and it might reach to a stage where we would also need to do the 'Offline Instantiation' for replicated objects. [ADAR] We are not planing it this way. For NOW we plan on dropping the replication and building the bad DB from scratch, using export from the live DB and building the replication again. Our system is dealing room and we have each Sunday available as the dealers around the world have a day off. So if one computer is down we will not have replication until next Sunday. This also gives us time to fix the computer and build a new DB without pressure. q When complete ercovery is not possible In case complete recovery is not possible then we need to recover the databases and then perform 'Offline Instantiation' for replicated objects. [ADAR] That's the beauty of our plan. You do not need recovery at all. Just use the live DB as a source to recreate the bad DB again. Ø What if we take Offline Backups : q For a simple recovery, entire database needs to be restored from the cold backup. q 'Offline Instantiation' needs to be performed each time media recovery is performed. This is because media recovery would always bring the database till the time of cold backup and other master sites would be ahead in time. q In case datafiles affecting 'only' those tablespaces which have objects which are replicated are needing recovery then recovery can be done by using transportable tablespaces feature. i. First, we would need to drop those tablespaces from the database. ii. We can then drop replication for this master group. iii. Transport and Plug-in the tablespace's datafile from other master site. iv. Rebuild replication. TIA, +Rahul - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, February 17, 2002 11:18 AM Hello Peter We implemented Advance Replication as part of dealing room. We defined master to master real-time replication. Synchronous, 2 phase commit, from the primary to the backup DB as each deal is a lot of money and standby database will not reflect updates since the last log file
Re: Oracle Advanced Replication
Adar, How do you take care of backups? I mean, what kind of backups do you take? How are you addressing the scenario of incomplete recovery? Following are some of my doubts. 1. What kind of Backup should be taken? Online or Offline? Does replication would generate substantially higher redo? Ø Lets analyze the possibility of Online Backups : q Redo Generation Apparently, a database in replicated environment would generate significantly more redo if the same database was not in replicated environment. Is there sufficient bandwidth (diskspace, tapes) for the additional redo? q Need for Complete Recovery If we need to recover one of the databases then it should be complete recovery. Incomplete recovery will not be permissible since the databases are in replicated environment. (Lets not consider 'All' the databases restored from their backups till a certain SCN.) q Quick Recovery Also, the recovery must be done quickly. This is because as one of the databases in replicated environment is down, the DEFTRAN queues in other master sites would start getting larger and larger and it might reach to a stage where we would also need to do the 'Offline Instantiation' for replicated objects. q When complete ercovery is not possible . In case complete recovery is not possible then we need to recover the databases and then perform 'Offline Instantiation' for replicated objects. Ø What if we take Offline Backups : q For a simple recovery, entire database needs to be restored from the cold backup. q 'Offline Instantiation' needs to be performed each time media recovery is performed. This is because media recovery would always bring the database till the time of cold backup and other master sites would be ahead in time. q In case datafiles affecting 'only' those tablespaces which have objects which are replicated are needing recovery then recovery can be done by using transportable tablespaces feature. i. First, we would need to drop those tablespaces from the database. ii. We can then drop replication for this master group. iii. Transport and Plug-in the tablespace's datafile from other master site. iv. Rebuild replication. TIA, +Rahul - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, February 17, 2002 11:18 AM Hello Peter We implemented Advance Replication as part of dealing room. We defined master to master real-time replication. Synchronous, 2 phase commit, from the primary to the backup DB as each deal is a lot of money and standby database will not reflect updates since the last log file was archived. Since we need master to master we defined the replication from the backup DB to the primary as asynchronous even though no body is using the backup DB. I think that the cases are similar. Points to take care off: 1) Prepare a script to drop the replication on each machine if the other machine fails. Lets say that you got a CPU fault on the primary and you switch to the backup. In this case you might get off with the asynchronous replication as updates will accumulate in the backup machine until the CPU is replaced. When the primary will come up the replication will update the primary DB with all the changes. Now, if the disk drive fails on the primary you will probably have to rebuild the DB from scratch (or from export from the backup). In this case there is no point to accumulate updates in the backup machine. Also, if the backup machine fails you do not want the updates to the primary to fail. In this case you drop replication and go on working. 2) Ensure that the log files, rollback segments, datafiles (size) and all init ora are the same on both machines. You do not want to swap to the backup only to find that the parameters are ok for one connection (replication) but fails when working as a primary DB. 3) Hey, what happens if the air condition stopped working and ALL the machines heats up and stopped working. Both machine will fail. Worse if that room gets on fire you are out of luck. Move the backup machine at least a couple of rooms away. 4) Use stand by database in another building so in case of a serious problem (11 seqptember) you will not lose all your data, only the data since the last archive. 5) Test, Test, Test again all failure scenarios, and test again each month, quarter or whatever. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Peter Barnett [SMTP:[EMAIL PROTECTED]] Sent: Fri, February 15, 2002 1:04 AM To: Multiple recipients of list ORACLE-L Subject: Oracle Advanced Replication We
RE: Oracle Advanced Replication
Title: RE: Oracle Advanced Replication Not yet, support for those objects are scheduled for this winter. Nick -Original Message-From: Ji, Richard [mailto:[EMAIL PROTECTED]]Sent: Friday, February 15, 2002 12:58 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle Advanced Replication Nick, DoesSharePlex supportuser definedobject types? Richard -Original Message-From: Nick Wagner [mailto:[EMAIL PROTECTED]]Sent: Friday, February 15, 2002 2:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle Advanced Replication All this talk of replication is really nice. SharePlex for Oracle, can handle master to master replication. Conflicts are handled via pl/sql procedures inside the database, where you can determine exactly what happens when there is a conflict. SharePlex performs really well whether it is a batch program doing massive DML operations, or many small OLTP type transactions. SharePlex can handle around 300-500 DML operations per second in most situations... more if the hardware and database are tuned properly. As for failover, it works VERY well, and can handle many of the datatypes that trigger based replication can not support. LONGs and LONG RAWs especially... One other thing SharePlex can replicate are sequences. If you have sequences that generate PK's or unique keys, then you should probably replicate them, otherwise after a failure, you will have to find out what the highest value for those sequences are for each of your tables, and then rebuild all the sequences. This can take a long time, even on a medium sized database. Just a couple of things to think over, when selecting a replication product. Nick -Original Message- From: Gary Weber [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 10:14 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Advanced Replication Pete, I've implemented a very similar solution recently for BEA-based application. Two database servers, Multi-master replication between two databases, 1 minute propagation interval. Works great on our hardware, which was designed for the purpose and is pretty fast. Small transactions - OLTP stuff - seem to replicate well. The same can not be said for large DML operations. So far, I've been unable to tune replication so that it is capable of propagated batch type changes for large amounts of data - the receiving site seems to be converting the DML based on internal algorithm, which throws my indexing approach out of the window. Oracle Support has been of no help, other then suggesting different indexing for failover site. Gary Weber Senior DBA Charles Jones, LLC||Superior Information Services, LLC 609-530-1144, ext 5529 -Original Message- Sent: Thursday, February 14, 2002 5:04 PM To: Multiple recipients of list ORACLE-L We are looking at Advanced Replication as a fail over option for a web site. Straight forward installation, both boxes on the same subnet on their own dmz. The servers will be located on the same rack in the computer room. Very few tables storing data from an application that is tracking click through data. Does anyone see any flaws with the basic plan? Any hidden 'features' that we may run into? Thanks = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing
RE: RE: Oracle Advanced Replication
Pete, While SharePlex does quite nicely in replicating DML, it is all the other stuff that it doesn't replicate that ruled it out for us - adding datafiles, creating tablespaces, etc. If its not captured in the redo logs, SharePlex won't replicate it. Basically, keeping your standby and primary in sync meta-data wise is not possible with SharePlex. Just something to consider. If you have a very active environment, this becomes a nightmare. Jim Oracle Database Administrator Nick Wagner [EMAIL PROTECTED] wrote: Not yet, support for those objects are scheduled for this winter. Nick -Original Message- Sent: Friday, February 15, 2002 12:58 PM To: Multiple recipients of list ORACLE-L Nick, Does SharePlex support user defined object types? Richard -Original Message- Sent: Friday, February 15, 2002 2:09 PM To: Multiple recipients of list ORACLE-L All this talk of replication is really nice. SharePlex for Oracle, can handle master to master replication. Conflicts are handled via pl/sql procedures inside the database, where you can determine exactly what happens when there is a conflict. SharePlex performs really well whether it is a batch program doing massive DML operations, or many small OLTP type transactions. SharePlex can handle around 300-500 DML operations per second in most situations... more if the hardware and database are tuned properly. As for failover, it works VERY well, and can handle many of the datatypes that trigger based replication can not support. LONGs and LONG RAWs especially... One other thing SharePlex can replicate are sequences. If you have sequences that generate PK's or unique keys, then you should probably replicate them, otherwise after a failure, you will have to find out what the highest value for those sequences are for each of your tables, and then rebuild all the sequences. This can take a long time, even on a medium sized database. Just a couple of things to think over, when selecting a replication product. Nick -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Friday, February 15, 2002 10:14 AM To: Multiple recipients of list ORACLE-L Pete, I've implemented a very similar solution recently for BEA-based application. Two database servers, Multi-master replication between two databases, 1 minute propagation interval. Works great on our hardware, which was designed for the purpose and is pretty fast. Small transactions - OLTP stuff - seem to replicate well. The same can not be said for large DML operations. So far, I've been unable to tune replication so that it is capable of propagated batch type changes for large amounts of data - the receiving site seems to be converting the DML based on internal algorithm, which throws my indexing approach out of the window. Oracle Support has been of no help, other then suggesting different indexing for failover site. Gary Weber Senior DBA Charles Jones, LLC||Superior Information Services, LLC 609-530-1144, ext 5529 -Original Message- Sent: Thursday, February 14, 2002 5:04 PM To: Multiple recipients of list ORACLE-L We are looking at Advanced Replication as a fail over option for a web site. Straight forward installation, both boxes on the same subnet on their own dmz. The servers will be located on the same rack in the computer room. Very few tables storing data from an application that is tracking click through data. Does anyone see any flaws with the basic plan? Any hidden 'features' that we may run into? Thanks = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
RE: Oracle Advanced Replication
Hello Peter We implemented Advance Replication as part of dealing room. We defined master to master real-time replication. Synchronous, 2 phase commit, from the primary to the backup DB as each deal is a lot of money and standby database will not reflect updates since the last log file was archived. Since we need master to master we defined the replication from the backup DB to the primary as asynchronous even though no body is using the backup DB. I think that the cases are similar. Points to take care off: 1) Prepare a script to drop the replication on each machine if the other machine fails. Lets say that you got a CPU fault on the primary and you switch to the backup. In this case you might get off with the asynchronous replication as updates will accumulate in the backup machine until the CPU is replaced. When the primary will come up the replication will update the primary DB with all the changes. Now, if the disk drive fails on the primary you will probably have to rebuild the DB from scratch (or from export from the backup). In this case there is no point to accumulate updates in the backup machine. Also, if the backup machine fails you do not want the updates to the primary to fail. In this case you drop replication and go on working. 2) Ensure that the log files, rollback segments, datafiles (size) and all init ora are the same on both machines. You do not want to swap to the backup only to find that the parameters are ok for one connection (replication) but fails when working as a primary DB. 3) Hey, what happens if the air condition stopped working and ALL the machines heats up and stopped working. Both machine will fail. Worse if that room gets on fire you are out of luck. Move the backup machine at least a couple of rooms away. 4) Use stand by database in another building so in case of a serious problem (11 seqptember) you will not lose all your data, only the data since the last archive. 5) Test, Test, Test again all failure scenarios, and test again each month, quarter or whatever. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Peter Barnett [SMTP:[EMAIL PROTECTED]] Sent: Fri, February 15, 2002 1:04 AM To: Multiple recipients of list ORACLE-L Subject: Oracle Advanced Replication We are looking at Advanced Replication as a fail over option for a web site. Straight forward installation, both boxes on the same subnet on their own dmz. The servers will be located on the same rack in the computer room. Very few tables storing data from an application that is tracking click through data. Does anyone see any flaws with the basic plan? Any hidden 'features' that we may run into? Thanks = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Advanced Replication
Peter - Since nobody seems to be answering your question, I guess you get the second tier here. I have not used Oracle Replication, but I have studied it some. The first thing I seem to always hear about Oracle's Replication is that you must be careful or it won't be able to keep up. The other thing they point out is that the application must be designed for replication, but I'm not sure this applies in the failover application you describe. But it could get messy since you must configure replication on each of your tables. I know that the Replication advocates mention how it can be used for a standby database, and if you had an offsite disaster recovery site, I would say Replication would be worth a look. What you are proposing sounds a lot like Oracle9i's new Real Application Clusters (RAC), or Oracle's Standby database. Another idea if you insist on replication would be to look at Quest's SharePlex. In the worst case, maybe my reply will encourage someone with replication experience to reply. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 14, 2002 5:04 PM To: Multiple recipients of list ORACLE-L We are looking at Advanced Replication as a fail over option for a web site. Straight forward installation, both boxes on the same subnet on their own dmz. The servers will be located on the same rack in the computer room. Very few tables storing data from an application that is tracking click through data. Does anyone see any flaws with the basic plan? Any hidden 'features' that we may run into? Thanks = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Advanced Replication
Howdy, Once the consultants understood their requirements, they did not want the possible down time of a standby database. We actually have a really slick Veritas fail over solution installed but it only works on Solaris and the servers on this project are AIX. Bummer... Pete --- [EMAIL PROTECTED] wrote: Pete, Have you considered using a standby database? More suitable for failover than Advanced Replication, and much easier to implement and maintain. Jared Peter Barnett [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/14/02 03:03 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle Advanced Replication We are looking at Advanced Replication as a fail over option for a web site. Straight forward installation, both boxes on the same subnet on their own dmz. The servers will be located on the same rack in the computer room. Very few tables storing data from an application that is tracking click through data. Does anyone see any flaws with the basic plan? Any hidden 'features' that we may run into? Thanks = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Got something to say? Say it better with Yahoo! Video Mail http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Advanced Replication
Pete, Have you considered using a standby database? More suitable for failover than Advanced Replication, and much easier to implement and maintain. Jared Peter Barnett [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/14/02 03:03 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle Advanced Replication We are looking at Advanced Replication as a fail over option for a web site. Straight forward installation, both boxes on the same subnet on their own dmz. The servers will be located on the same rack in the computer room. Very few tables storing data from an application that is tracking click through data. Does anyone see any flaws with the basic plan? Any hidden 'features' that we may run into? Thanks = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Advanced Replication
This is a project being managed by outside consultants. Their original request was to have two servers each with databases installed. One of these servers was to be shut down sitting next to the primary server. If one failed, fire up the second server, switch the network connection and start the database. Somehow, this did not quite seem right! We finally agreed to try replication. --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Peter - Since nobody seems to be answering your question, I guess you get the second tier here. I have not used Oracle Replication, but I have studied it some. The first thing I seem to always hear about Oracle's Replication is that you must be careful or it won't be able to keep up. The other thing they point out is that the application must be designed for replication, but I'm not sure this applies in the failover application you describe. But it could get messy since you must configure replication on each of your tables. I know that the Replication advocates mention how it can be used for a standby database, and if you had an offsite disaster recovery site, I would say Replication would be worth a look. What you are proposing sounds a lot like Oracle9i's new Real Application Clusters (RAC), or Oracle's Standby database. Another idea if you insist on replication would be to look at Quest's SharePlex. In the worst case, maybe my reply will encourage someone with replication experience to reply. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 14, 2002 5:04 PM To: Multiple recipients of list ORACLE-L We are looking at Advanced Replication as a fail over option for a web site. Straight forward installation, both boxes on the same subnet on their own dmz. The servers will be located on the same rack in the computer room. Very few tables storing data from an application that is tracking click through data. Does anyone see any flaws with the basic plan? Any hidden 'features' that we may run into? Thanks = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Got something to say? Say it better with Yahoo! Video Mail http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Advanced Replication
'Down time', ah. Switching to another machine is not that easy a decision to take. Remember that when you switch from the main machine to its spare, you also jump from an architecture in which you have two machines in synch (more or less), to a single-machine architecture. This is often overlooked, returning to business-as-usual (i.e. resynching two machines) is rarely a piece of cake. In other words, switching to the backup machine is rarely a decision you take lightly. What will happen in practice? Bang, the main server crashes. What will you do? First try to reboot it, it's obviously the simplest solution. Doesn't want to? Try to get hold of a manager, discuss, etc. In the best of case, I doubt that the switch will occur before a quarter of an hour at best (I have the experience of this type of situation on trading floors, where a lot of money is at stake, it was always at least 45mn before users were able to resume business). The possible down time of the standby database is totally negligible compared to all this. I agree with Jared, standby is BY FAR the best solution for this. Put in balance the trouble vs the risks. Peter Barnett wrote: Howdy, Once the consultants understood their requirements, they did not want the possible down time of a standby database. We actually have a really slick Veritas fail over solution installed but it only works on Solaris and the servers on this project are AIX. Bummer... Pete --- [EMAIL PROTECTED] wrote: Pete, Have you considered using a standby database? More suitable for failover than Advanced Replication, and much easier to implement and maintain. Jared Peter Barnett [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/14/02 03:03 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle Advanced Replication We are looking at Advanced Replication as a fail over option for a web site. Straight forward installation, both boxes on the same subnet on their own dmz. The servers will be located on the same rack in the computer room. Very few tables storing data from an application that is tracking click through data. Does anyone see any flaws with the basic plan? Any hidden 'features' that we may run into? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Advanced Replication
---u possible down time of a standby? one out-of-synch condition with Advanced Replication can cause you hours of down time. I'd suggest you continue to question the consultants about the choice of AR as a failover solution. If you're running at least 8.1.7, standby is normally a better choice. AR is a good distributed solution, but not usually a good failover solution. (Unless you can get your hands on Quest's shareplex) Just my .02 Barb -- From: Peter Barnett[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Friday, February 15, 2002 10:38 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Advanced Replication Howdy, Once the consultants understood their requirements, they did not want the possible down time of a standby database. We actually have a really slick Veritas fail over solution installed but it only works on Solaris and the servers on this project are AIX. Bummer... Pete --- [EMAIL PROTECTED] wrote: Pete, Have you considered using a standby database? More suitable for failover than Advanced Replication, and much easier to implement and maintain. Jared Peter Barnett [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/14/02 03:03 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle Advanced Replication We are looking at Advanced Replication as a fail over option for a web site. Straight forward installation, both boxes on the same subnet on their own dmz. The servers will be located on the same rack in the computer room. Very few tables storing data from an application that is tracking click through data. Does anyone see any flaws with the basic plan? Any hidden 'features' that we may run into? Thanks = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Got something to say? Say it better with Yahoo! Video Mail http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Advanced Replication
Pete, I've implemented a very similar solution recently for BEA-based application. Two database servers, Multi-master replication between two databases, 1 minute propagation interval. Works great on our hardware, which was designed for the purpose and is pretty fast. Small transactions - OLTP stuff - seem to replicate well. The same can not be said for large DML operations. So far, I've been unable to tune replication so that it is capable of propagated batch type changes for large amounts of data - the receiving site seems to be converting the DML based on internal algorithm, which throws my indexing approach out of the window. Oracle Support has been of no help, other then suggesting different indexing for failover site. Gary Weber Senior DBA Charles Jones, LLC||Superior Information Services, LLC 609-530-1144, ext 5529 -Original Message- Sent: Thursday, February 14, 2002 5:04 PM To: Multiple recipients of list ORACLE-L We are looking at Advanced Replication as a fail over option for a web site. Straight forward installation, both boxes on the same subnet on their own dmz. The servers will be located on the same rack in the computer room. Very few tables storing data from an application that is tracking click through data. Does anyone see any flaws with the basic plan? Any hidden 'features' that we may run into? Thanks = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Advanced Replication
Title: RE: Oracle Advanced Replication All this talk of replication is really nice. SharePlex for Oracle, can handle master to master replication. Conflicts are handled via pl/sql procedures inside the database, where you can determine exactly what happens when there is a conflict. SharePlex performs really well whether it is a batch program doing massive DML operations, or many small OLTP type transactions. SharePlex can handle around 300-500 DML operations per second in most situations... more if the hardware and database are tuned properly. As for failover, it works VERY well, and can handle many of the datatypes that trigger based replication can not support. LONGs and LONG RAWs especially... One other thing SharePlex can replicate are sequences. If you have sequences that generate PK's or unique keys, then you should probably replicate them, otherwise after a failure, you will have to find out what the highest value for those sequences are for each of your tables, and then rebuild all the sequences. This can take a long time, even on a medium sized database. Just a couple of things to think over, when selecting a replication product. Nick -Original Message- From: Gary Weber [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 10:14 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Advanced Replication Pete, I've implemented a very similar solution recently for BEA-based application. Two database servers, Multi-master replication between two databases, 1 minute propagation interval. Works great on our hardware, which was designed for the purpose and is pretty fast. Small transactions - OLTP stuff - seem to replicate well. The same can not be said for large DML operations. So far, I've been unable to tune replication so that it is capable of propagated batch type changes for large amounts of data - the receiving site seems to be converting the DML based on internal algorithm, which throws my indexing approach out of the window. Oracle Support has been of no help, other then suggesting different indexing for failover site. Gary Weber Senior DBA Charles Jones, LLC||Superior Information Services, LLC 609-530-1144, ext 5529 -Original Message- Sent: Thursday, February 14, 2002 5:04 PM To: Multiple recipients of list ORACLE-L We are looking at Advanced Replication as a fail over option for a web site. Straight forward installation, both boxes on the same subnet on their own dmz. The servers will be located on the same rack in the computer room. Very few tables storing data from an application that is tracking click through data. Does anyone see any flaws with the basic plan? Any hidden 'features' that we may run into? Thanks = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Advanced Replication
Quest also has excellent technical support and are quick with patches (day or 3) if you run into anything really funky. -Original Message- From: Nick Wagner [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 2:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Advanced Replication All this talk of replication is really nice. SharePlex for Oracle, can handle master to master replication. Conflicts are handled via pl/sql procedures inside the database, where you can determine exactly what happens when there is a conflict. SharePlex performs really well whether it is a batch program doing massive DML operations, or many small OLTP type transactions. SharePlex can handle around 300-500 DML operations per second in most situations... more if the hardware and database are tuned properly. As for failover, it works VERY well, and can handle many of the datatypes that trigger based replication can not support. LONGs and LONG RAWs especially... One other thing SharePlex can replicate are sequences. If you have sequences that generate PK's or unique keys, then you should probably replicate them, otherwise after a failure, you will have to find out what the highest value for those sequences are for each of your tables, and then rebuild all the sequences. This can take a long time, even on a medium sized database. Just a couple of things to think over, when selecting a replication product. Nick -Original Message- From: Gary Weber [ mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 10:14 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Advanced Replication Pete, I've implemented a very similar solution recently for BEA-based application. Two database servers, Multi-master replication between two databases, 1 minute propagation interval. Works great on our hardware, which was designed for the purpose and is pretty fast. Small transactions - OLTP stuff - seem to replicate well. The same can not be said for large DML operations. So far, I've been unable to tune replication so that it is capable of propagated batch type changes for large amounts of data - the receiving site seems to be converting the DML based on internal algorithm, which throws my indexing approach out of the window. Oracle Support has been of no help, other then suggesting different indexing for failover site. Gary Weber Senior DBA Charles Jones, LLC||Superior Information Services, LLC 609-530-1144, ext 5529 -Original Message- Sent: Thursday, February 14, 2002 5:04 PM To: Multiple recipients of list ORACLE-L We are looking at Advanced Replication as a fail over option for a web site. Straight forward installation, both boxes on the same subnet on their own dmz. The servers will be located on the same rack in the computer room. Very few tables storing data from an application that is tracking click through data. Does anyone see any flaws with the basic plan? Any hidden 'features' that we may run into? Thanks = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing
RE: Oracle Advanced Replication
Title: RE: Oracle Advanced Replication Nick, DoesSharePlex supportuser definedobject types? Richard -Original Message-From: Nick Wagner [mailto:[EMAIL PROTECTED]]Sent: Friday, February 15, 2002 2:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle Advanced Replication All this talk of replication is really nice. SharePlex for Oracle, can handle master to master replication. Conflicts are handled via pl/sql procedures inside the database, where you can determine exactly what happens when there is a conflict. SharePlex performs really well whether it is a batch program doing massive DML operations, or many small OLTP type transactions. SharePlex can handle around 300-500 DML operations per second in most situations... more if the hardware and database are tuned properly. As for failover, it works VERY well, and can handle many of the datatypes that trigger based replication can not support. LONGs and LONG RAWs especially... One other thing SharePlex can replicate are sequences. If you have sequences that generate PK's or unique keys, then you should probably replicate them, otherwise after a failure, you will have to find out what the highest value for those sequences are for each of your tables, and then rebuild all the sequences. This can take a long time, even on a medium sized database. Just a couple of things to think over, when selecting a replication product. Nick -Original Message- From: Gary Weber [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 10:14 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Advanced Replication Pete, I've implemented a very similar solution recently for BEA-based application. Two database servers, Multi-master replication between two databases, 1 minute propagation interval. Works great on our hardware, which was designed for the purpose and is pretty fast. Small transactions - OLTP stuff - seem to replicate well. The same can not be said for large DML operations. So far, I've been unable to tune replication so that it is capable of propagated batch type changes for large amounts of data - the receiving site seems to be converting the DML based on internal algorithm, which throws my indexing approach out of the window. Oracle Support has been of no help, other then suggesting different indexing for failover site. Gary Weber Senior DBA Charles Jones, LLC||Superior Information Services, LLC 609-530-1144, ext 5529 -Original Message- Sent: Thursday, February 14, 2002 5:04 PM To: Multiple recipients of list ORACLE-L We are looking at Advanced Replication as a fail over option for a web site. Straight forward installation, both boxes on the same subnet on their own dmz. The servers will be located on the same rack in the computer room. Very few tables storing data from an application that is tracking click through data. Does anyone see any flaws with the basic plan? Any hidden 'features' that we may run into? Thanks = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists
Oracle Advanced Replication
We are looking at Advanced Replication as a fail over option for a web site. Straight forward installation, both boxes on the same subnet on their own dmz. The servers will be located on the same rack in the computer room. Very few tables storing data from an application that is tracking click through data. Does anyone see any flaws with the basic plan? Any hidden 'features' that we may run into? Thanks = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
