RE: Replication question
Title: RE: Replication question We don't update data on slaves, we update data from master then slave pull data from the master every 5 minutes. David -Original Message- From: BigP [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 7:59 PM To: Multiple recipients of list ORACLE-L Subject: Re: Replication question it depends on how you are updating slave databases . -bp - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 22, 2003 3:39 PM We have four machines setup as slave databases which get updated data from one Master database every 5 minutes. The question is how do I know all slave machines get updated data completely from the master database, another word is how do I know there is no missing data when slave machines replicate from the master database? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: BigP 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: Replication question
it depends on how you are updating slave databases . -bp - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 22, 2003 3:39 PM We have four machines setup as slave databases which get updated data from one Master database every 5 minutes. The question is how do I know all slave machines get updated data completely from the master database, another word is how do I know there is no missing data when slave machines replicate from the master database? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: BigP 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: Replication question
Paul - I don't know multimaster replication, so bear with me. I am thumbing through my copy of Oracle Distributed Systems by Charles Dye. Does your question relate to how propagation is controlled? I think propagation is controlled by scheduled jobs. Take a look at the procedure DBMS_DEFER_SYS.SCHEDULE_PUSH, which the book says Schedules an automatic push of the deftran queue to the specified master database. Hope this helps, it may irritate someone that really knows the answer to your question into replying. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, September 04, 2002 8:04 PM To: Multiple recipients of list ORACLE-L When DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT is executed to build the necessary underpinnings for multimaster replication of an object, it creates a package called object_name$RP. This package contains code to be run when rows are inserted, updated, or deleted. There are, however, no trigges in the owning schema, nor in that of the replication administrator. What, then, is the mechanism by which the procedures in this package are called? TIA! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.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 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: Replication question
Paul, The procedures are executed by a special internal trigger. These triggers are also NOT dropped by catrepr.sql (yes, I found out the hard way!). It is documented in metalink. HtH, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Wednesday, September 04, 2002 9:04 PM To: Multiple recipients of list ORACLE-L When DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT is executed to build the necessary underpinnings for multimaster replication of an object, it creates a package called object_name$RP. This package contains code to be run when rows are inserted, updated, or deleted. There are, however, no trigges in the owning schema, nor in that of the replication administrator. What, then, is the mechanism by which the procedures in this package are called? TIA! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.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 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: John Weatherman 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: Replication question
Title: RE: Replication question Great book, I have it too! -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 10:28 AM To: Multiple recipients of list ORACLE-L Subject: RE: Replication question Paul - I don't know multimaster replication, so bear with me. I am thumbing through my copy of Oracle Distributed Systems by Charles Dye. Does your question relate to how propagation is controlled? I think propagation is controlled by scheduled jobs. Take a look at the procedure DBMS_DEFER_SYS.SCHEDULE_PUSH, which the book says Schedules an automatic push of the deftran queue to the specified master database. Hope this helps, it may irritate someone that really knows the answer to your question into replying. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, September 04, 2002 8:04 PM To: Multiple recipients of list ORACLE-L When DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT is executed to build the necessary underpinnings for multimaster replication of an object, it creates a package called object_name$RP. This package contains code to be run when rows are inserted, updated, or deleted. There are, however, no trigges in the owning schema, nor in that of the replication administrator. What, then, is the mechanism by which the procedures in this package are called? TIA! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.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 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: Replication question
Thanks, John. Do you know what mechanism causes the internal triggers to fire? Are the internal triggers created by catrep.sql, or by DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT for each table? Does the RDBMS have to determine whether --- John Weatherman [EMAIL PROTECTED] wrote: Paul, The procedures are executed by a special internal trigger. These triggers are also NOT dropped by catrepr.sql (yes, I found out the hard way!). It is documented in metalink. HtH, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Wednesday, September 04, 2002 9:04 PM To: Multiple recipients of list ORACLE-L When DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT is executed to build the necessary underpinnings for multimaster replication of an object, it creates a package called object_name$RP. This package contains code to be run when rows are inserted, updated, or deleted. There are, however, no trigges in the owning schema, nor in that of the replication administrator. What, then, is the mechanism by which the procedures in this package are called? TIA! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.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 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: John Weatherman 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). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.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 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: Replication question
The jobs are used to propogate the captured transactions. The transactions are captured by the packages called by the internal triggers. PAX, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, September 05, 2002 10:28 AM To: Multiple recipients of list ORACLE-L Paul - I don't know multimaster replication, so bear with me. I am thumbing through my copy of Oracle Distributed Systems by Charles Dye. Does your question relate to how propagation is controlled? I think propagation is controlled by scheduled jobs. Take a look at the procedure DBMS_DEFER_SYS.SCHEDULE_PUSH, which the book says Schedules an automatic push of the deftran queue to the specified master database. Hope this helps, it may irritate someone that really knows the answer to your question into replying. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, September 04, 2002 8:04 PM To: Multiple recipients of list ORACLE-L When DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT is executed to build the necessary underpinnings for multimaster replication of an object, it creates a package called object_name$RP. This package contains code to be run when rows are inserted, updated, or deleted. There are, however, no trigges in the owning schema, nor in that of the replication administrator. What, then, is the mechanism by which the procedures in this package are called? TIA! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.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 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: John Weatherman 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: Replication question
I once noticed this code which is executed (for each column?) when you create a table. Would it be related to replication? BEGIN 2. /* NOP UNLESS A TABLE OBJECT */ 3. IF dictionary_obj_type = 'TABLE' THEN 4. sys.dbms_cdc_publish.change_table_trigger(dictionary_obj_owner,dictionary_obj_name,'LOCK'); 5. END IF; 6. END; Paul Baumgartel [EMAIL PROTECTED]@fatcity.com on 09/05/2002 11:38:25 AM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Thanks, John. Do you know what mechanism causes the internal triggers to fire? Are the internal triggers created by catrep.sql, or by DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT for each table? Does the RDBMS have to determine whether --- John Weatherman [EMAIL PROTECTED] wrote: Paul, The procedures are executed by a special internal trigger. These triggers are also NOT dropped by catrepr.sql (yes, I found out the hard way!). It is documented in metalink. HtH, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Wednesday, September 04, 2002 9:04 PM To: Multiple recipients of list ORACLE-L When DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT is executed to build the necessary underpinnings for multimaster replication of an object, it creates a package called object_name$RP. This package contains code to be run when rows are inserted, updated, or deleted. There are, however, no trigges in the owning schema, nor in that of the replication administrator. What, then, is the mechanism by which the procedures in this package are called? TIA! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.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 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: John Weatherman 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). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.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 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: Replication question
Paul, Dispite being internal the triggers are triggers just like any others. INSERT, UPDATE, DELETE all fire the package (all the transactions you want to move). I have NEVER been clear on the relationship between these triggers and user defined ones, sence you suposedly can't control the order multiple PRE-INSERT triggers, for instance, fire. The internals are created by DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT, which is why the catrepr.sql doesn't know about them. HtH, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, September 05, 2002 11:38 AM To: Multiple recipients of list ORACLE-L Thanks, John. Do you know what mechanism causes the internal triggers to fire? Are the internal triggers created by catrep.sql, or by DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT for each table? Does the RDBMS have to determine whether --- John Weatherman [EMAIL PROTECTED] wrote: Paul, The procedures are executed by a special internal trigger. These triggers are also NOT dropped by catrepr.sql (yes, I found out the hard way!). It is documented in metalink. HtH, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Wednesday, September 04, 2002 9:04 PM To: Multiple recipients of list ORACLE-L When DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT is executed to build the necessary underpinnings for multimaster replication of an object, it creates a package called object_name$RP. This package contains code to be run when rows are inserted, updated, or deleted. There are, however, no trigges in the owning schema, nor in that of the replication administrator. What, then, is the mechanism by which the procedures in this package are called? TIA! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.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 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: John Weatherman 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). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.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 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: John Weatherman 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: Replication Question
So how do I get into the archives? I've got a question I know I've seen answered. Thanks, John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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: Replication Question
John - I've noticed that Google queries pull up info from the archives. Obviously you'll get other stuff, but if you can make your query pretty specific it may get you what you need. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 30, 2002 12:09 PM To: Multiple recipients of list ORACLE-L So how do I get into the archives? I've got a question I know I've seen answered. Thanks, John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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: Replication question
On performance of triggers blocking update of primary keys. There are two aspects to performance. First, that which impacts on cpu cycles etc, and secondly, that which impacts on the integrity of the fundamental database design. I regard the latter as crucial - and non-negotiable. The former is a function of secondary issues such as machine power, load, use profile etc etc. You can see what I am going to say - if Oracle won't protect your PKs from modification, then you must do it yourself, and take any load into account when specifying your hardware platform. I do know of relational databases which will absolutely preclude modification of PKs. It ought to be a given with an RDBMS. As for our situation - no, these triggers don't impact us noticeably, but then we don't run a high tp environment. But I tell you what - they give me enormouse peace of mind! peter edinburgh -Original Message- From: Lowes, Harry (NESL-IT) [mailto:[EMAIL PROTECTED]] Sent: 21 June 2002 13:37 To: Multiple recipients of list ORACLE-L Subject: RE: Replication question Peter, Great idea, but would you care to share the impact of these triggers on performance? I think it's a good principle to follow, but have always found triggers a little unwieldy for most operations myself. I would have thought this to be the case here, but I'd like to hear your experiences on the subject. Thanks awfully, Harry Lowes My enthusiasm for both the job in hand and the welfare of my fellow man knows no bounds. Database Administrator and bon vivante, npower Northern Limited -Original Message- Sent: 21 June 2002 11:49 To: Multiple recipients of list ORACLE-L Interesting comments on replication - but something hit me between the eyes. Primary Keys should NEVER, EVER be permitted to be updated, whether you are using replication or not. Its a basic tenent of relational design. We have been using triggers to prevent this for years. peter edinburgh * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter 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: Lowes, Harry (NESL-IT) 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: Robson, Peter 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: REPLICATION QUESTION - LOng and strange
Sakthi , Raj wrote: Hi Listers, alright I've exhausted almost all my resources and I am turning to my last resource. We have 3 databases. Database A - OLTP Database B - OLTP Database c - DSS ORACLE 8.1.6.3 ON HP-UX 11.0 Database A has a table which is being replicated to C as a read only snapshot and we have long and complex summary process (relic of 1998?s) that works off this snapshot. Now due to some new merger same table need to be created in database B. And yes?the data in table B also need to be replicated to the SAME snapshot in database C so that the summary process can summarize the collective data. The problem is I am sure this could be accomplished. THAT IS TWO MASTERS SITES FEEDING SAME SNAPSHOT?.!!! I have checked the replication manual and Unless I am so sleep deprived that I am missing lines I didn?t find any reference to this kinda replication setup. Any pointers welcome. I am exhausted, so if you don?t mind, if RTFMs could refer the relevant section I am supposed to RTFM, then it would be great. Rewriting the summary process is not an option due to unrealistic deadline. TIA. RS Wouldn't it be possible to replace your current snapshot by a view, the union of one snapshot on A and one snapshot on B? C could the summarize both. -- Regards, Stephane Faroult Oriole Software -- 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: Replication question
Interesting comments on replication - but something hit me between the eyes. Primary Keys should NEVER, EVER be permitted to be updated, whether you are using replication or not. Its a basic tenent of relational design. We have been using triggers to prevent this for years. peter edinburgh * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter 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: Replication question
Peter, Great idea, but would you care to share the impact of these triggers on performance? I think it's a good principle to follow, but have always found triggers a little unwieldy for most operations myself. I would have thought this to be the case here, but I'd like to hear your experiences on the subject. Thanks awfully, Harry Lowes My enthusiasm for both the job in hand and the welfare of my fellow man knows no bounds. Database Administrator and bon vivante, npower Northern Limited -Original Message- Sent: 21 June 2002 11:49 To: Multiple recipients of list ORACLE-L Interesting comments on replication - but something hit me between the eyes. Primary Keys should NEVER, EVER be permitted to be updated, whether you are using replication or not. Its a basic tenent of relational design. We have been using triggers to prevent this for years. peter edinburgh * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter 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: Lowes, Harry (NESL-IT) 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: Replication question
Andy, Consider yourself solicited! I am currently using Datamirror for our tandem db2 to unix oracle replication. The product was not chosen for our oracle to oracle replication for 2 reasons. #1 trigger based. #2 if the source transaction failed to be commited at the target, then the source transaction was actually rolled back. Has this strategy changed? Also, when I did my original research into rpelication products Datamirror products were not using log based replication. You guys having some exciting changes for me over there in beautiful Toronto? Thanks, Hannah ps. you work with Elmer Cecelio? -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Andrew Sit [EMAIL PROTECTED] Sent: Thursday, June 20, 2002 11:19 AM To: Multiple recipients of list ORACLE-L Subject: RE: Replication question Dennis et al: Sorry for the shameless plug, but my company has a number of products that perform oracle-oracle replication as well as DB2/MVS/SQL/ODBC/etc.-Oracle and Oracle-DB2/MVS/SQL/ODBC/etc. replication. Yes, I am an engineer for iReflect which does similar things to shareplex (log-based replication), but also have distinct differences. We are not bound by the issues that oracle replication and shareplex have (i.e. only replicating keyed tables, and DML only), we replicate both non-keyed tables and DDL operations as well. http://www.datamirror.com/products/default.asp Sorry again, will only reply to solicitations from now on... Andy. -- Andrew Sit Systems Engineer DataMirror Corporation (905) 415-0310 x266 (O) (416) 839-9908 (M) -- 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: Replication question
Brian, That is what I wanted to do, but I understood that it would not be *supported* if we ran into issues. Thanks, Hannah -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Brian McGraw [EMAIL PROTECTED] Sent: Thursday, June 20, 2002 11:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Replication question Just a note, Johanna. We put all of our Oracle Replication metadata into separate tablespaces, and had absolutely no problems. Brian -- | Brian McGraw /* DBA */ Infinity Insurance | | 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 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: Replication question
Conflict resolution also has to be considered for log based replication as well. Same problems exist. If you think about it Oracles AQ approach is pretty much a log. Multi-master replication is still trigger/AQ based in 9i. It's working well for us. Some of the things you can do to reduce (but not elleminate) conflict resolution issues are: 1). Stagger sequence generated primary keys by site 2). Put triggers in place to prevent updating of primary keys (avoids some uniqueness conflicts) 3). Add a last_updated_dt to each table and use that as your primary method of update conflict resolution 4). Add a primary site capability for tie breakers. Oracle has a built in method, but it requires you add a site column to each table. If it is not data dependent, I prefer a custom stored procedure method where you choose a primary site that is not data dependent. Deletes are still our biggest problem. Don't really understand why they can't be applied in the same order at the remote site (perhaps because we am using parallel propagation?). But for some reason if we do massive deletes across multiple related tables in the same TX, we always end up having to manually reconcile. An approach recommended by oracle for this is to add a deleted_dt column to every table and do deferred batch deletions. We tried this in conjunction with views and instead of triggers to hide it from the application. A couple of problems with this approach is that if you delete, then try to re-insert with the same alternate key before the deferred purge process runs, you will get ORA-1 errors. If you run the deferred deletion process too often you defeat the purpose of it and overload the system. --- [EMAIL PROTECTED] wrote: Dennis, All dbs whether SQL Server or Oracle need to deal with conflict resolution, thats not strictly an Oracle limitation. As far a Quest goes, they handle replication completely different from Oracle. Oracle itself is still using triggers (in 8i at least) , ubt now they hide the trigger, Shareplex reads the Oracle redo logs. I believe that 9i uses the redo logs and is based (structured) after Shareplex itself - there were lots of articles on this with the pre-release of Dataguard. Furthermore, Oracle places all of its replication metadata in SYSTEM tablespace which I dont like, Sharpelex uses its own (which the user configures). As far as Shareplex manuals, Quest is the one company that I will stand up and say that regardless of anything else, their documention is EXCELLENT. Their documentation takes you from Shareplex architecture right to directory structure, actual files, usage and even scripting. The sales rep was incorrect. However, I can see them not releasing the manuals without a purchase. I believe that they are available on-line for download, though I do not know if it is just for current customers only. (hehe can't believe I am defending a vendor:). But when someone does something right, I like to give credit. Also, once you are setup, they are VERY stable. I have my issues with them, but overall I feel they do great job at what they do. Hannah - Hope it helps any. -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of DENNIS WILLIAMS [EMAIL PROTECTED] Sent: Thursday, June 20, 2002 10:33 AM To: Multiple recipients of list ORACLE-L Subject:RE: Replication question Yechel - Wow, what a blow to be struck with the dreaded RTFM first thing in the morning. Thanks Yechiel, I needed that. Actually, I was hoping there was another resource besides the manual, for two reasons: 1. This development group is a little irritated that they are forced to use Oracle instead of MS SQL, so they are taking replication issues as being Oracle limitations. 2. They have been talking to the Quest salespeople, who naturally heap disdain on Oracle's standard replication (selected Oracle SE because the price was closer to MS SQL). I asked the Quest rep if they had a document similar to the Oracle manual. Gosh, he couldn't think of one. Since nobody on the list has mentioned one, maybe they don't have one. The best resource I've found so far is a former Sybase DBA who was able to confirm that log-based replication has most of the same issues as Oracle standard replication has. Thanks everyone for your replies. Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -- 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
RE: Replication question
Hmmm. Maybe that's changed, but we were actually advised to move the objects when we set them up in v8. -- | Brian McGraw /* DBA */ Infinity Insurance | | mailto:[EMAIL PROTECTED] | -- -Original Message- [EMAIL PROTECTED] Sent: Thursday, June 20, 2002 11:49 AM To: Multiple recipients of list ORACLE-L Brian, That is what I wanted to do, but I understood that it would not be *supported* if we ran into issues. Thanks, Hannah -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Brian McGraw [EMAIL PROTECTED] Sent: Thursday, June 20, 2002 11:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Replication question Just a note, Johanna. We put all of our Oracle Replication metadata into separate tablespaces, and had absolutely no problems. Brian -- | Brian McGraw /* DBA */ Infinity Insurance | | 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 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: Brian McGraw 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: Replication question
Hadn't heard that one. Objects for replication metadata are created in whatever the default tablespace is for SYSTEM. The database create script crdb2.sql changes SYSTEM's default tablespace to TOOLS, so subsequently that's where the objects are created when catrep.sql is run. In my case, that is TOOLS and haven't run into any problems. [EMAIL PROTECTED] wrote: Brian, That is what I wanted to do, but I understood that it would not be *supported* if we ran into issues. Thanks, Hannah -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Brian McGraw [EMAIL PROTECTED] Sent: Thursday, June 20, 2002 11:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Replication question Just a note, Johanna. We put all of our Oracle Replication metadata into separate tablespaces, and had absolutely no problems. Brian -- | Brian McGraw /* DBA */ Infinity Insurance | | 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 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: Suzy Vordos 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: Replication question
There is also a note (1037317.6) that documents moving the replication base tables to another tablespace (which Oracle Recommends). Funny how alot of the Oracle Recommendations are in notes instead of the documentation. --- Suzy Vordos [EMAIL PROTECTED] wrote: Hadn't heard that one. Objects for replication metadata are created in whatever the default tablespace is for SYSTEM. The database create script crdb2.sql changes SYSTEM's default tablespace to TOOLS, so subsequently that's where the objects are created when catrep.sql is run. In my case, that is TOOLS and haven't run into any problems. [EMAIL PROTECTED] wrote: Brian, That is what I wanted to do, but I understood that it would not be *supported* if we ran into issues. Thanks, Hannah -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Brian McGraw [EMAIL PROTECTED] Sent: Thursday, June 20, 2002 11:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Replication question Just a note, Johanna. We put all of our Oracle Replication metadata into separate tablespaces, and had absolutely no problems. Brian -- | Brian McGraw /* DBA */ Infinity Insurance | | 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 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: Suzy Vordos 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). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Pass 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: Replication question
Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 14, 2002 10:58 AM We are just starting to look at replication so each manufacturing plant can have their own server. The applications are being developed in-house. I feel the first issue is to analyze each table and decide how it will be replicated and what schema changes need to me made to accommodate replication. Instead, one of the developers wants to talk to Quest about their solution. It seems to me that you need to make the same evaluation and schema changes where needed. If anyone can point me to a white paper on schema changes to consider, that would be appreciated. Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -- 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: mitchell 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: Replication question
Mitchell, There are a LOT of good papers in Metalink. I've been getting my own education over the last few months. Replication is a really great swiss army knife though, you need to do a little looking for what you specifically need to do, then test, test, test. Oh, and did I mention test? :) I found Note: 138181.1 particularly helpful. Oh, and plan on some TARs. I have found Support very helpful/informative in this area. Good Luck, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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: Replication question
Mitchell - My knowledge is mostly from reading at this point, but here are some thoughts that a colleague provided from his experience: - backup and recovery is much more complicated in a replicated environment so it needs to be planned - replicated databases inevitably get out of sync so some process outside the usual replication method must be built to re-sync the databases. this can either be done proactively or reactively - proactive is more fun. - a process to monitor the overall health of the replicated environment is a good idea. i.e. how latent are the transactions, are the replicated transactions actually being replicated, have there been any data conflicts. - schema changes get real fun. planning ahead again a good idea. - additional testing is needed to prove the replication will work especially on the performance front. I have found only two books on replication (is that a hint that most sites avoid it??) Oracle Distributed Systems by Charles Dye, O'Reilly 1999 Data Replication by Marie Buretta, Wiley 1997 -Original Message- Sent: Friday, June 14, 2002 11:05 AM To: Multiple recipients of list ORACLE-L Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 14, 2002 10:58 AM We are just starting to look at replication so each manufacturing plant can have their own server. The applications are being developed in-house. I feel the first issue is to analyze each table and decide how it will be replicated and what schema changes need to me made to accommodate replication. Instead, one of the developers wants to talk to Quest about their solution. It seems to me that you need to make the same evaluation and schema changes where needed. If anyone can point me to a white paper on schema changes to consider, that would be appreciated. Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -- 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: mitchell 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: Replication question
Curious, that note suggests Advanced Replication as a failover methodology. Seems that a standby database would be _much_ simpler. Any thoughts ( from anyone ) on why one would use AR for failover, rather than using a standby database? Jared John Weatherman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/14/2002 09:50 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Replication question Mitchell, There are a LOT of good papers in Metalink. I've been getting my own education over the last few months. Replication is a really great swiss army knife though, you need to do a little looking for what you specifically need to do, then test, test, test. Oh, and did I mention test? :) I found Note: 138181.1 particularly helpful. Oh, and plan on some TARs. I have found Support very helpful/informative in this area. Good Luck, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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: Replication question
Jarad, A standby is simpler, however it has limited use for offloading some system load (opening for read access suspends roll forward, so the data is somewhat stale). By using Master-Master synchronous replication with good deadlock handlers, you can use BOTH instances so you get the benefit of not having an unused instance lying around (damagement hates that), but still have fail over available. Since you can have different users/locations attach to different instances, you also get some scalability advantages. In general, I agree a standby is MUCH simpler. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 1:41 PM To: Multiple recipients of list ORACLE-L Curious, that note suggests Advanced Replication as a failover methodology. Seems that a standby database would be _much_ simpler. Any thoughts ( from anyone ) on why one would use AR for failover, rather than using a standby database? Jared John Weatherman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/14/2002 09:50 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Replication question Mitchell, There are a LOT of good papers in Metalink. I've been getting my own education over the last few months. Replication is a really great swiss army knife though, you need to do a little looking for what you specifically need to do, then test, test, test. Oh, and did I mention test? :) I found Note: 138181.1 particularly helpful. Oh, and plan on some TARs. I have found Support very helpful/informative in this area. Good Luck, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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: Replication question
or you can use the logical standby feature of 9.2 and then have both databases open. Replication bothers me when I start to think about synchronous vs asynchronous. Async doesn't hold up the primary site from continuing on, but the databases are not true copies of one another. Sync are true copies but you can hold up the commit waiting for a return from the remote site. And if it fails, it's messy to clean up --- John Weatherman [EMAIL PROTECTED] wrote: Jarad, A standby is simpler, however it has limited use for offloading some system load (opening for read access suspends roll forward, so the data is somewhat stale). By using Master-Master synchronous replication with good deadlock handlers, you can use BOTH instances so you get the benefit of not having an unused instance lying around (damagement hates that), but still have fail over available. Since you can have different users/locations attach to different instances, you also get some scalability advantages. In general, I agree a standby is MUCH simpler. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 1:41 PM To: Multiple recipients of list ORACLE-L Curious, that note suggests Advanced Replication as a failover methodology. Seems that a standby database would be _much_ simpler. Any thoughts ( from anyone ) on why one would use AR for failover, rather than using a standby database? Jared John Weatherman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/14/2002 09:50 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Replication question Mitchell, There are a LOT of good papers in Metalink. I've been getting my own education over the last few months. Replication is a really great swiss army knife though, you need to do a little looking for what you specifically need to do, then test, test, test. Oh, and did I mention test? :) I found Note: 138181.1 particularly helpful. Oh, and plan on some TARs. I have found Support very helpful/informative in this area. Good Luck, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Replication question
Title: RE: Replication question Another potential HA use of AR is that you can use different platforms in an HA configuration. You can fail over to another platform with some idle capacity or a workload that can be shifted around until the failed services are restored. Yet another is during planned downtime when upgrading Oracle and OS versions. You could upgrade the target while the source is the actively used node. Then move the users off the source and let the remaining changes post to the target. Now reverse the replication source/target roles and upgrade the old source (now they new target) an let it be until the next time. The outage should be shorter. The same technique could be used to roll back to a usable database after an major application change. Just change the target and let the users try things out. If there's a problem point them back to the source and regroup. It should be much quicker that undoing the changes. Just some thoughts. Tony Aponte -Original Message- From: John Weatherman [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: Replication question Jarad, A standby is simpler, however it has limited use for offloading some system load (opening for read access suspends roll forward, so the data is somewhat stale). By using Master-Master synchronous replication with good deadlock handlers, you can use BOTH instances so you get the benefit of not having an unused instance lying around (damagement hates that), but still have fail over available. Since you can have different users/locations attach to different instances, you also get some scalability advantages. In general, I agree a standby is MUCH simpler. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 1:41 PM To: Multiple recipients of list ORACLE-L Curious, that note suggests Advanced Replication as a failover methodology. Seems that a standby database would be _much_ simpler. Any thoughts ( from anyone ) on why one would use AR for failover, rather than using a standby database? Jared John Weatherman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/14/2002 09:50 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: Replication question Mitchell, There are a LOT of good papers in Metalink. I've been getting my own education over the last few months. Replication is a really great swiss army knife though, you need to do a little looking for what you specifically need to do, then test, test, test. Oh, and did I mention test? :) I found Note: 138181.1 particularly helpful. Oh, and plan on some TARs. I have found Support very helpful/informative in this area. Good Luck, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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
RE: Replication question
All very true. Of course the doc in question was written for 8i, so that explains some of it. :) Question: Does logical standby in 9.2 work across platforms? Haven't had too much time to look at new 9.2 features I'm afraid. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 2:57 PM To: Multiple recipients of list ORACLE-L or you can use the logical standby feature of 9.2 and then have both databases open. Replication bothers me when I start to think about synchronous vs asynchronous. Async doesn't hold up the primary site from continuing on, but the databases are not true copies of one another. Sync are true copies but you can hold up the commit waiting for a return from the remote site. And if it fails, it's messy to clean up --- John Weatherman [EMAIL PROTECTED] wrote: Jarad, A standby is simpler, however it has limited use for offloading some system load (opening for read access suspends roll forward, so the data is somewhat stale). By using Master-Master synchronous replication with good deadlock handlers, you can use BOTH instances so you get the benefit of not having an unused instance lying around (damagement hates that), but still have fail over available. Since you can have different users/locations attach to different instances, you also get some scalability advantages. In general, I agree a standby is MUCH simpler. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 1:41 PM To: Multiple recipients of list ORACLE-L Curious, that note suggests Advanced Replication as a failover methodology. Seems that a standby database would be _much_ simpler. Any thoughts ( from anyone ) on why one would use AR for failover, rather than using a standby database? Jared John Weatherman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/14/2002 09:50 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Replication question Mitchell, There are a LOT of good papers in Metalink. I've been getting my own education over the last few months. Replication is a really great swiss army knife though, you need to do a little looking for what you specifically need to do, then test, test, test. Oh, and did I mention test? :) I found Note: 138181.1 particularly helpful. Oh, and plan on some TARs. I have found Support very helpful/informative in this area. Good Luck, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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). __ Do You Yahoo!? Yahoo! - Official
RE: Replication question
Thanks! John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 4:10 PM To: Multiple recipients of list ORACLE-L Cross-platform is the whole reason for logical standby -- it's SQL statements that get applied to the secondary database --- John Weatherman [EMAIL PROTECTED] wrote: All very true. Of course the doc in question was written for 8i, so that explains some of it. :) Question: Does logical standby in 9.2 work across platforms? Haven't had too much time to look at new 9.2 features I'm afraid. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 2:57 PM To: Multiple recipients of list ORACLE-L or you can use the logical standby feature of 9.2 and then have both databases open. Replication bothers me when I start to think about synchronous vs asynchronous. Async doesn't hold up the primary site from continuing on, but the databases are not true copies of one another. Sync are true copies but you can hold up the commit waiting for a return from the remote site. And if it fails, it's messy to clean up --- John Weatherman [EMAIL PROTECTED] wrote: Jarad, A standby is simpler, however it has limited use for offloading some system load (opening for read access suspends roll forward, so the data is somewhat stale). By using Master-Master synchronous replication with good deadlock handlers, you can use BOTH instances so you get the benefit of not having an unused instance lying around (damagement hates that), but still have fail over available. Since you can have different users/locations attach to different instances, you also get some scalability advantages. In general, I agree a standby is MUCH simpler. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 1:41 PM To: Multiple recipients of list ORACLE-L Curious, that note suggests Advanced Replication as a failover methodology. Seems that a standby database would be _much_ simpler. Any thoughts ( from anyone ) on why one would use AR for failover, rather than using a standby database? Jared John Weatherman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/14/2002 09:50 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Replication question Mitchell, There are a LOT of good papers in Metalink. I've been getting my own education over the last few months. Replication is a really great swiss army knife though, you need to do a little looking for what you specifically need to do, then test, test, test. Oh, and did I mention test? :) I found Note: 138181.1 particularly helpful. Oh, and plan on some TARs. I have found Support very helpful/informative in this area. Good Luck, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public
Re: Replication Question
Hello John We are doing master to master replication. Both are 8.1.6 on NT. When we need to rebuild we delete and create both databases and import the data into both. Then we run a script that dynamically generate the proper procedure calls for all the tables in the schema and run them. I think that the trick is using copy_rows = false so the replication does not copy all the data again. Note 120686.1 is quite correct. However I used scripts for all the work. Gave the script to the application supervisor and he runs it whenever he rebuilds the databases (also scripts). The process is long (some hours) as we have about 500 tables to build replication for. One more point: The docs talk about replication manager user, propagator user and receiving user. We used repadmin for all the functions. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 10, 2002 5:09 PM Hi All, I have recently been handed the task of setting up master-master replication on our existing production environment (yes, I am in test to start!). Because this is an established site with a lot of historical data, we would like to use Offline Instantiation as detailed in Note 68657.1. We had an Oracle Consultant in here who said this was the best approach. However as I started digging, I discovered Note 120686.1, which indicates that the other note only really applies when adding a new master to an existing replicated system. Problems with referential integrity seem to blow the note apart when working with an existing, non-replicated production system. SO, my question is, has anybody successfully managed offline instantiation for converting an existing non-replicated system into a master-master replicated system? How did you deal with the constraints issue? Of course this is made even more complicated by having the original master be an 8i instance and the new master be a 9i instance. I'm thinking that setting the 9i compatable init parameter to match the 8i instance should allow things to work. Any experience running a replicated master-master system with differing version of Oracle for the masters? Any special gotchas I should be aware of? Thanks for any and all help! Pax, John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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: Yechiel Adar 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: replication question
Depends on your need. You can have read only snapshots, updatable snapshots or multimaster... Again if you think of multimaster... then you would need to make decision based on your application requirements about sync or async I donot have any expereince of snapshot replication. But, if you are planning multimaster replication, then better spend a couple of months studying it and testing on test boxes... Make 100% sure that your applicationreally needs the replication and there is no other simpler option... Just 2 cents... +Rahul - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Monday, March 04, 2002 3:33 AM Subject: replication question Dear Gurus, The clients will enter records to a database all day and I will update the other database . I need to replicate 10 tables in a database to other database at a specific time. Do I need Advanced replication or basic replication . ? How can I understand that replication is supported in my both databases. ? Bunyamin
Re: replication question
Thank you Rahul , Do you acceptvisa or bank check ? :) Bunyamin - Original Message - From: Rahul Dandekar To: Multiple recipients of list ORACLE-L Sent: Monday, March 04, 2002 2:43 PM Subject: Re: replication question Depends on your need. You can have read only snapshots, updatable snapshots or multimaster... Again if you think of multimaster... then you would need to make decision based on your application requirements about sync or async I donot have any expereince of snapshot replication. But, if you are planning multimaster replication, then better spend a couple of months studying it and testing on test boxes... Make 100% sure that your applicationreally needs the replication and there is no other simpler option... Just 2 cents... +Rahul - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Monday, March 04, 2002 3:33 AM Subject: replication question Dear Gurus, The clients will enter records to a database all day and I will update the other database . I need to replicate 10 tables in a database to other database at a specific time. Do I need Advanced replication or basic replication . ? How can I understand that replication is supported in my both databases. ? Bunyamin
RE: replication question
The way I see it . the question comes down to whether or not you need two way replication or just one way. If both databases can update those tables and you need them synced between the databases then Advanced Replication would be the route. If all you need are data changes from 1 database to be replicated to another database then simple replication is all you need. -Original Message-From: Rahul Dandekar [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 6:43 AMTo: Multiple recipients of list ORACLE-LSubject: Re: replication question Depends on your need. You can have read only snapshots, updatable snapshots or multimaster... Again if you think of multimaster... then you would need to make decision based on your application requirements about sync or async I donot have any expereince of snapshot replication. But, if you are planning multimaster replication, then better spend a couple of months studying it and testing on test boxes... Make 100% sure that your applicationreally needs the replication and there is no other simpler option... Just 2 cents... +Rahul - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Monday, March 04, 2002 3:33 AM Subject: replication question Dear Gurus, The clients will enter records to a database all day and I will update the other database . I need to replicate 10 tables in a database to other database at a specific time. Do I need Advanced replication or basic replication . ? How can I understand that replication is supported in my both databases. ? Bunyamin
RE: replication question
Is replication faster than a standby database.As I understand it, the standby database will be receive arch logs at preset intervals. Does replication have the same functionality and about how much data is sent to the replicated site. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent: Monday, March 04, 2002 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: replication question The way I see it . the question comes down to whether or not you need two way replication or just one way. If both databases can update those tables and you need them synced between the databases then Advanced Replication would be the route. If all you need are data changes from 1 database to be replicated to another database then simple replication is all you need. -Original Message-From: Rahul Dandekar [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 6:43 AMTo: Multiple recipients of list ORACLE-LSubject: Re: replication question Depends on your need. You can have read only snapshots, updatable snapshots or multimaster... Again if you think of multimaster... then you would need to make decision based on your application requirements about sync or async I donot have any expereince of snapshot replication. But, if you are planning multimaster replication, then better spend a couple of months studying it and testing on test boxes... Make 100% sure that your applicationreally needs the replication and there is no other simpler option... Just 2 cents... +Rahul - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Monday, March 04, 2002 3:33 AM Subject: replication question Dear Gurus, The clients will enter records to a database all day and I will update the other database . I need to replicate 10 tables in a database to other database at a specific time. Do I need Advanced replication or basic replication . ? How can I understand that replication is supported in my both databases. ? Bunyamin
RE: replication question
I have used both. Replication, like archive log movement , happens whenever you set it up to happen. That can be anywhere from every minute to once a day to beyond. It just depends on your needs. In the case of my old job, we had replication happeningat different times for different tables. Our key table was replicating IMMEDIATELY uponany changes to the parent table. This happened via trigger.Other , not so important tables, would replicate at anywhere from 30 to 60 minutes. We did this using scheduled jobs. I see two realnice advantages ofreplicated databases. One, they are accessible.i.e. you can run reports, queries, etc on them. They are nothing more than instancesthat get updated via a foreign database. Two,depending on what kind of software you use, you can update the database from an outside source. We used to have data sent down from our DB2 database into our Oracle database using an oracle product called Replication Services (nothing more than triggers and a specific data structure) and an IBM product called Data Propogator. Archive log transport for standbys can happen in multiple ways also. The newer oracle versions support direct archiving from a production database to a standby database. I have not tried this yet but we are looking into it. Our current standby databases are brought up to date with a shell script that is scheduled via cron every 20 minutes. The thing about the standbys, they areall or nothing ... you can not just say I want only tables 1-10 to be updated. They all are. Also, in the older oracle versions, the standbys could not be accessed via software so you could not use them as any sort of read only database. This is not the case in a replicated database. But, they are also very easy to rebuild and resetup. Just copy your production files over, create a standby control file, and bring the databse up in standby mode. Very easy. Now... which would I recommend ??? Depends on your needs. If you really need to access that copy of the database for other purposes and you only want certain tables to be updated, then I would consider replication. If, on the other hand, you do not have to access the data (until such a time as your production gets killed and you need your standby up) and you need a fast way to rebuild the second database, I would suggest the Standby approach. Kevin -Original Message-From: James Ambursley [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 12:24 PMTo: Multiple recipients of list ORACLE-LSubject: RE: replication question Is replication faster than a standby database.As I understand it, the standby database will be receive arch logs at preset intervals. Does replication have the same functionality and about how much data is sent to the replicated site. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent: Monday, March 04, 2002 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: replication question The way I see it . the question comes down to whether or not you need two way replication or just one way. If both databases can update those tables and you need them synced between the databases then Advanced Replication would be the route. If all you need are data changes from 1 database to be replicated to another database then simple replication is all you need. -Original Message-From: Rahul Dandekar [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 6:43 AMTo: Multiple recipients of list ORACLE-LSubject: Re: replication question Depends on your need. You can have read only snapshots, updatable snapshots or multimaster... Again if you think of multimaster... then you would need to make decision based on your application requirements about sync or async I donot have any expereince of snapshot replication. But, if you are planning multimaster replication, then better spend a couple of months studying it and testing on test boxes... Make 100% sure that your applicationreally needs the replication and there is no other simpler option... Just 2 cents... +Rahul - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Monday, March 04, 2002 3:33 AM Subject: replication question Dear Gurus, The clients will enter records to a database all day and I will update the other database . I need to replicate 10 tables in a database to other database at a specific time. Do I need Advanced replication or basic replication . ? How can I understand that replication
Re: replication question
Well, you could open standby DB only for read only access (8i) whereas in replication, both or all (more than 2) databases could be up and open to users all the times. Each DML causes substantial overhead as each transaction needs to be propogated and applied at all the master sites (whereas inOracle Parallel Server,there is centralized database accessed by multiple instances, there is no need for this). So, if you donot need two databases at two geographically separate locations, open for users, then Standby DB or OPSmight be better option. Again, in OPS, if the hardware cluster fails then you are in trouble... About speed, if you could tune up sending of logs and application of it, then Standby database would consume substantially lesser resources than replication, hence higher throughput... The primary database in Standby DB just needs to send the archivelogs (simple file transfer) and then log application happens on the secondary server... Whereas, in replication, the database would have to propogate and apply each and every transaction individually +Rahul - Original Message - From: James Ambursley To: Multiple recipients of list ORACLE-L Sent: Monday, March 04, 2002 1:24 PM Subject: RE: replication question Is replication faster than a standby database.As I understand it, the standby database will be receive arch logs at preset intervals. Does replication have the same functionality and about how much data is sent to the replicated site. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent: Monday, March 04, 2002 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: replication question The way I see it . the question comes down to whether or not you need two way replication or just one way. If both databases can update those tables and you need them synced between the databases then Advanced Replication would be the route. If all you need are data changes from 1 database to be replicated to another database then simple replication is all you need. -Original Message-From: Rahul Dandekar [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 6:43 AMTo: Multiple recipients of list ORACLE-LSubject: Re: replication question Depends on your need. You can have read only snapshots, updatable snapshots or multimaster... Again if you think of multimaster... then you would need to make decision based on your application requirements about sync or async I donot have any expereince of snapshot replication. But, if you are planning multimaster replication, then better spend a couple of months studying it and testing on test boxes... Make 100% sure that your applicationreally needs the replication and there is no other simpler option... Just 2 cents... +Rahul - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Monday, March 04, 2002 3:33 AM Subject: replication question Dear Gurus, The clients will enter records to a database all day and I will update the other database . I need to replicate 10 tables in a database to other database at a specific time. Do I need Advanced replication or basic replication . ? How can I understand that replication is supported in my both databases. ? Bunyamin
RE: replication question
Thanks tons Kevin, that is the information I was looking for. Great, quick response. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent: Monday, March 04, 2002 2:43 PMTo: Multiple recipients of list ORACLE-LSubject: RE: replication question I have used both. Replication, like archive log movement , happens whenever you set it up to happen. That can be anywhere from every minute to once a day to beyond. It just depends on your needs. In the case of my old job, we had replication happeningat different times for different tables. Our key table was replicating IMMEDIATELY uponany changes to the parent table. This happened via trigger.Other , not so important tables, would replicate at anywhere from 30 to 60 minutes. We did this using scheduled jobs. I see two realnice advantages ofreplicated databases. One, they are accessible.i.e. you can run reports, queries, etc on them. They are nothing more than instancesthat get updated via a foreign database. Two,depending on what kind of software you use, you can update the database from an outside source. We used to have data sent down from our DB2 database into our Oracle database using an oracle product called Replication Services (nothing more than triggers and a specific data structure) and an IBM product called Data Propogator. Archive log transport for standbys can happen in multiple ways also. The newer oracle versions support direct archiving from a production database to a standby database. I have not tried this yet but we are looking into it. Our current standby databases are brought up to date with a shell script that is scheduled via cron every 20 minutes. The thing about the standbys, they areall or nothing ... you can not just say I want only tables 1-10 to be updated. They all are. Also, in the older oracle versions, the standbys could not be accessed via software so you could not use them as any sort of read only database. This is not the case in a replicated database. But, they are also very easy to rebuild and resetup. Just copy your production files over, create a standby control file, and bring the databse up in standby mode. Very easy. Now... which would I recommend ??? Depends on your needs. If you really need to access that copy of the database for other purposes and you only want certain tables to be updated, then I would consider replication. If, on the other hand, you do not have to access the data (until such a time as your production gets killed and you need your standby up) and you need a fast way to rebuild the second database, I would suggest the Standby approach. Kevin -Original Message-From: James Ambursley [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 12:24 PMTo: Multiple recipients of list ORACLE-LSubject: RE: replication question Is replication faster than a standby database.As I understand it, the standby database will be receive arch logs at preset intervals. Does replication have the same functionality and about how much data is sent to the replicated site. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent: Monday, March 04, 2002 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: replication question The way I see it . the question comes down to whether or not you need two way replication or just one way. If both databases can update those tables and you need them synced between the databases then Advanced Replication would be the route. If all you need are data changes from 1 database to be replicated to another database then simple replication is all you need. -Original Message-From: Rahul Dandekar [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 6:43 AMTo: Multiple recipients of list ORACLE-LSubject: Re: replication question Depends on your need. You can have read only snapshots, updatable snapshots or multimaster... Again if you think of multimaster... then you would need to make decision based on your application requirements about sync or async I donot have any expereince of snapshot replication. But, if you are planning multimaster replication, then better spend a couple of months studying it and testing on test boxes... Make 100% sure that your applicationreally needs the replication and there is no other simpler option... Just 2 cents... +Rahul - Original Message - From: Bunyamin K
RE: Replication question
I believe that schema changes are only automatically propagated to all sites by using the Replication Manager orthe DBMS_REPCAT package. Nancy -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of ALEMU AbiySent: Monday, November 12, 2001 1:40 AMTo: Multiple recipients of list ORACLE-LSubject: Replication question I'm setting up a basic replication on a 8.1.7 oracle database and I'm wondering if a schema change is also replicated along with data changes. If I modify the structure of a table on the master site, is that modification is propagated to my snapshot site ? Please help