8.1.7 Base - Replication Question
LG, Is it possible to establish further downstream snapshot replication from a snapshot site in 8.1.7.0.0/Solaris 2.8? I know this can be done in 8.1.7.4.x and 9i and I can not build multi-master replication due to restrictions :-( i.e. I'd like to perform: master -- snapshot (new master) -- snapshot Many Thanks, Nikhil Khimani -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nikhil Khimani 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).
A basic replication question
Okay, we have a request for quite a few of our customers for read-only copies of their databases they can do their ad-hoc queries on. These read-only databases need to as closely matched to the production database as possible, i.e., exact, from their point of view. I've looked into some options to do this. Since we're going to 9i fairly soon I was thinking of setting up logical standbys, but I've read some pretty bad things about logical standbys -- typical new buggy Oracle product. I've also started into looking at basic replication: maybe just simple updateable snapshots refreshed every now and then. So, for the past couple of days I've gone through Metalink, Technet, and the mail archives on Oracle-l trying to learn about simple, basic, readonly replication. The problem is, all of the manuals, white papers, etc. I've found don't deal with how to set up and administer simple basic replication. It's all mixed in with multi-master replication, Advanced Replication, and stuff like that. I'm new to replication and would like to basically start learning the basics for basic replication, basically. Can anyone point me to a document that talks about basic read-only replication only? Or am I fooling myself into thinking there is such a thing? Thanks, --Walt Weaver Bozeman, Montana -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weaver, Walt 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: A basic replication question
Walt, I presented a paper at IOUG Live 2003 and wrote an article on DBAZine on an issue similar to this. Although the issue addressed was something much more complex; the article does have scripts to set up a basic readonly snapshot (or MV) replication. The article is at http://www.dbazine.com/nanda2.html. Hope you will find it useful. Best reagrds, Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 12:29 PM Okay, we have a request for quite a few of our customers for read-only copies of their databases they can do their ad-hoc queries on. These read-only databases need to as closely matched to the production database as possible, i.e., exact, from their point of view. I've looked into some options to do this. Since we're going to 9i fairly soon I was thinking of setting up logical standbys, but I've read some pretty bad things about logical standbys -- typical new buggy Oracle product. I've also started into looking at basic replication: maybe just simple updateable snapshots refreshed every now and then. So, for the past couple of days I've gone through Metalink, Technet, and the mail archives on Oracle-l trying to learn about simple, basic, readonly replication. The problem is, all of the manuals, white papers, etc. I've found don't deal with how to set up and administer simple basic replication. It's all mixed in with multi-master replication, Advanced Replication, and stuff like that. I'm new to replication and would like to basically start learning the basics for basic replication, basically. Can anyone point me to a document that talks about basic read-only replication only? Or am I fooling myself into thinking there is such a thing? Thanks, --Walt Weaver Bozeman, Montana -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weaver, Walt 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: Arup Nanda 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: A basic replication question
I have attached some generic scripts for creating the snapshots and refresh procedures. The only item missing is the database link. Basic outline: 1. create database link 2. create snapshot logs on primary 3. create snapshots on copy 4. run a full refresh 5. run a fast refresh 6. setup jobs with force refresh Regards, -Daniel -- Daniel Harron Database Management IPsoft, Inc. [EMAIL PROTECTED] http://www.ip-soft.net/ Phone: 888.IPSOFT8 Fax: 801.681.7664 snapshot_create.sql Description: Binary data snapshot_log_create.sql Description: Binary data snapshot_refresh_all_atomic.sql Description: Binary data
RE: A basic replication question
Weaver, Walt scribbled on the wall in glitter crayon: Okay, we have a request for quite a few of our customers for read-only copies of their databases they can do their ad-hoc queries on. These read-only databases need to as closely matched to the production database as possible, i.e., exact, from their point of view. can they use a read only login for it? just set up a username with no quota and grant it select on the tables it needs. or am i missing something here? -- Bill Shrek Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] Making allowances for human imperfections, I do feel that in America the most valuable thing in life is possible; the development of the individual and his creative powers. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William 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: A basic replication question
Well, that's what the users want. :) But, due to the way our web hosting security is set up we can't do it. --Walt -Original Message- From: Thater, William [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 11:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: A basic replication question Weaver, Walt scribbled on the wall in glitter crayon: Okay, we have a request for quite a few of our customers for read-only copies of their databases they can do their ad-hoc queries on. These read-only databases need to as closely matched to the production database as possible, i.e., exact, from their point of view. can they use a read only login for it? just set up a username with no quota and grant it select on the tables it needs. or am i missing something here? -- Bill Shrek Thater ORACLE DBA BAARF Party member #25 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weaver, Walt 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: A basic replication question
ad-hoc queries as in, we'll write something that will bring your database to its knees that kind of reporting, it's better to have a separate database --- Thater, William [EMAIL PROTECTED] wrote: Weaver, Walt scribbled on the wall in glitter crayon: Okay, we have a request for quite a few of our customers for read-only copies of their databases they can do their ad-hoc queries on. These read-only databases need to as closely matched to the production database as possible, i.e., exact, from their point of view. can they use a read only login for it? just set up a username with no quota and grant it select on the tables it needs. or am i missing something here? -- Bill Shrek Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] Making allowances for human imperfections, I do feel that in America the most valuable thing in life is possible; the development of the individual and his creative powers. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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: A basic replication question
Some issues to think about here: Do they really need all the data from production? Or are they just saying that without any justification... Do they know what questions they are going to ask? Or is this a fishing expedition. Are they going to understand ad-hoc development will continue to not occur in production? Do they understand the complexity and cost associated this what they are asking for? And can they justify the resource requirements and cost with a ROI study? Are these request coming from users or management? Did someone recently go to some buiness intelligence conference? Anyone download some sexy new query tool? How many users is quite a few? Frankly Walt I would be careful about opening that ad-hoc door. the next thing you will have is a real CF on your hands and lots of regrets. I would aim for a data mart and extracting the information needed for specific uses that have actual business value. Charge them to give specific examples that are valuable to the company. Unless of course this is a true vendor-customer relationship and they are going to pay actual money for this. Then sell away...If it is an internal customer then I would be cautious. Having said that you can make a copy of the database during backups and use to create a new instance of the same db. We do that here. Catch is all that work and disk space goes unused. because the users need real time data access for thier ad-hoc activity and reports... Brad O. -Original Message- Sent: Wednesday, September 03, 2003 11:29 AM To: Multiple recipients of list ORACLE-L Okay, we have a request for quite a few of our customers for read-only copies of their databases they can do their ad-hoc queries on. These read-only databases need to as closely matched to the production database as possible, i.e., exact, from their point of view. I've looked into some options to do this. Since we're going to 9i fairly soon I was thinking of setting up logical standbys, but I've read some pretty bad things about logical standbys -- typical new buggy Oracle product. I've also started into looking at basic replication: maybe just simple updateable snapshots refreshed every now and then. So, for the past couple of days I've gone through Metalink, Technet, and the mail archives on Oracle-l trying to learn about simple, basic, readonly replication. The problem is, all of the manuals, white papers, etc. I've found don't deal with how to set up and administer simple basic replication. It's all mixed in with multi-master replication, Advanced Replication, and stuff like that. I'm new to replication and would like to basically start learning the basics for basic replication, basically. Can anyone point me to a document that talks about basic read-only replication only? Or am I fooling myself into thinking there is such a thing? Thanks, --Walt Weaver Bozeman, Montana -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weaver, Walt 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: Odland, Brad 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
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).
Replication question
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).
Re: Replication question
it depends on how you are updating slave databases . -bp - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 22, 2003 3:39 PM We have four machines setup as slave databases which get updated data from one Master database every 5 minutes. The question is how do I know all slave machines get updated data completely from the master database, another word is how do I know there is no missing data when slave machines replicate from the master database? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: BigP INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Replication question
Paul - I don't know multimaster replication, so bear with me. I am thumbing through my copy of Oracle Distributed Systems by Charles Dye. Does your question relate to how propagation is controlled? I think propagation is controlled by scheduled jobs. Take a look at the procedure DBMS_DEFER_SYS.SCHEDULE_PUSH, which the book says Schedules an automatic push of the deftran queue to the specified master database. Hope this helps, it may irritate someone that really knows the answer to your question into replying. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, September 04, 2002 8:04 PM To: Multiple recipients of list ORACLE-L When DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT is executed to build the necessary underpinnings for multimaster replication of an object, it creates a package called object_name$RP. This package contains code to be run when rows are inserted, updated, or deleted. There are, however, no trigges in the owning schema, nor in that of the replication administrator. What, then, is the mechanism by which the procedures in this package are called? TIA! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Replication question
Paul, The procedures are executed by a special internal trigger. These triggers are also NOT dropped by catrepr.sql (yes, I found out the hard way!). It is documented in metalink. HtH, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Wednesday, September 04, 2002 9:04 PM To: Multiple recipients of list ORACLE-L When DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT is executed to build the necessary underpinnings for multimaster replication of an object, it creates a package called object_name$RP. This package contains code to be run when rows are inserted, updated, or deleted. There are, however, no trigges in the owning schema, nor in that of the replication administrator. What, then, is the mechanism by which the procedures in this package are called? TIA! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Replication question
Title: RE: Replication question Great book, I have it too! -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 10:28 AM To: Multiple recipients of list ORACLE-L Subject: RE: Replication question Paul - I don't know multimaster replication, so bear with me. I am thumbing through my copy of Oracle Distributed Systems by Charles Dye. Does your question relate to how propagation is controlled? I think propagation is controlled by scheduled jobs. Take a look at the procedure DBMS_DEFER_SYS.SCHEDULE_PUSH, which the book says Schedules an automatic push of the deftran queue to the specified master database. Hope this helps, it may irritate someone that really knows the answer to your question into replying. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, September 04, 2002 8:04 PM To: Multiple recipients of list ORACLE-L When DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT is executed to build the necessary underpinnings for multimaster replication of an object, it creates a package called object_name$RP. This package contains code to be run when rows are inserted, updated, or deleted. There are, however, no trigges in the owning schema, nor in that of the replication administrator. What, then, is the mechanism by which the procedures in this package are called? TIA! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Replication question
Thanks, John. Do you know what mechanism causes the internal triggers to fire? Are the internal triggers created by catrep.sql, or by DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT for each table? Does the RDBMS have to determine whether --- John Weatherman [EMAIL PROTECTED] wrote: Paul, The procedures are executed by a special internal trigger. These triggers are also NOT dropped by catrepr.sql (yes, I found out the hard way!). It is documented in metalink. HtH, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Wednesday, September 04, 2002 9:04 PM To: Multiple recipients of list ORACLE-L When DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT is executed to build the necessary underpinnings for multimaster replication of an object, it creates a package called object_name$RP. This package contains code to be run when rows are inserted, updated, or deleted. There are, however, no trigges in the owning schema, nor in that of the replication administrator. What, then, is the mechanism by which the procedures in this package are called? TIA! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Replication question
The jobs are used to propogate the captured transactions. The transactions are captured by the packages called by the internal triggers. PAX, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, September 05, 2002 10:28 AM To: Multiple recipients of list ORACLE-L Paul - I don't know multimaster replication, so bear with me. I am thumbing through my copy of Oracle Distributed Systems by Charles Dye. Does your question relate to how propagation is controlled? I think propagation is controlled by scheduled jobs. Take a look at the procedure DBMS_DEFER_SYS.SCHEDULE_PUSH, which the book says Schedules an automatic push of the deftran queue to the specified master database. Hope this helps, it may irritate someone that really knows the answer to your question into replying. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, September 04, 2002 8:04 PM To: Multiple recipients of list ORACLE-L When DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT is executed to build the necessary underpinnings for multimaster replication of an object, it creates a package called object_name$RP. This package contains code to be run when rows are inserted, updated, or deleted. There are, however, no trigges in the owning schema, nor in that of the replication administrator. What, then, is the mechanism by which the procedures in this package are called? TIA! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Replication question
I once noticed this code which is executed (for each column?) when you create a table. Would it be related to replication? BEGIN 2. /* NOP UNLESS A TABLE OBJECT */ 3. IF dictionary_obj_type = 'TABLE' THEN 4. sys.dbms_cdc_publish.change_table_trigger(dictionary_obj_owner,dictionary_obj_name,'LOCK'); 5. END IF; 6. END; Paul Baumgartel [EMAIL PROTECTED]@fatcity.com on 09/05/2002 11:38:25 AM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Thanks, John. Do you know what mechanism causes the internal triggers to fire? Are the internal triggers created by catrep.sql, or by DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT for each table? Does the RDBMS have to determine whether --- John Weatherman [EMAIL PROTECTED] wrote: Paul, The procedures are executed by a special internal trigger. These triggers are also NOT dropped by catrepr.sql (yes, I found out the hard way!). It is documented in metalink. HtH, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Wednesday, September 04, 2002 9:04 PM To: Multiple recipients of list ORACLE-L When DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT is executed to build the necessary underpinnings for multimaster replication of an object, it creates a package called object_name$RP. This package contains code to be run when rows are inserted, updated, or deleted. There are, however, no trigges in the owning schema, nor in that of the replication administrator. What, then, is the mechanism by which the procedures in this package are called? TIA! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Replication question
Paul, Dispite being internal the triggers are triggers just like any others. INSERT, UPDATE, DELETE all fire the package (all the transactions you want to move). I have NEVER been clear on the relationship between these triggers and user defined ones, sence you suposedly can't control the order multiple PRE-INSERT triggers, for instance, fire. The internals are created by DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT, which is why the catrepr.sql doesn't know about them. HtH, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, September 05, 2002 11:38 AM To: Multiple recipients of list ORACLE-L Thanks, John. Do you know what mechanism causes the internal triggers to fire? Are the internal triggers created by catrep.sql, or by DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT for each table? Does the RDBMS have to determine whether --- John Weatherman [EMAIL PROTECTED] wrote: Paul, The procedures are executed by a special internal trigger. These triggers are also NOT dropped by catrepr.sql (yes, I found out the hard way!). It is documented in metalink. HtH, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Wednesday, September 04, 2002 9:04 PM To: Multiple recipients of list ORACLE-L When DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT is executed to build the necessary underpinnings for multimaster replication of an object, it creates a package called object_name$RP. This package contains code to be run when rows are inserted, updated, or deleted. There are, however, no trigges in the owning schema, nor in that of the replication administrator. What, then, is the mechanism by which the procedures in this package are called? TIA! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: General Replication question
Hello Ed We are using replication for one application, Dealing room. This is synchronous replication between 2 computers sitting in the same room connected by dedicated cable. The target is to have up to date second database in case of machine failure. I got lost quickly in the manual and finally did the right thing. Called Oracle support and paid for in site consulting. The guy came over and after 6-7 hours had a script that generate replication for a schema. I put it in production about 1 year ago and no problems since. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 26, 2002 6:58 PM I'm curious, based on a discussion I had with a DBA here at work, how many people use the replication features of Oracle. I often see replication listed as one of the selling points of Oracle, but it's also very hard to get a class on replication because they are always closing classes for poor registration. How common is replication (basic or advanced)? It makes more sense to use simple snapshots than DB links for what we are doing, but given that our support from Oracle has been TERRIBLE with snapshot problems, I now wonder if anyone uses them. We are switching to db links, but that can pose potential performance issues with, for example, joins across the db link. Best, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed 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).
Replication question
When DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT is executed to build the necessary underpinnings for multimaster replication of an object, it creates a package called object_name$RP. This package contains code to be run when rows are inserted, updated, or deleted. There are, however, no trigges in the owning schema, nor in that of the replication administrator. What, then, is the mechanism by which the procedures in this package are called? TIA! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: General Replication question
Well, the flood of responses (not) to this topic probably answers one of the points raised! While endorsing all that Dennis has stated, I would just like to add something. Most crucially, replication is an exercise in logic, which fundamentally depends on getting your database design correct on both (or all) instances. If one site has an indadequately defined model, then sure as fate, replication will uncover the weakness sooner or later in the form of corrupt data or a failed replication transaction. Which provides a useful side benefit, by the way. We have been running replication for 15 years. In-house system. Slowly and incrementally improved over the years. Why replicate? Because we had such a poor wan, that transactions across it were highly problematic. Easier to have a couple of instances, and replicate between them each night. Now we have three big sites, and murmurs between them in the dead of night ensure everything is maintained synchronous... The point about checking that replication has worked in very important. I spent a lot of time building up an ever-increasingly complex array of exception reports. No emails in the morning - all's well. Hey, but replication is great for carrying out major data migrations! peter edinburgh -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: 26 August 2002 19:19 To: Multiple recipients of list ORACLE-L Subject: RE: General Replication question Ed - We have flirted with the replication thing here for some time. I have had the same questions as you, trying to take classes, for example. I don't think replication is widely used, but there are plenty of sites out there. snip * 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: General Replication question
We are using advanced replication for three instances. It's labor intensive, fraught with error, and requires continual babysitting. For us, it is doing what we want. Near real time copies of the primary instance, and instant failover capability (well, instant as soon as the tnsnames.ora is changed - but that's another story). --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Ed - We have flirted with the replication thing here for some time. I have had the same questions as you, trying to take classes, for example. I don't think replication is widely used, but there are plenty of sites out there. The conclusion I've come to is that the secret to a successful replication project is not in the technology. It is in the preparation. Success requires a military-like discipline of getting full cooperation from all involved people. And there will be many more people throughout your organization to be involved than you think. Replication is a practice rather than a slap-on Oracle or third-party feature. Regardless of the technology you select, you'll still need to resolve the same issues in order to succeed. Dull stuff like how you will test replication (very difficult), how you will fix the data when the replication inevitably breaks, how you will implement changes (massive issue, as Dick points out). Replication can move corrupt data just as quickly as good data. Whether you are using the most expensive third-party add-on tool (aren't vendors great at acting like their product will solve all your problems?) or tossing magnetic tapes in a semi to be driven to the site, the big issues don't change. A friend was just reliving problems they encountered 15 years ago with a home-grown COBOL system. As he discussed their problems, he was shocked that the underlying problems haven't really changed much. Maybe more convenient and faster, but you still have a lot of human involvement, regardless. Replication is easy so set up. Keeping it running reliably day after day is the trick. For example a friend of mine who had quit his previous employer to get away from their replicated environment (this was a Sybase log-based project). Recently someone at one of their remote sites decided to reboot a server. It took several days and nights for them to get the entire system corrected. First of all your organization must decide whether replication is worth all the time and trouble it will inflict. Most replication projects are caused by political rather than technical reasons. Like two divisions that both need to be equally important. I feel most replication projects are eventually abandoned. If the organization was smart and started with a small project, usually their enthusiasm was simply dulled. If they weren't and started with a really big project, the disaster can be spectacular. Usually the organization starts with a small project, learns how much trouble replication is, and never implements phase II. The successful replication projects probably aren't so visible on because the people who tend them day in and day out aren't the shooting stars that go for the latest technology. Those people may have sold management on starting the replication project, but they would have probably gotten bored with the mundane detail and follow-up and moved on to a more exciting project. Another factor is the application. The best application is one you are just now developing in-house where you can build replication considerations in from the initial design. The worst is a mature third-party product that you don't clearly understand at the data level and have no hope of modifying to accommodate replication. The only two books I've found on replication are: Data Replication, Marie Buretta, 1997. Lists all the issues that must be considered for a replication project to succeed. Oracle Distributed Systems, Charles Dye, 1999. As you can tell from the publication dates, this isn't exactly a hot technology. I don't mean to be too negative. I just feel it is important for an organization to understand what they are getting in for before they start. If the benefits outweigh the costs, then proceed. But don't think a couple of DBAs can turn replication on and succeed. Eventually management wakes up and says wow, we've gone through about a dozen DBAs in the last year, do you think they are overwhelmed by that replication thing?. Again, these are my observations from studying replication from the outside. Perhaps it will provoke some responses from replication experts. -Original Message- Sent: Monday, August 26, 2002 11:58 AM To: Multiple recipients of list ORACLE-L I'm curious, based on a discussion I had with a DBA here at work, how many people use the replication features of Oracle. I often see replication listed as one of the selling points of Oracle, but it's also
General Replication question
I'm curious, based on a discussion I had with a DBA here at work, how many people use the replication features of Oracle. I often see replication listed as one of the selling points of Oracle, but it's also very hard to get a class on replication because they are always closing classes for poor registration. How common is replication (basic or advanced)? It makes more sense to use simple snapshots than DB links for what we are doing, but given that our support from Oracle has been TERRIBLE with snapshot problems, I now wonder if anyone uses them. We are switching to db links, but that can pose potential performance issues with, for example, joins across the db link. Best, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed 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:General Replication question
Ed, I've shied away from replication beyond snapshots due to the requirement to not modify objects that are registered with the replication manager. Seems that as soon as I tell the duhveloper that he/she can not modify the structure, but will have to come talk to me. At this point they don't want to continue down that path. So no, we don't use replication but it's more of a duhveloper thing. As far as snapshots go, I've heard a lot of people claim to have continuos problems with them. Wish I could say that it's true, but I can't. We make extensive use of snapshots to keep cross database communications down as much as possible don't have a single problem with them. Dick Goulet Reply Separator Author: Ed [EMAIL PROTECTED] Date: 8/26/2002 8:58 AM I'm curious, based on a discussion I had with a DBA here at work, how many people use the replication features of Oracle. I often see replication listed as one of the selling points of Oracle, but it's also very hard to get a class on replication because they are always closing classes for poor registration. How common is replication (basic or advanced)? It makes more sense to use simple snapshots than DB links for what we are doing, but given that our support from Oracle has been TERRIBLE with snapshot problems, I now wonder if anyone uses them. We are switching to db links, but that can pose potential performance issues with, for example, joins across the db link. Best, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed 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: General Replication question
Ed - We have flirted with the replication thing here for some time. I have had the same questions as you, trying to take classes, for example. I don't think replication is widely used, but there are plenty of sites out there. The conclusion I've come to is that the secret to a successful replication project is not in the technology. It is in the preparation. Success requires a military-like discipline of getting full cooperation from all involved people. And there will be many more people throughout your organization to be involved than you think. Replication is a practice rather than a slap-on Oracle or third-party feature. Regardless of the technology you select, you'll still need to resolve the same issues in order to succeed. Dull stuff like how you will test replication (very difficult), how you will fix the data when the replication inevitably breaks, how you will implement changes (massive issue, as Dick points out). Replication can move corrupt data just as quickly as good data. Whether you are using the most expensive third-party add-on tool (aren't vendors great at acting like their product will solve all your problems?) or tossing magnetic tapes in a semi to be driven to the site, the big issues don't change. A friend was just reliving problems they encountered 15 years ago with a home-grown COBOL system. As he discussed their problems, he was shocked that the underlying problems haven't really changed much. Maybe more convenient and faster, but you still have a lot of human involvement, regardless. Replication is easy so set up. Keeping it running reliably day after day is the trick. For example a friend of mine who had quit his previous employer to get away from their replicated environment (this was a Sybase log-based project). Recently someone at one of their remote sites decided to reboot a server. It took several days and nights for them to get the entire system corrected. First of all your organization must decide whether replication is worth all the time and trouble it will inflict. Most replication projects are caused by political rather than technical reasons. Like two divisions that both need to be equally important. I feel most replication projects are eventually abandoned. If the organization was smart and started with a small project, usually their enthusiasm was simply dulled. If they weren't and started with a really big project, the disaster can be spectacular. Usually the organization starts with a small project, learns how much trouble replication is, and never implements phase II. The successful replication projects probably aren't so visible on because the people who tend them day in and day out aren't the shooting stars that go for the latest technology. Those people may have sold management on starting the replication project, but they would have probably gotten bored with the mundane detail and follow-up and moved on to a more exciting project. Another factor is the application. The best application is one you are just now developing in-house where you can build replication considerations in from the initial design. The worst is a mature third-party product that you don't clearly understand at the data level and have no hope of modifying to accommodate replication. The only two books I've found on replication are: Data Replication, Marie Buretta, 1997. Lists all the issues that must be considered for a replication project to succeed. Oracle Distributed Systems, Charles Dye, 1999. As you can tell from the publication dates, this isn't exactly a hot technology. I don't mean to be too negative. I just feel it is important for an organization to understand what they are getting in for before they start. If the benefits outweigh the costs, then proceed. But don't think a couple of DBAs can turn replication on and succeed. Eventually management wakes up and says wow, we've gone through about a dozen DBAs in the last year, do you think they are overwhelmed by that replication thing?. Again, these are my observations from studying replication from the outside. Perhaps it will provoke some responses from replication experts. -Original Message- Sent: Monday, August 26, 2002 11:58 AM To: Multiple recipients of list ORACLE-L I'm curious, based on a discussion I had with a DBA here at work, how many people use the replication features of Oracle. I often see replication listed as one of the selling points of Oracle, but it's also very hard to get a class on replication because they are always closing classes for poor registration. How common is replication (basic or advanced)? It makes more sense to use simple snapshots than DB links for what we are doing, but given that our support from Oracle has been TERRIBLE with snapshot problems, I now wonder if anyone uses them. We are switching to db links, but that can pose potential performance issues with, for example, joins across the db link. Best, Ed -- Please see the
Re:General Replication question
I'll have to echo that sentiment. Snapshots never give me any trouble. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/26/2002 10:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re:General Replication question Ed, I've shied away from replication beyond snapshots due to the requirement to not modify objects that are registered with the replication manager. Seems that as soon as I tell the duhveloper that he/she can not modify the structure, but will have to come talk to me. At this point they don't want to continue down that path. So no, we don't use replication but it's more of a duhveloper thing. As far as snapshots go, I've heard a lot of people claim to have continuos problems with them. Wish I could say that it's true, but I can't. We make extensive use of snapshots to keep cross database communications down as much as possible don't have a single problem with them. Dick Goulet Reply Separator Author: Ed [EMAIL PROTECTED] Date: 8/26/2002 8:58 AM I'm curious, based on a discussion I had with a DBA here at work, how many people use the replication features of Oracle. I often see replication listed as one of the selling points of Oracle, but it's also very hard to get a class on replication because they are always closing classes for poor registration. How common is replication (basic or advanced)? It makes more sense to use simple snapshots than DB links for what we are doing, but given that our support from Oracle has been TERRIBLE with snapshot problems, I now wonder if anyone uses them. We are switching to db links, but that can pose potential performance issues with, for example, joins across the db link. Best, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Replication Question
So how do I get into the archives? I've got a question I know I've seen answered. Thanks, John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Replication Question
John - I've noticed that Google queries pull up info from the archives. Obviously you'll get other stuff, but if you can make your query pretty specific it may get you what you need. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 30, 2002 12:09 PM To: Multiple recipients of list ORACLE-L So how do I get into the archives? I've got a question I know I've seen answered. Thanks, John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Replication question
On performance of triggers blocking update of primary keys. There are two aspects to performance. First, that which impacts on cpu cycles etc, and secondly, that which impacts on the integrity of the fundamental database design. I regard the latter as crucial - and non-negotiable. The former is a function of secondary issues such as machine power, load, use profile etc etc. You can see what I am going to say - if Oracle won't protect your PKs from modification, then you must do it yourself, and take any load into account when specifying your hardware platform. I do know of relational databases which will absolutely preclude modification of PKs. It ought to be a given with an RDBMS. As for our situation - no, these triggers don't impact us noticeably, but then we don't run a high tp environment. But I tell you what - they give me enormouse peace of mind! peter edinburgh -Original Message- From: Lowes, Harry (NESL-IT) [mailto:[EMAIL PROTECTED]] Sent: 21 June 2002 13:37 To: Multiple recipients of list ORACLE-L Subject: RE: Replication question Peter, Great idea, but would you care to share the impact of these triggers on performance? I think it's a good principle to follow, but have always found triggers a little unwieldy for most operations myself. I would have thought this to be the case here, but I'd like to hear your experiences on the subject. Thanks awfully, Harry Lowes My enthusiasm for both the job in hand and the welfare of my fellow man knows no bounds. Database Administrator and bon vivante, npower Northern Limited -Original Message- Sent: 21 June 2002 11:49 To: Multiple recipients of list ORACLE-L Interesting comments on replication - but something hit me between the eyes. Primary Keys should NEVER, EVER be permitted to be updated, whether you are using replication or not. Its a basic tenent of relational design. We have been using triggers to prevent this for years. peter edinburgh * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lowes, Harry (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: REPLICATION QUESTION - LOng and strange
Sakthi , Raj wrote: Hi Listers, alright I've exhausted almost all my resources and I am turning to my last resource. We have 3 databases. Database A - OLTP Database B - OLTP Database c - DSS ORACLE 8.1.6.3 ON HP-UX 11.0 Database A has a table which is being replicated to C as a read only snapshot and we have long and complex summary process (relic of 1998?s) that works off this snapshot. Now due to some new merger same table need to be created in database B. And yes?the data in table B also need to be replicated to the SAME snapshot in database C so that the summary process can summarize the collective data. The problem is I am sure this could be accomplished. THAT IS TWO MASTERS SITES FEEDING SAME SNAPSHOT?.!!! I have checked the replication manual and Unless I am so sleep deprived that I am missing lines I didn?t find any reference to this kinda replication setup. Any pointers welcome. I am exhausted, so if you don?t mind, if RTFMs could refer the relevant section I am supposed to RTFM, then it would be great. Rewriting the summary process is not an option due to unrealistic deadline. TIA. RS Wouldn't it be possible to replace your current snapshot by a view, the union of one snapshot on A and one snapshot on B? C could the summarize both. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Replication question
Interesting comments on replication - but something hit me between the eyes. Primary Keys should NEVER, EVER be permitted to be updated, whether you are using replication or not. Its a basic tenent of relational design. We have been using triggers to prevent this for years. peter edinburgh * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Replication question
Peter, Great idea, but would you care to share the impact of these triggers on performance? I think it's a good principle to follow, but have always found triggers a little unwieldy for most operations myself. I would have thought this to be the case here, but I'd like to hear your experiences on the subject. Thanks awfully, Harry Lowes My enthusiasm for both the job in hand and the welfare of my fellow man knows no bounds. Database Administrator and bon vivante, npower Northern Limited -Original Message- Sent: 21 June 2002 11:49 To: Multiple recipients of list ORACLE-L Interesting comments on replication - but something hit me between the eyes. Primary Keys should NEVER, EVER be permitted to be updated, whether you are using replication or not. Its a basic tenent of relational design. We have been using triggers to prevent this for years. peter edinburgh * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lowes, Harry (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Replication question
Andy, Consider yourself solicited! I am currently using Datamirror for our tandem db2 to unix oracle replication. The product was not chosen for our oracle to oracle replication for 2 reasons. #1 trigger based. #2 if the source transaction failed to be commited at the target, then the source transaction was actually rolled back. Has this strategy changed? Also, when I did my original research into rpelication products Datamirror products were not using log based replication. You guys having some exciting changes for me over there in beautiful Toronto? Thanks, Hannah ps. you work with Elmer Cecelio? -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Andrew Sit [EMAIL PROTECTED] Sent: Thursday, June 20, 2002 11:19 AM To: Multiple recipients of list ORACLE-L Subject: RE: Replication question Dennis et al: Sorry for the shameless plug, but my company has a number of products that perform oracle-oracle replication as well as DB2/MVS/SQL/ODBC/etc.-Oracle and Oracle-DB2/MVS/SQL/ODBC/etc. replication. Yes, I am an engineer for iReflect which does similar things to shareplex (log-based replication), but also have distinct differences. We are not bound by the issues that oracle replication and shareplex have (i.e. only replicating keyed tables, and DML only), we replicate both non-keyed tables and DDL operations as well. http://www.datamirror.com/products/default.asp Sorry again, will only reply to solicitations from now on... Andy. -- Andrew Sit Systems Engineer DataMirror Corporation (905) 415-0310 x266 (O) (416) 839-9908 (M) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Replication question
Brian, That is what I wanted to do, but I understood that it would not be *supported* if we ran into issues. Thanks, Hannah -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Brian McGraw [EMAIL PROTECTED] Sent: Thursday, June 20, 2002 11:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Replication question Just a note, Johanna. We put all of our Oracle Replication metadata into separate tablespaces, and had absolutely no problems. Brian -- | Brian McGraw /* DBA */ Infinity Insurance | | mailto:[EMAIL PROTECTED] | -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Replication question
Conflict resolution also has to be considered for log based replication as well. Same problems exist. If you think about it Oracles AQ approach is pretty much a log. Multi-master replication is still trigger/AQ based in 9i. It's working well for us. Some of the things you can do to reduce (but not elleminate) conflict resolution issues are: 1). Stagger sequence generated primary keys by site 2). Put triggers in place to prevent updating of primary keys (avoids some uniqueness conflicts) 3). Add a last_updated_dt to each table and use that as your primary method of update conflict resolution 4). Add a primary site capability for tie breakers. Oracle has a built in method, but it requires you add a site column to each table. If it is not data dependent, I prefer a custom stored procedure method where you choose a primary site that is not data dependent. Deletes are still our biggest problem. Don't really understand why they can't be applied in the same order at the remote site (perhaps because we am using parallel propagation?). But for some reason if we do massive deletes across multiple related tables in the same TX, we always end up having to manually reconcile. An approach recommended by oracle for this is to add a deleted_dt column to every table and do deferred batch deletions. We tried this in conjunction with views and instead of triggers to hide it from the application. A couple of problems with this approach is that if you delete, then try to re-insert with the same alternate key before the deferred purge process runs, you will get ORA-1 errors. If you run the deferred deletion process too often you defeat the purpose of it and overload the system. --- [EMAIL PROTECTED] wrote: Dennis, All dbs whether SQL Server or Oracle need to deal with conflict resolution, thats not strictly an Oracle limitation. As far a Quest goes, they handle replication completely different from Oracle. Oracle itself is still using triggers (in 8i at least) , ubt now they hide the trigger, Shareplex reads the Oracle redo logs. I believe that 9i uses the redo logs and is based (structured) after Shareplex itself - there were lots of articles on this with the pre-release of Dataguard. Furthermore, Oracle places all of its replication metadata in SYSTEM tablespace which I dont like, Sharpelex uses its own (which the user configures). As far as Shareplex manuals, Quest is the one company that I will stand up and say that regardless of anything else, their documention is EXCELLENT. Their documentation takes you from Shareplex architecture right to directory structure, actual files, usage and even scripting. The sales rep was incorrect. However, I can see them not releasing the manuals without a purchase. I believe that they are available on-line for download, though I do not know if it is just for current customers only. (hehe can't believe I am defending a vendor:). But when someone does something right, I like to give credit. Also, once you are setup, they are VERY stable. I have my issues with them, but overall I feel they do great job at what they do. Hannah - Hope it helps any. -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of DENNIS WILLIAMS [EMAIL PROTECTED] Sent: Thursday, June 20, 2002 10:33 AM To: Multiple recipients of list ORACLE-L Subject:RE: Replication question Yechel - Wow, what a blow to be struck with the dreaded RTFM first thing in the morning. Thanks Yechiel, I needed that. Actually, I was hoping there was another resource besides the manual, for two reasons: 1. This development group is a little irritated that they are forced to use Oracle instead of MS SQL, so they are taking replication issues as being Oracle limitations. 2. They have been talking to the Quest salespeople, who naturally heap disdain on Oracle's standard replication (selected Oracle SE because the price was closer to MS SQL). I asked the Quest rep if they had a document similar to the Oracle manual. Gosh, he couldn't think of one. Since nobody on the list has mentioned one, maybe they don't have one. The best resource I've found so far is a former Sybase DBA who was able to confirm that log-based replication has most of the same issues as Oracle standard replication has. Thanks everyone for your replies. Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY
RE: Replication question
Hmmm. Maybe that's changed, but we were actually advised to move the objects when we set them up in v8. -- | Brian McGraw /* DBA */ Infinity Insurance | | mailto:[EMAIL PROTECTED] | -- -Original Message- [EMAIL PROTECTED] Sent: Thursday, June 20, 2002 11:49 AM To: Multiple recipients of list ORACLE-L Brian, That is what I wanted to do, but I understood that it would not be *supported* if we ran into issues. Thanks, Hannah -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Brian McGraw [EMAIL PROTECTED] Sent: Thursday, June 20, 2002 11:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Replication question Just a note, Johanna. We put all of our Oracle Replication metadata into separate tablespaces, and had absolutely no problems. Brian -- | Brian McGraw /* DBA */ Infinity Insurance | | mailto:[EMAIL PROTECTED] | -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Replication question
Hadn't heard that one. Objects for replication metadata are created in whatever the default tablespace is for SYSTEM. The database create script crdb2.sql changes SYSTEM's default tablespace to TOOLS, so subsequently that's where the objects are created when catrep.sql is run. In my case, that is TOOLS and haven't run into any problems. [EMAIL PROTECTED] wrote: Brian, That is what I wanted to do, but I understood that it would not be *supported* if we ran into issues. Thanks, Hannah -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Brian McGraw [EMAIL PROTECTED] Sent: Thursday, June 20, 2002 11:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Replication question Just a note, Johanna. We put all of our Oracle Replication metadata into separate tablespaces, and had absolutely no problems. Brian -- | Brian McGraw /* DBA */ Infinity Insurance | | mailto:[EMAIL PROTECTED] | -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Replication question
There is also a note (1037317.6) that documents moving the replication base tables to another tablespace (which Oracle Recommends). Funny how alot of the Oracle Recommendations are in notes instead of the documentation. --- Suzy Vordos [EMAIL PROTECTED] wrote: Hadn't heard that one. Objects for replication metadata are created in whatever the default tablespace is for SYSTEM. The database create script crdb2.sql changes SYSTEM's default tablespace to TOOLS, so subsequently that's where the objects are created when catrep.sql is run. In my case, that is TOOLS and haven't run into any problems. [EMAIL PROTECTED] wrote: Brian, That is what I wanted to do, but I understood that it would not be *supported* if we ran into issues. Thanks, Hannah -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Brian McGraw [EMAIL PROTECTED] Sent: Thursday, June 20, 2002 11:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Replication question Just a note, Johanna. We put all of our Oracle Replication metadata into separate tablespaces, and had absolutely no problems. Brian -- | Brian McGraw /* DBA */ Infinity Insurance | | mailto:[EMAIL PROTECTED] | -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Pass INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Replication question
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).
Re: Replication question
Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 14, 2002 10:58 AM We are just starting to look at replication so each manufacturing plant can have their own server. The applications are being developed in-house. I feel the first issue is to analyze each table and decide how it will be replicated and what schema changes need to me made to accommodate replication. Instead, one of the developers wants to talk to Quest about their solution. It seems to me that you need to make the same evaluation and schema changes where needed. If anyone can point me to a white paper on schema changes to consider, that would be appreciated. Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Replication question
Mitchell, There are a LOT of good papers in Metalink. I've been getting my own education over the last few months. Replication is a really great swiss army knife though, you need to do a little looking for what you specifically need to do, then test, test, test. Oh, and did I mention test? :) I found Note: 138181.1 particularly helpful. Oh, and plan on some TARs. I have found Support very helpful/informative in this area. Good Luck, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Replication question
Mitchell - My knowledge is mostly from reading at this point, but here are some thoughts that a colleague provided from his experience: - backup and recovery is much more complicated in a replicated environment so it needs to be planned - replicated databases inevitably get out of sync so some process outside the usual replication method must be built to re-sync the databases. this can either be done proactively or reactively - proactive is more fun. - a process to monitor the overall health of the replicated environment is a good idea. i.e. how latent are the transactions, are the replicated transactions actually being replicated, have there been any data conflicts. - schema changes get real fun. planning ahead again a good idea. - additional testing is needed to prove the replication will work especially on the performance front. I have found only two books on replication (is that a hint that most sites avoid it??) Oracle Distributed Systems by Charles Dye, O'Reilly 1999 Data Replication by Marie Buretta, Wiley 1997 -Original Message- Sent: Friday, June 14, 2002 11:05 AM To: Multiple recipients of list ORACLE-L Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 14, 2002 10:58 AM We are just starting to look at replication so each manufacturing plant can have their own server. The applications are being developed in-house. I feel the first issue is to analyze each table and decide how it will be replicated and what schema changes need to me made to accommodate replication. Instead, one of the developers wants to talk to Quest about their solution. It seems to me that you need to make the same evaluation and schema changes where needed. If anyone can point me to a white paper on schema changes to consider, that would be appreciated. Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Replication question
Curious, that note suggests Advanced Replication as a failover methodology. Seems that a standby database would be _much_ simpler. Any thoughts ( from anyone ) on why one would use AR for failover, rather than using a standby database? Jared John Weatherman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/14/2002 09:50 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Replication question Mitchell, There are a LOT of good papers in Metalink. I've been getting my own education over the last few months. Replication is a really great swiss army knife though, you need to do a little looking for what you specifically need to do, then test, test, test. Oh, and did I mention test? :) I found Note: 138181.1 particularly helpful. Oh, and plan on some TARs. I have found Support very helpful/informative in this area. Good Luck, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Replication question
Jarad, A standby is simpler, however it has limited use for offloading some system load (opening for read access suspends roll forward, so the data is somewhat stale). By using Master-Master synchronous replication with good deadlock handlers, you can use BOTH instances so you get the benefit of not having an unused instance lying around (damagement hates that), but still have fail over available. Since you can have different users/locations attach to different instances, you also get some scalability advantages. In general, I agree a standby is MUCH simpler. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 1:41 PM To: Multiple recipients of list ORACLE-L Curious, that note suggests Advanced Replication as a failover methodology. Seems that a standby database would be _much_ simpler. Any thoughts ( from anyone ) on why one would use AR for failover, rather than using a standby database? Jared John Weatherman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/14/2002 09:50 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Replication question Mitchell, There are a LOT of good papers in Metalink. I've been getting my own education over the last few months. Replication is a really great swiss army knife though, you need to do a little looking for what you specifically need to do, then test, test, test. Oh, and did I mention test? :) I found Note: 138181.1 particularly helpful. Oh, and plan on some TARs. I have found Support very helpful/informative in this area. Good Luck, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Replication question
or you can use the logical standby feature of 9.2 and then have both databases open. Replication bothers me when I start to think about synchronous vs asynchronous. Async doesn't hold up the primary site from continuing on, but the databases are not true copies of one another. Sync are true copies but you can hold up the commit waiting for a return from the remote site. And if it fails, it's messy to clean up --- John Weatherman [EMAIL PROTECTED] wrote: Jarad, A standby is simpler, however it has limited use for offloading some system load (opening for read access suspends roll forward, so the data is somewhat stale). By using Master-Master synchronous replication with good deadlock handlers, you can use BOTH instances so you get the benefit of not having an unused instance lying around (damagement hates that), but still have fail over available. Since you can have different users/locations attach to different instances, you also get some scalability advantages. In general, I agree a standby is MUCH simpler. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 1:41 PM To: Multiple recipients of list ORACLE-L Curious, that note suggests Advanced Replication as a failover methodology. Seems that a standby database would be _much_ simpler. Any thoughts ( from anyone ) on why one would use AR for failover, rather than using a standby database? Jared John Weatherman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/14/2002 09:50 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Replication question Mitchell, There are a LOT of good papers in Metalink. I've been getting my own education over the last few months. Replication is a really great swiss army knife though, you need to do a little looking for what you specifically need to do, then test, test, test. Oh, and did I mention test? :) I found Note: 138181.1 particularly helpful. Oh, and plan on some TARs. I have found Support very helpful/informative in this area. Good Luck, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Replication question
Title: RE: Replication question Another potential HA use of AR is that you can use different platforms in an HA configuration. You can fail over to another platform with some idle capacity or a workload that can be shifted around until the failed services are restored. Yet another is during planned downtime when upgrading Oracle and OS versions. You could upgrade the target while the source is the actively used node. Then move the users off the source and let the remaining changes post to the target. Now reverse the replication source/target roles and upgrade the old source (now they new target) an let it be until the next time. The outage should be shorter. The same technique could be used to roll back to a usable database after an major application change. Just change the target and let the users try things out. If there's a problem point them back to the source and regroup. It should be much quicker that undoing the changes. Just some thoughts. Tony Aponte -Original Message- From: John Weatherman [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: Replication question Jarad, A standby is simpler, however it has limited use for offloading some system load (opening for read access suspends roll forward, so the data is somewhat stale). By using Master-Master synchronous replication with good deadlock handlers, you can use BOTH instances so you get the benefit of not having an unused instance lying around (damagement hates that), but still have fail over available. Since you can have different users/locations attach to different instances, you also get some scalability advantages. In general, I agree a standby is MUCH simpler. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 1:41 PM To: Multiple recipients of list ORACLE-L Curious, that note suggests Advanced Replication as a failover methodology. Seems that a standby database would be _much_ simpler. Any thoughts ( from anyone ) on why one would use AR for failover, rather than using a standby database? Jared John Weatherman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/14/2002 09:50 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: Replication question Mitchell, There are a LOT of good papers in Metalink. I've been getting my own education over the last few months. Replication is a really great swiss army knife though, you need to do a little looking for what you specifically need to do, then test, test, test. Oh, and did I mention test? :) I found Note: 138181.1 particularly helpful. Oh, and plan on some TARs. I have found Support very helpful/informative in this area. Good Luck, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing
RE: Replication question
All very true. Of course the doc in question was written for 8i, so that explains some of it. :) Question: Does logical standby in 9.2 work across platforms? Haven't had too much time to look at new 9.2 features I'm afraid. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 2:57 PM To: Multiple recipients of list ORACLE-L or you can use the logical standby feature of 9.2 and then have both databases open. Replication bothers me when I start to think about synchronous vs asynchronous. Async doesn't hold up the primary site from continuing on, but the databases are not true copies of one another. Sync are true copies but you can hold up the commit waiting for a return from the remote site. And if it fails, it's messy to clean up --- John Weatherman [EMAIL PROTECTED] wrote: Jarad, A standby is simpler, however it has limited use for offloading some system load (opening for read access suspends roll forward, so the data is somewhat stale). By using Master-Master synchronous replication with good deadlock handlers, you can use BOTH instances so you get the benefit of not having an unused instance lying around (damagement hates that), but still have fail over available. Since you can have different users/locations attach to different instances, you also get some scalability advantages. In general, I agree a standby is MUCH simpler. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 1:41 PM To: Multiple recipients of list ORACLE-L Curious, that note suggests Advanced Replication as a failover methodology. Seems that a standby database would be _much_ simpler. Any thoughts ( from anyone ) on why one would use AR for failover, rather than using a standby database? Jared John Weatherman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/14/2002 09:50 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Replication question Mitchell, There are a LOT of good papers in Metalink. I've been getting my own education over the last few months. Replication is a really great swiss army knife though, you need to do a little looking for what you specifically need to do, then test, test, test. Oh, and did I mention test? :) I found Note: 138181.1 particularly helpful. Oh, and plan on some TARs. I have found Support very helpful/informative in this area. Good Luck, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official
RE: Replication question
Thanks! John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 4:10 PM To: Multiple recipients of list ORACLE-L Cross-platform is the whole reason for logical standby -- it's SQL statements that get applied to the secondary database --- John Weatherman [EMAIL PROTECTED] wrote: All very true. Of course the doc in question was written for 8i, so that explains some of it. :) Question: Does logical standby in 9.2 work across platforms? Haven't had too much time to look at new 9.2 features I'm afraid. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 2:57 PM To: Multiple recipients of list ORACLE-L or you can use the logical standby feature of 9.2 and then have both databases open. Replication bothers me when I start to think about synchronous vs asynchronous. Async doesn't hold up the primary site from continuing on, but the databases are not true copies of one another. Sync are true copies but you can hold up the commit waiting for a return from the remote site. And if it fails, it's messy to clean up --- John Weatherman [EMAIL PROTECTED] wrote: Jarad, A standby is simpler, however it has limited use for offloading some system load (opening for read access suspends roll forward, so the data is somewhat stale). By using Master-Master synchronous replication with good deadlock handlers, you can use BOTH instances so you get the benefit of not having an unused instance lying around (damagement hates that), but still have fail over available. Since you can have different users/locations attach to different instances, you also get some scalability advantages. In general, I agree a standby is MUCH simpler. John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 1:41 PM To: Multiple recipients of list ORACLE-L Curious, that note suggests Advanced Replication as a failover methodology. Seems that a standby database would be _much_ simpler. Any thoughts ( from anyone ) on why one would use AR for failover, rather than using a standby database? Jared John Weatherman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/14/2002 09:50 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Replication question Mitchell, There are a LOT of good papers in Metalink. I've been getting my own education over the last few months. Replication is a really great swiss army knife though, you need to do a little looking for what you specifically need to do, then test, test, test. Oh, and did I mention test? :) I found Note: 138181.1 particularly helpful. Oh, and plan on some TARs. I have found Support very helpful/informative in this area. Good Luck, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, June 14, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi all I will work on replication soon. any advice for reference I can get. Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public
Replication question
Simple question, but I can't seem to find the answer in the oracle docs: Let's say I insert a record into an updatable snapshot, and then I update the same row. When I refresh the snapshot, will the same two DML operations be played back in order to the master, or will it only replicate a single insert of the updated row? My guess is that both operations are stored in the deferred transaction queue to be replicated to the master on refresh, but I'm having a hard time verifying (or disproving) that.. Thanks! -- Buddy Brewer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Buddy Brewer 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).
Replication Question
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).
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).
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 applicationreally needs the replication and there is no other simpler option... Just 2 cents... +Rahul - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Monday, March 04, 2002 3:33 AM Subject: replication question Dear Gurus, The clients will enter records to a database all day and I will update the other database . I need to replicate 10 tables in a database to other database at a specific time. Do I need Advanced replication or basic replication . ? How can I understand that replication is supported in my both databases. ? Bunyamin
Re: replication question
Thank you Rahul , Do you acceptvisa or bank check ? :) Bunyamin - Original Message - From: Rahul Dandekar To: Multiple recipients of list ORACLE-L Sent: Monday, March 04, 2002 2:43 PM Subject: Re: replication question Depends on your need. You can have read only snapshots, updatable snapshots or multimaster... Again if you think of multimaster... then you would need to make decision based on your application requirements about sync or async I donot have any expereince of snapshot replication. But, if you are planning multimaster replication, then better spend a couple of months studying it and testing on test boxes... Make 100% sure that your applicationreally needs the replication and there is no other simpler option... Just 2 cents... +Rahul - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Monday, March 04, 2002 3:33 AM Subject: replication question Dear Gurus, The clients will enter records to a database all day and I will update the other database . I need to replicate 10 tables in a database to other database at a specific time. Do I need Advanced replication or basic replication . ? How can I understand that replication is supported in my both databases. ? Bunyamin
RE: replication question
The way I see it . the question comes down to whether or not you need two way replication or just one way. If both databases can update those tables and you need them synced between the databases then Advanced Replication would be the route. If all you need are data changes from 1 database to be replicated to another database then simple replication is all you need. -Original Message-From: Rahul Dandekar [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 6:43 AMTo: Multiple recipients of list ORACLE-LSubject: Re: replication question Depends on your need. You can have read only snapshots, updatable snapshots or multimaster... Again if you think of multimaster... then you would need to make decision based on your application requirements about sync or async I donot have any expereince of snapshot replication. But, if you are planning multimaster replication, then better spend a couple of months studying it and testing on test boxes... Make 100% sure that your applicationreally needs the replication and there is no other simpler option... Just 2 cents... +Rahul - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Monday, March 04, 2002 3:33 AM Subject: replication question Dear Gurus, The clients will enter records to a database all day and I will update the other database . I need to replicate 10 tables in a database to other database at a specific time. Do I need Advanced replication or basic replication . ? How can I understand that replication is supported in my both databases. ? Bunyamin
RE: replication question
Is replication faster than a standby database.As I understand it, the standby database will be receive arch logs at preset intervals. Does replication have the same functionality and about how much data is sent to the replicated site. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent: Monday, March 04, 2002 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: replication question The way I see it . the question comes down to whether or not you need two way replication or just one way. If both databases can update those tables and you need them synced between the databases then Advanced Replication would be the route. If all you need are data changes from 1 database to be replicated to another database then simple replication is all you need. -Original Message-From: Rahul Dandekar [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 6:43 AMTo: Multiple recipients of list ORACLE-LSubject: Re: replication question Depends on your need. You can have read only snapshots, updatable snapshots or multimaster... Again if you think of multimaster... then you would need to make decision based on your application requirements about sync or async I donot have any expereince of snapshot replication. But, if you are planning multimaster replication, then better spend a couple of months studying it and testing on test boxes... Make 100% sure that your applicationreally needs the replication and there is no other simpler option... Just 2 cents... +Rahul - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Monday, March 04, 2002 3:33 AM Subject: replication question Dear Gurus, The clients will enter records to a database all day and I will update the other database . I need to replicate 10 tables in a database to other database at a specific time. Do I need Advanced replication or basic replication . ? How can I understand that replication is supported in my both databases. ? Bunyamin
RE: replication question
I have used both. Replication, like archive log movement , happens whenever you set it up to happen. That can be anywhere from every minute to once a day to beyond. It just depends on your needs. In the case of my old job, we had replication happeningat different times for different tables. Our key table was replicating IMMEDIATELY uponany changes to the parent table. This happened via trigger.Other , not so important tables, would replicate at anywhere from 30 to 60 minutes. We did this using scheduled jobs. I see two realnice advantages ofreplicated databases. One, they are accessible.i.e. you can run reports, queries, etc on them. They are nothing more than instancesthat get updated via a foreign database. Two,depending on what kind of software you use, you can update the database from an outside source. We used to have data sent down from our DB2 database into our Oracle database using an oracle product called Replication Services (nothing more than triggers and a specific data structure) and an IBM product called Data Propogator. Archive log transport for standbys can happen in multiple ways also. The newer oracle versions support direct archiving from a production database to a standby database. I have not tried this yet but we are looking into it. Our current standby databases are brought up to date with a shell script that is scheduled via cron every 20 minutes. The thing about the standbys, they areall or nothing ... you can not just say I want only tables 1-10 to be updated. They all are. Also, in the older oracle versions, the standbys could not be accessed via software so you could not use them as any sort of read only database. This is not the case in a replicated database. But, they are also very easy to rebuild and resetup. Just copy your production files over, create a standby control file, and bring the databse up in standby mode. Very easy. Now... which would I recommend ??? Depends on your needs. If you really need to access that copy of the database for other purposes and you only want certain tables to be updated, then I would consider replication. If, on the other hand, you do not have to access the data (until such a time as your production gets killed and you need your standby up) and you need a fast way to rebuild the second database, I would suggest the Standby approach. Kevin -Original Message-From: James Ambursley [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 12:24 PMTo: Multiple recipients of list ORACLE-LSubject: RE: replication question Is replication faster than a standby database.As I understand it, the standby database will be receive arch logs at preset intervals. Does replication have the same functionality and about how much data is sent to the replicated site. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent: Monday, March 04, 2002 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: replication question The way I see it . the question comes down to whether or not you need two way replication or just one way. If both databases can update those tables and you need them synced between the databases then Advanced Replication would be the route. If all you need are data changes from 1 database to be replicated to another database then simple replication is all you need. -Original Message-From: Rahul Dandekar [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 6:43 AMTo: Multiple recipients of list ORACLE-LSubject: Re: replication question Depends on your need. You can have read only snapshots, updatable snapshots or multimaster... Again if you think of multimaster... then you would need to make decision based on your application requirements about sync or async I donot have any expereince of snapshot replication. But, if you are planning multimaster replication, then better spend a couple of months studying it and testing on test boxes... Make 100% sure that your applicationreally needs the replication and there is no other simpler option... Just 2 cents... +Rahul - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Monday, March 04, 2002 3:33 AM Subject: replication question Dear Gurus, The clients will enter records to a database all day and I will update the other database . I need to replicate 10 tables in a database to other database at a specific time. Do I need Advanced replication or basic replication . ? How can I understand that replication
Re: replication question
Well, you could open standby DB only for read only access (8i) whereas in replication, both or all (more than 2) databases could be up and open to users all the times. Each DML causes substantial overhead as each transaction needs to be propogated and applied at all the master sites (whereas inOracle Parallel Server,there is centralized database accessed by multiple instances, there is no need for this). So, if you donot need two databases at two geographically separate locations, open for users, then Standby DB or OPSmight be better option. Again, in OPS, if the hardware cluster fails then you are in trouble... About speed, if you could tune up sending of logs and application of it, then Standby database would consume substantially lesser resources than replication, hence higher throughput... The primary database in Standby DB just needs to send the archivelogs (simple file transfer) and then log application happens on the secondary server... Whereas, in replication, the database would have to propogate and apply each and every transaction individually +Rahul - Original Message - From: James Ambursley To: Multiple recipients of list ORACLE-L Sent: Monday, March 04, 2002 1:24 PM Subject: RE: replication question Is replication faster than a standby database.As I understand it, the standby database will be receive arch logs at preset intervals. Does replication have the same functionality and about how much data is sent to the replicated site. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent: Monday, March 04, 2002 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: replication question The way I see it . the question comes down to whether or not you need two way replication or just one way. If both databases can update those tables and you need them synced between the databases then Advanced Replication would be the route. If all you need are data changes from 1 database to be replicated to another database then simple replication is all you need. -Original Message-From: Rahul Dandekar [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 6:43 AMTo: Multiple recipients of list ORACLE-LSubject: Re: replication question Depends on your need. You can have read only snapshots, updatable snapshots or multimaster... Again if you think of multimaster... then you would need to make decision based on your application requirements about sync or async I donot have any expereince of snapshot replication. But, if you are planning multimaster replication, then better spend a couple of months studying it and testing on test boxes... Make 100% sure that your applicationreally needs the replication and there is no other simpler option... Just 2 cents... +Rahul - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Monday, March 04, 2002 3:33 AM Subject: replication question Dear Gurus, The clients will enter records to a database all day and I will update the other database . I need to replicate 10 tables in a database to other database at a specific time. Do I need Advanced replication or basic replication . ? How can I understand that replication is supported in my both databases. ? Bunyamin
RE: replication question
Thanks tons Kevin, that is the information I was looking for. Great, quick response. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent: Monday, March 04, 2002 2:43 PMTo: Multiple recipients of list ORACLE-LSubject: RE: replication question I have used both. Replication, like archive log movement , happens whenever you set it up to happen. That can be anywhere from every minute to once a day to beyond. It just depends on your needs. In the case of my old job, we had replication happeningat different times for different tables. Our key table was replicating IMMEDIATELY uponany changes to the parent table. This happened via trigger.Other , not so important tables, would replicate at anywhere from 30 to 60 minutes. We did this using scheduled jobs. I see two realnice advantages ofreplicated databases. One, they are accessible.i.e. you can run reports, queries, etc on them. They are nothing more than instancesthat get updated via a foreign database. Two,depending on what kind of software you use, you can update the database from an outside source. We used to have data sent down from our DB2 database into our Oracle database using an oracle product called Replication Services (nothing more than triggers and a specific data structure) and an IBM product called Data Propogator. Archive log transport for standbys can happen in multiple ways also. The newer oracle versions support direct archiving from a production database to a standby database. I have not tried this yet but we are looking into it. Our current standby databases are brought up to date with a shell script that is scheduled via cron every 20 minutes. The thing about the standbys, they areall or nothing ... you can not just say I want only tables 1-10 to be updated. They all are. Also, in the older oracle versions, the standbys could not be accessed via software so you could not use them as any sort of read only database. This is not the case in a replicated database. But, they are also very easy to rebuild and resetup. Just copy your production files over, create a standby control file, and bring the databse up in standby mode. Very easy. Now... which would I recommend ??? Depends on your needs. If you really need to access that copy of the database for other purposes and you only want certain tables to be updated, then I would consider replication. If, on the other hand, you do not have to access the data (until such a time as your production gets killed and you need your standby up) and you need a fast way to rebuild the second database, I would suggest the Standby approach. Kevin -Original Message-From: James Ambursley [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 12:24 PMTo: Multiple recipients of list ORACLE-LSubject: RE: replication question Is replication faster than a standby database.As I understand it, the standby database will be receive arch logs at preset intervals. Does replication have the same functionality and about how much data is sent to the replicated site. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent: Monday, March 04, 2002 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: replication question The way I see it . the question comes down to whether or not you need two way replication or just one way. If both databases can update those tables and you need them synced between the databases then Advanced Replication would be the route. If all you need are data changes from 1 database to be replicated to another database then simple replication is all you need. -Original Message-From: Rahul Dandekar [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 6:43 AMTo: Multiple recipients of list ORACLE-LSubject: Re: replication question Depends on your need. You can have read only snapshots, updatable snapshots or multimaster... Again if you think of multimaster... then you would need to make decision based on your application requirements about sync or async I donot have any expereince of snapshot replication. But, if you are planning multimaster replication, then better spend a couple of months studying it and testing on test boxes... Make 100% sure that your applicationreally needs the replication and there is no other simpler option... Just 2 cents... +Rahul - Original Message - From: Bunyamin K
RE: Replication question
I believe that schema changes are only automatically propagated to all sites by using the Replication Manager orthe DBMS_REPCAT package. Nancy -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of ALEMU AbiySent: Monday, November 12, 2001 1:40 AMTo: Multiple recipients of list ORACLE-LSubject: Replication question I'm setting up a basic replication on a 8.1.7 oracle database and I'm wondering if a schema change is also replicated along with data changes. If I modify the structure of a table on the master site, is that modification is propagated to my snapshot site ? Please help
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
PLEASE HELP : Advanced replication question
Dear list ! Could not find this in the docs : itlooks like i can replicate tablesonly among schemas with same names in different DBs ( I.e i can only replicate SCOTT's objects into SCOTT schemas in remote DBs) Is this true ? If not , please advice what should i do or where can i read about it Thanks a lot in advance . Andrey