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, 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 $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
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 $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
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 $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
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 $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
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 $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 $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
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 $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
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
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
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
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
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
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
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
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
Bill - Thank you very much. This is the type of information I was hoping to receive. I'm one of those DBAs who prefer to see the potholes before I fall in them. Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 20, 2002 12:49 PM To: Multiple recipients of list ORACLE-L 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
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
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 P
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
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
I can say that replication is an application solution level which means you can not turn on the switch to get all the applications/tables replicated while on the other hand Standby database is a database level solution that does not have to know anything about the applications/tables hosted by the database. Regards, Waleed -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: Khedr, Waleed 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 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
RE: Replication question
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). > > > > > > > >
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)
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 PROTECTE
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 >
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
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
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
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
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
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
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 happening at different times for different tables. Our key table was replicating IMMEDIATELY upon any 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 real nice advantages of replicated databases. One, they are accessible. i.e. you can run reports, queries, etc on them. They are nothing more than instances that 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 are all 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 application really needs the replication and there is no other simpler option... Just 2 cents... +Rahul
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 in Oracle 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 OPS might 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 application really 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
Why not just Updateable Snapshots? Updateable Snapshots allow users to query and update a local replicated data set even when disconnected from the master site. More relevant is the fact that... Updateable Snapshots require fewer resources than multimaster replication, while still supporting data updates. - Original Message - From: Kevin Lange To: Multiple recipients of list ORACLE-L Sent: Monday, March 04, 2002 10:43 AM Subject: 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 application really 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 happening at different times for different tables. Our key table was replicating IMMEDIATELY upon any 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 real nice advantages of replicated databases. One, they are accessible. i.e. you can run reports, queries, etc on them. They are nothing more than instances that 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 are all 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 application really 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
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 application really 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 application really 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 accept visa 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 application really 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
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 application really 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 believe that schema changes are only automatically propagated to all sites by using the Replication Manager or the 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