** advanced replication :: not propagating
Hi, I newly setup master to master replication : I followed the steps. It is 9i so no need to run catrep: 1) Create replication administrator repadmin 2) Grant privileges and register repadminas propagator and receiver 3) Create public database links, private database link in repadmin. 4) Create master groups, add objects and generate support. 5) Add master sites. 6) Schedule push and purge jobs. 7) Resume master activity The arrangement is primary -- secondary. I have made the push and purge jobs at secondary as broken. After that I made updates to the replicated tables and I can see the entryin deftran. The push job executes at primarybut transactions are not being propagated to secondary. I ran the job manually. It does not give any error but does not propagate. I can still see the entries in deftrandest. The links are working fine. Maybe I missed a step but cannot figure out. When I give the command to quisce replication that is SUSPEND_MASTER_ACTIVITY, then it propagates and applies the change to the other site. Which is strange of course. I tried this couple of times just to make sure that is the case. Maybe quisce does some operation and it leads to it and maybe there is a clue there but I cannot find. Can someone help? Thank You. Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard
RE: Multimaster replication as alternative backup
Simple,Clear and Superb explanation. Thanks Arup. -Original Message- Nanda Sent: Wednesday, November 19, 2003 1:10 AM To: Multiple recipients of list ORACLE-L VirVit, You haven't specified Oracle version and your tolerance for data loss. If you can afford to lose the data in the most current redo log file, then I would suggest 9i Data Guard in maximum performance mode (or Standby in 8i) solution over the MM replication. The DG solution does not affect the primary database performance. You can backup the standby database and use it for recovery of the primary, too. If you can't afford to lose any data, then you can still use the DG Maximum Protection (in 9i) mode, but it will affect the performance to some extent. However, in this case (no data loss) you have to enable MM Synchronous Replication as opposed to the default Asynchronous mode. In the Synch mode, the performance is worse compared to the Max Protection DG solution. Here is a summary of the options: Oracle 8i | +- Last redo data loss ok = Standby Database ~~ Performance=BEST +- LAst redo data los NOT ok = MM Synchronous Replication ~~ Performance=VERY BAD Oracle 9i | +- Last redo data loss ok = Data Guard Max Performance Mode ~~ Performance=BEST +- LAst redo data los NOT ok = | +- Option 1: MM Synchronous Replication ~~ Performance=VERY BAD +- Option 2: Data Guard Max Protection Mode ~~ Performance=BAD Therefore, you are better off using DG (or standby in 8i). Pros: (1) You can use standby datafiles to recover primary database (2) You can take RMAN backups from the standby, reducing the CPU cycle requirements in primary Cons: (1) In Max Protection Mode, the primary also halts if the standby has a problem; not truly a HA solution. Ideally you need three or more servers - one primary and two standbys to work perfectly = high cost Summary: If your management can live with the loss of the last redo, your best option is DG Max Performance (or Standby, in 8i), IMHO. HTH. Arup Nanda www.proligence.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 11:54 PM Hello! What do you think of additional backup method as multimaster replication? Isn't it a way to continue working normal, if main database crash and I move all connections to another master site? -- Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sami 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).
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).
Re: Oracle to MS-SQL Replication
Check for heterogenous services in Oracle docs. Tanel. - Original Message - From: Nikhil Khimani To: Multiple recipients of list ORACLE-L Sent: Friday, November 28, 2003 9:49 PM Subject: Oracle to MS-SQL Replication LG, Any pointers, white papers, URL, etc.on how to replicate data from Oracle 8i/9i to M$-SQL2K? Many thanks, Nick Khimani
Oracle to MS-SQL Replication
LG, Any pointers, white papers, URL, etc.on how to replicate data from Oracle 8i/9i to M$-SQL2K? Many thanks, Nick Khimani
Re: Multimaster replication as alternative backup
Verification was easy. We just powered down the primary machine, changed the db name in the external table, drop the replication on the backup server and restart the application. Everything worked fine. After 2-3 days, over the weekend, we rebuilt the replication again. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 8:00 PM Yechiel - So how do you verify your backup environment? My gut feeling is that simpler systems are less prone to catastrophe, and multimaster replication definitely adds a lot of pieces compared to conventional backups. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 19, 2003 11:05 AM To: Multiple recipients of list ORACLE-L We are doing exactly that. We use multi master synchronous replication. In case the regular server dies, we drop replication from the backup machine. Change one parameter in the application ini file (what db name to use in connections), start the application again. About 5 minutes turn around time. Use it only if you have high speed connection and the servers are close. It adds about 10% overhead to the application. It depends on the amount of updates vs. selects of the application. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 6:54 AM Hello! What do you think of additional backup method as multimaster replication? Isn't it a way to continue working normal, if main database crash and I move all connections to another master site? -- Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit 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: Yechiel Adar 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: DENNIS WILLIAMS 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: Yechiel Adar 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: Multimaster replication as alternative backup
We are doing exactly that. We use multi master synchronous replication. In case the regular server dies, we drop replication from the backup machine. Change one parameter in the application ini file (what db name to use in connections), start the application again. About 5 minutes turn around time. Use it only if you have high speed connection and the servers are close. It adds about 10% overhead to the application. It depends on the amount of updates vs. selects of the application. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 6:54 AM Hello! What do you think of additional backup method as multimaster replication? Isn't it a way to continue working normal, if main database crash and I move all connections to another master site? -- Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit 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: Yechiel Adar 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: Multimaster replication as alternative backup
Yechiel - So how do you verify your backup environment? My gut feeling is that simpler systems are less prone to catastrophe, and multimaster replication definitely adds a lot of pieces compared to conventional backups. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 19, 2003 11:05 AM To: Multiple recipients of list ORACLE-L We are doing exactly that. We use multi master synchronous replication. In case the regular server dies, we drop replication from the backup machine. Change one parameter in the application ini file (what db name to use in connections), start the application again. About 5 minutes turn around time. Use it only if you have high speed connection and the servers are close. It adds about 10% overhead to the application. It depends on the amount of updates vs. selects of the application. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 6:54 AM Hello! What do you think of additional backup method as multimaster replication? Isn't it a way to continue working normal, if main database crash and I move all connections to another master site? -- Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit 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: Yechiel Adar 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: DENNIS WILLIAMS 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).
Multimaster replication as alternative backup
Hello! What do you think of additional backup method as multimaster replication? Isn't it a way to continue working normal, if main database crash and I move all connections to another master site? -- Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit 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: Multimaster replication as alternative backup
VirVit, You haven't specified Oracle version and your tolerance for data loss. If you can afford to lose the data in the most current redo log file, then I would suggest 9i Data Guard in maximum performance mode (or Standby in 8i) solution over the MM replication. The DG solution does not affect the primary database performance. You can backup the standby database and use it for recovery of the primary, too. If you can't afford to lose any data, then you can still use the DG Maximum Protection (in 9i) mode, but it will affect the performance to some extent. However, in this case (no data loss) you have to enable MM Synchronous Replication as opposed to the default Asynchronous mode. In the Synch mode, the performance is worse compared to the Max Protection DG solution. Here is a summary of the options: Oracle 8i | +- Last redo data loss ok = Standby Database ~~ Performance=BEST +- LAst redo data los NOT ok = MM Synchronous Replication ~~ Performance=VERY BAD Oracle 9i | +- Last redo data loss ok = Data Guard Max Performance Mode ~~ Performance=BEST +- LAst redo data los NOT ok = | +- Option 1: MM Synchronous Replication ~~ Performance=VERY BAD +- Option 2: Data Guard Max Protection Mode ~~ Performance=BAD Therefore, you are better off using DG (or standby in 8i). Pros: (1) You can use standby datafiles to recover primary database (2) You can take RMAN backups from the standby, reducing the CPU cycle requirements in primary Cons: (1) In Max Protection Mode, the primary also halts if the standby has a problem; not truly a HA solution. Ideally you need three or more servers - one primary and two standbys to work perfectly = high cost Summary: If your management can live with the loss of the last redo, your best option is DG Max Performance (or Standby, in 8i), IMHO. HTH. Arup Nanda www.proligence.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 11:54 PM Hello! What do you think of additional backup method as multimaster replication? Isn't it a way to continue working normal, if main database crash and I move all connections to another master site? -- Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit 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).
Help needed -- Replication and DBMS_JOB
Dear Gurus, I have dbms_job in replication environment to push deffered transactions from site A to B and B to A. The job which is running at site A is working fine but job which is running at site B is not pushing the transactions automatically. But if I do it manually (either dbms_job.run(job_number) or using OEM UI) it is working fine. Otherwise dbms_job failed count keep increases every minute and finally it becomes broken. The owner of the DBMS_JOB is REPADMIN at both sites. Is there a way to check the root cause for the failed DBMS_JOB?. I need to check the reason why the particular DBMS_JOB is failing. I don't want DBA_JOBs view because DBA_JOBS gives the number of failed count. Note:- Number of Job_queue_processes is configured as 20 in both sites(A and B). Also iI confirmed that 20 # of snp unix process is running at each node. job_queue_interval is 60 secs. thanks Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help needed -- Replication and DBMS_JOB
Jay, Check http://www.oriole.com/aunt_2001_0.html and look for the 19th. March 2001 entry. Otherwise look for a snp*.trc in either bdump or udump (never remember where it goes). HTH SF - --- Original Message --- - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Fri, 14 Nov 2003 05:29:30 Dear Gurus, I have dbms_job in replication environment to push deffered transactions from site A to B and B to A. The job which is running at site A is working fine but job which is running at site B is not pushing the transactions automatically. But if I do it manually (either dbms_job.run(job_number) or using OEM UI) it is working fine. Otherwise dbms_job failed count keep increases every minute and finally it becomes broken. The owner of the DBMS_JOB is REPADMIN at both sites. Is there a way to check the root cause for the failed DBMS_JOB?. I need to check the reason why the particular DBMS_JOB is failing. I don't want DBA_JOBs view because DBA_JOBS gives the number of failed count. Note:- Number of Job_queue_processes is configured as 20 in both sites(A and B). Also iI confirmed that 20 # of snp unix process is running at each node. job_queue_interval is 60 secs. thanks Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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: RE: Help needed -- Replication and DBMS_JOB
Stephane, This is what I was exactly looking for. Thank you so much. - Original Message - Date: Friday, November 14, 2003 8:59 am Jay, Check http://www.oriole.com/aunt_2001_0.html and look for the 19th. March 2001 entry. Otherwise look for a snp*.trc in either bdump or udump (never remember where it goes). HTH SF - --- Original Message --- - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Fri, 14 Nov 2003 05:29:30 Dear Gurus, I have dbms_job in replication environment to push deffered transactions from site A to B and B to A. The job which is running at site A is working fine but job which is running at site B is not pushing the transactions automatically. But if I do it manually (either dbms_job.run(job_number) or using OEM UI) it is working fine. Otherwise dbms_job failed count keep increases every minute and finally it becomes broken. The owner of the DBMS_JOB is REPADMIN at both sites. Is there a way to check the root cause for the failed DBMS_JOB?. I need to check the reason why the particular DBMS_JOB is failing. I don't want DBA_JOBs view because DBA_JOBS gives the number of failed count. Note:- Number of Job_queue_processes is configured as 20 in both sites(A and B). Also iI confirmed that 20 # of snp unix process is running at each node. job_queue_interval is 60 secs. thanks Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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: 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: any problem rebuilding indexes used for replication
I'm curious, how have you identified the fragmentation? What benefits do you expect from the rebuild of the indexes? Are you targeting certain indexes that have been identified as benefiting from a rebuild, or just planning to rebuild all indexes? Jared renu r [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/05/2003 06:14 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:any problem rebuilding indexes used for replication Hello, I have to rebuild some primary key indexes due to excessive fragmentation. It is rebuild not drop and create. We have multi master replication running. Is there any problem to replication if I do that. Has anyone tried it? TIA. Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard
Re: any problem rebuilding indexes used for replication
Jared : I think it is fragmented based on scripts and knowing that there have been lot of deletes. Onescript uses the table index_stats and looks at field del_lf_rows which should be less at least in comparison to field lf_rows. Imean less is good. more bad. I am not sure about the script but I will post it here if someonesays soor send it to anyone if they want. I am sure the expertshere know about it and can clarify if it is any good to look at the index_stats table. One other simple useful script is : SELECTowner, index_name, blevelFROMall_indexesWHEREblevel 2 This can be bacause the size of table is big so it is not definitive. I will check the level after rebuild. Benefits expected : Space savings (definitely). performance (hopefully). I will let you and Yong know about the benefits if any. If I get some help. [EMAIL PROTECTED] wrote: I'm curious, how have you identified the fragmentation? What benefits do you expect from the rebuild of the indexes? Are you targeting certain indexes that have been identified as benefiting from a rebuild, or just planning to rebuild all indexes? Jared renu r [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/05/2003 06:14 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:any problem rebuilding indexes used for replicationHello, I have to rebuild some primary key indexes due to excessive fragmentation. It is rebuild not drop and create. We have multi master replication running. Is there any problem to replication if I do that. Has anyone tried it? TIA. Do you Yahoo!?Protect your identity with Yahoo! Mail AddressGuard Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard
Re: any problem rebuilding indexes used for replication
Re the space savings: that may or not be important. Guess it depends on how tight storage space is in your environment, and how much of an impact it may make on your backups. Re the performance: Some queries could perform better due to the index data being packed into fewer blocks, as you are expecting. It could also result in decreased performance for inserts, for the same reason. An index with all data tightly packed into nearly full blocks makes it a good candidate for excessive block splits when data is inserted into the table. You could allow a generous PCTFREE when you rebuild to alleviate this, but then there would not be much point in rebuilding the index. You might consider targeting your most expensive operations ( eg. the SQL that causes the users and/or the system the most pain ) and then look at the indexes involved to see if rebuilding them would increase or decrease performance. Lots of discussion lately on this list on how to go about doing that. ( Optimizing Oracle Performance - http://www.oreilly.com/catalog/optoraclep/ ) HTH Jared renu r [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/06/2003 02:29 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: any problem rebuilding indexes used for replication Jared : I think it is fragmented based on scripts and knowing that there have been lot of deletes. One script uses the table index_stats and looks at field del_lf_rows which should be less at least in comparison to field lf_rows. I mean less is good. more bad. I am not sure about the script but I will post it here if someone says so or send it to anyone if they want. I am sure the experts here know about it and can clarify if it is any good to look at the index_stats table. One other simple useful script is : SELECT owner, index_name, blevel FROM all_indexes WHERE blevel 2 This can be bacause the size of table is big so it is not definitive. I will check the level after rebuild. Benefits expected : Space savings (definitely). performance (hopefully). I will let you and Yong know about the benefits if any. If I get some help. [EMAIL PROTECTED] wrote: I'm curious, how have you identified the fragmentation? What benefits do you expect from the rebuild of the indexes? Are you targeting certain indexes that have been identified as benefiting from a rebuild, or just planning to rebuild all indexes? Jared renu r [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/05/2003 06:14 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:any problem rebuilding indexes used for replication Hello, I have to rebuild some primary key indexes due to excessive fragmentation. It is rebuild not drop and create. We have multi master replication running. Is there any problem to replication if I do that. Has anyone tried it? TIA. Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard
Re: any problem rebuilding indexes used for replication
renu (and Jared), The reason I'm very interested in whether there's performance improvement is that there's a thread on the newsgroup about index rebuild recently. See http://groups.google.com/groups?threadm=pan.2003.11.03.08.09.24.330520%40RE-MO-VE.BountifulSolutions.co.uk Jonathan Lewis says there's almost no need to rebuild indexes, although his Practical Oracle8i lists at least one case you may benefit by rebuilding. (I don't have the book with me). Asktom.oracle.com has numerous messages advising against rebuilding indexes. Let's set theory aside for a moment and do the experiment. Please post your report of performance change. Thanks. Yong Huang --- renu r [EMAIL PROTECTED] wrote: Jared : I think it is fragmented based on scripts and knowing that there have been lot of deletes. One script uses the table index_stats and looks at field del_lf_rows which should be less at least in comparison to field lf_rows. I mean less is good. more bad. I am not sure about the script but I will post it here if someone says so or send it to anyone if they want. I am sure the experts here know about it and can clarify if it is any good to look at the index_stats table. One other simple useful script is : SELECT owner, index_name, blevel FROM all_indexes WHERE blevel 2 This can be bacause the size of table is big so it is not definitive. I will check the level after rebuild. Benefits expected : Space savings (definitely). performance (hopefully). I will let you and Yong know about the benefits if any. If I get some help. [EMAIL PROTECTED] wrote: I'm curious, how have you identified the fragmentation? What benefits do you expect from the rebuild of the indexes? Are you targeting certain indexes that have been identified as benefiting from a rebuild, or just planning to rebuild all indexes? Jared renu r [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/05/2003 06:14 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:any problem rebuilding indexes used for replication Hello, I have to rebuild some primary key indexes due to excessive fragmentation. It is rebuild not drop and create. We have multi master replication running. Is there any problem to replication if I do that. Has anyone tried it? TIA. __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang 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: any problem rebuilding indexes used for replication
I think Jonathan is correct when he says that index rebuilds are not often needed. Tom Kyte states that they are never needed, which I don't believe to be correct. I'll try to back this up with data in the future. So if Tom asks any of you why you don't use automatic space management in your LMT's, you can ask him why he doesn't use 'alter index rebuild'. ;) Jared Yong Huang [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/06/2003 02:59 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: any problem rebuilding indexes used for replication renu (and Jared), The reason I'm very interested in whether there's performance improvement is that there's a thread on the newsgroup about index rebuild recently. See http://groups.google.com/groups?threadm=pan.2003.11.03.08.09.24.330520%40RE-MO-VE.BountifulSolutions.co.uk Jonathan Lewis says there's almost no need to rebuild indexes, although his Practical Oracle8i lists at least one case you may benefit by rebuilding. (I don't have the book with me). Asktom.oracle.com has numerous messages advising against rebuilding indexes. Let's set theory aside for a moment and do the experiment. Please post your report of performance change. Thanks. Yong Huang --- renu r [EMAIL PROTECTED] wrote: Jared : I think it is fragmented based on scripts and knowing that there have been lot of deletes. One script uses the table index_stats and looks at field del_lf_rows which should be less at least in comparison to field lf_rows. I mean less is good. more bad. I am not sure about the script but I will post it here if someone says so or send it to anyone if they want. I am sure the experts here know about it and can clarify if it is any good to look at the index_stats table. One other simple useful script is : SELECT owner, index_name, blevel FROM all_indexes WHERE blevel 2 This can be bacause the size of table is big so it is not definitive. I will check the level after rebuild. Benefits expected : Space savings (definitely). performance (hopefully). I will let you and Yong know about the benefits if any. If I get some help. [EMAIL PROTECTED] wrote: I'm curious, how have you identified the fragmentation? What benefits do you expect from the rebuild of the indexes? Are you targeting certain indexes that have been identified as benefiting from a rebuild, or just planning to rebuild all indexes? Jared renu r [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/05/2003 06:14 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:any problem rebuilding indexes used for replication Hello, I have to rebuild some primary key indexes due to excessive fragmentation. It is rebuild not drop and create. We have multi master replication running. Is there any problem to replication if I do that. Has anyone tried it? TIA. __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang 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: any problem rebuilding indexes used for replication
Hi,
In some case, rebuild index can help, this is from my work log on my Datawarehouse
project.
The effect of rebuiding index:
SQL exec show_space('INX_BID_BIDTYPE',USER,'INDEX')
Free Blocks.22
Total Blocks4090
Total Bytes.33505280
Unused Blocks...823
Unused Bytes6742016
Last Used Ext FileId11
Last Used Ext BlockId...52851
Last Used Block.547
PL/SQL procedure successfully completed.
SQL select index_name,owner,blevel,index_type from dba_indexes where blevel4;
INDEX_NAME OWNER BLEVEL INDEX_TYPE
-- -- --
---
INX_BID_BIDTYPEDAILYLOAD 10 BITMAP
INX_TX_CC_STATUS_IDDAILYLOAD 6 BITMAP
INX_TX_BD_STATUS_IDDAILYLOAD 5 BITMAP
SQL ALTER INDEX INX_BID_BIDTYPE REBUILD;
Index altered.
SQL exec show_space('INX_BID_BIDTYPE',USER,'INDEX')
Free Blocks.0
Total Blocks5
Total Bytes.40960
Unused Blocks...3
Unused Bytes24576
Last Used Ext FileId15
Last Used Ext BlockId...39837
Last Used Block.2
PL/SQL procedure successfully completed.
DAILYSOURCEINX_STD_ST_STATEMENTID
122910
149 rows selected.
SQL CONN SYSTEM/[EMAIL PROTECTED]
Connected.
SQL ALTER INDEX DAILYSOURCE.INX_STD_ST_STATEMENTID REBUILD;
Index altered.
SQL select 122910*16/1024 from dual;
122910*16/1024
--
1920.46875
SQL select blocks from dba_segments where segment_name='INX_STD_ST_STATEMENTID';
BLOCKS
--
54642
SQL SELECT 54642*16/1024 FROM DUAL;
54642*16/1024
-
853.78125
SQL SET PAUSE OFF
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, November 07, 2003 6:59 AM
renu (and Jared),
The reason I'm very interested in whether there's performance improvement is
that there's a thread on the newsgroup about index rebuild recently. See
http://groups.google.com/groups?threadm=pan.2003.11.03.08.09.24.330520%40RE-MO-VE.BountifulSolutions.co.uk
Jonathan Lewis says there's almost no need to rebuild indexes, although his
Practical Oracle8i lists at least one case you may benefit by rebuilding. (I
don't have the book with me). Asktom.oracle.com has numerous messages advising
against rebuilding indexes. Let's set theory aside for a moment and do the
experiment. Please post your report of performance change. Thanks.
Yong Huang
--- renu r [EMAIL PROTECTED] wrote:
Jared : I think it is fragmented based on scripts and knowing that there have
been lot of deletes.
One script uses the table index_stats and looks at field del_lf_rows which
should be less at least in comparison to field lf_rows. I mean less is good.
more bad. I am not sure about the script but I will post it here if someone
says so or send it to anyone if they want.
I am sure the experts here know about it and can clarify if it is any good
to look at the index_stats table.
One other simple useful script is :
SELECT owner, index_name, blevel
FROM all_indexes
WHERE blevel 2
This can be bacause the size of table is big so it is not definitive. I will
check the level after rebuild.
Benefits expected : Space savings (definitely). performance (hopefully). I
will let you and Yong know about the benefits if any. If I get some help.
[EMAIL PROTECTED] wrote:
I'm curious, how have you identified the fragmentation?
What benefits do you expect from the rebuild of the indexes?
Are you targeting certain indexes that have been identified as
benefiting from a rebuild, or just planning to rebuild all indexes?
Jared
renu r [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/05/2003 06:14 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:any problem rebuilding indexes used for replication
Hello,
I have to rebuild some primary key indexes due to excessive fragmentation.
It is rebuild not drop and create. We have multi master replication running.
Is there any problem to replication if I do that. Has anyone tried it? TIA.
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
Please see the official ORACLE-L FAQ
Re: any problem rebuilding indexes used for replication
--- [EMAIL PROTECTED] wrote: Tom Kyte states that they are never needed, which I don't believe to be correct. As I said two weeks ago, somewhere on the Internet people over-trusted authorities. It's different here. I love this place! I'll try to back this up with data in the future. As a Ph.D in chemistry (sorry to say this), I know how more important repeated experiments done by different people in different labs are than theory. Furthermore, a lab experiment is nothing if a product coming out of a chemical plant says no good. So if Tom asks any of you why you don't use automatic space management in your LMT's, you can ask him why he doesn't use 'alter index rebuild'. ;) Jared Yong Huang [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/06/2003 02:59 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: any problem rebuilding indexes used for replication renu (and Jared), The reason I'm very interested in whether there's performance improvement is that there's a thread on the newsgroup about index rebuild recently. See http://groups.google.com/groups?threadm=pan.2003.11.03.08.09.24.330520%40RE-MO-VE.BountifulSolutions.co.uk Jonathan Lewis says there's almost no need to rebuild indexes, although his Practical Oracle8i lists at least one case you may benefit by rebuilding. (I don't have the book with me). Asktom.oracle.com has numerous messages advising against rebuilding indexes. Let's set theory aside for a moment and do the experiment. Please post your report of performance change. Thanks. Yong Huang --- renu r [EMAIL PROTECTED] wrote: Jared : I think it is fragmented based on scripts and knowing that there have been lot of deletes. One script uses the table index_stats and looks at field del_lf_rows which should be less at least in comparison to field lf_rows. I mean less is good. more bad. I am not sure about the script but I will post it here if someone says so or send it to anyone if they want. I am sure the experts here know about it and can clarify if it is any good to look at the index_stats table. One other simple useful script is : SELECT owner, index_name, blevel FROM all_indexes WHERE blevel 2 This can be bacause the size of table is big so it is not definitive. I will check the level after rebuild. Benefits expected : Space savings (definitely). performance (hopefully). I will let you and Yong know about the benefits if any. If I get some help. [EMAIL PROTECTED] wrote: I'm curious, how have you identified the fragmentation? What benefits do you expect from the rebuild of the indexes? Are you targeting certain indexes that have been identified as benefiting from a rebuild, or just planning to rebuild all indexes? Jared renu r [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/05/2003 06:14 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:any problem rebuilding indexes used for replication Hello, I have to rebuild some primary key indexes due to excessive fragmentation. It is rebuild not drop and create. We have multi master replication running. Is there any problem to replication if I do that. Has anyone tried it? TIA. __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang 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: any problem rebuilding indexes used for replication
] cc: Subject:any problem rebuilding indexes used for replication Hello, I have to rebuild some primary key indexes due to excessive fragmentation. It is rebuild not drop and create. We have multi master replication running. Is there any problem to replication if I do that. Has anyone tried it? TIA. __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang 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: zhu chao INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services === message truncated === __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang 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: any problem rebuilding indexes used for replication
OK, that's a bitmap index. Bitmap indexes do need to be rebuilt after
accumulated maintenance (insert-update-delete) to reclaim space and
performance. Not even Tom denies that. What he advises against is the
rebuild of b-tree indexes.
At 07:49 PM 11/6/2003, you wrote:
Hi,
In some case, rebuild index can help, this is from my work log on my
Datawarehouse project.
The effect of rebuiding index:
SQL exec show_space('INX_BID_BIDTYPE',USER,'INDEX')
Free Blocks.22
Total Blocks4090
Total Bytes.33505280
Unused Blocks...823
Unused Bytes6742016
Last Used Ext FileId11
Last Used Ext BlockId...52851
Last Used Block.547
PL/SQL procedure successfully completed.
SQL select index_name,owner,blevel,index_type from dba_indexes where
blevel4;
INDEX_NAME OWNER BLEVEL
INDEX_TYPE
-- -- --
---
INX_BID_BIDTYPEDAILYLOAD 10
BITMAP
INX_TX_CC_STATUS_IDDAILYLOAD 6
BITMAP
INX_TX_BD_STATUS_IDDAILYLOAD 5
BITMAP
SQL ALTER INDEX INX_BID_BIDTYPE REBUILD;
Index altered.
SQL exec show_space('INX_BID_BIDTYPE',USER,'INDEX')
Free Blocks.0
Total Blocks5
Total Bytes.40960
Unused Blocks...3
Unused Bytes24576
Last Used Ext FileId15
Last Used Ext BlockId...39837
Last Used Block.2
PL/SQL procedure successfully completed.
DAILYSOURCEINX_STD_ST_STATEMENTID
122910
149 rows selected.
SQL CONN SYSTEM/[EMAIL PROTECTED]
Connected.
SQL ALTER INDEX DAILYSOURCE.INX_STD_ST_STATEMENTID REBUILD;
Index altered.
SQL select 122910*16/1024 from dual;
122910*16/1024
--
1920.46875
SQL select blocks from dba_segments where
segment_name='INX_STD_ST_STATEMENTID';
BLOCKS
--
54642
SQL SELECT 54642*16/1024 FROM DUAL;
54642*16/1024
-
853.78125
SQL SET PAUSE OFF
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, November 07, 2003 6:59 AM
renu (and Jared),
The reason I'm very interested in whether there's performance
improvement is
that there's a thread on the newsgroup about index rebuild recently. See
http://groups.google.com/groups?threadm=pan.2003.11.03.08.09.24.330520%40RE-MO-VE.BountifulSolutions.co.uk
Jonathan Lewis says there's almost no need to rebuild indexes, although his
Practical Oracle8i lists at least one case you may benefit by
rebuilding. (I
don't have the book with me). Asktom.oracle.com has numerous messages
advising
against rebuilding indexes. Let's set theory aside for a moment and do the
experiment. Please post your report of performance change. Thanks.
Yong Huang
--- renu r [EMAIL PROTECTED] wrote:
Jared : I think it is fragmented based on scripts and knowing that
there have
been lot of deletes.
One script uses the table index_stats and looks at field del_lf_rows
which
should be less at least in comparison to field lf_rows. I mean less
is good.
more bad. I am not sure about the script but I will post it here if
someone
says so or send it to anyone if they want.
I am sure the experts here know about it and can clarify if it is
any good
to look at the index_stats table.
One other simple useful script is :
SELECT owner, index_name, blevel
FROM all_indexes
WHERE blevel 2
This can be bacause the size of table is big so it is not definitive.
I will
check the level after rebuild.
Benefits expected : Space savings (definitely). performance
(hopefully). I
will let you and Yong know about the benefits if any. If I get some help.
[EMAIL PROTECTED] wrote:
I'm curious, how have you identified the fragmentation?
What benefits do you expect from the rebuild of the indexes?
Are you targeting certain indexes that have been identified as
benefiting from a rebuild, or just planning to rebuild all indexes?
Jared
renu r [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/05/2003 06:14 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:any problem rebuilding indexes used for
replication
Hello,
I have to rebuild some primary key indexes due to excessive
fragmentation.
It is rebuild not drop and create. We have multi master replication
running.
Is there any problem to replication if I do that. Has anyone tried
any problem rebuilding indexes used for replication
Hello, Ihave torebuild some primary key indexesdue to excessive fragmentation. It is rebuild not drop and create.We have multi master replication running. Is there any problem to replicationif I do that. Has anyone tried it? TIA. Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard
Re: any problem rebuilding indexes used for replication
Hi, renu, I'll let experts anwser your question. But I have a request for you. Before and after you rebuild (or coalesce) your indexes, please make close observation on your application performance, as well as the statistics and sizes of the indexes. I'd like to know whether rebuilding them actually makes much difference. (I don't know the answer but am very interested to know). Thanks. Yong Huang --- renu r [EMAIL PROTECTED] wrote: Hello, I have to rebuild some primary key indexes due to excessive fragmentation. It is rebuild not drop and create. We have multi master replication running. Is there any problem to replication if I do that. Has anyone tried it? TIA. __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang 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 : ORA-04068: existing state of packages has been
Hi!
Just for the record, one other solution would probably have been to set
REMOTE_DEPENDENCIES_MODE = SIGNATURE.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, October 25, 2003 10:24 PM
Thanks Jared.
Recently we did run catrepr.sql and catrep.sql to recreate replication
catalog.
I was getting the same error even after recompiled all the invalid
objects(few packages were invalid). Then restared my instance and now it is
woking fine.
Thanks again
-tamizh
- Original Message -
Date: Saturday, October 25, 2003 2:04 pm
Have you recently made any changes to your database?
Upgrades, etc?
This is the message you will receive when the state
of a package is invalid. It either needs recompiled,
as something it is dependent on has changed, and/or
it is broken for the same reason.
One possible explanation for this is an incomplete
upgrade.
You can recompile all stored code in the database
by logging in as SYS and running $ORACLE_HOME/rdbms/admin/utlrp.sql.
There's another script for this as well, but I can't recall
it at the moment. The above script is generally used as
a final step in an upgrade.
Jared
On Sat, 2003-10-25 at 10:14, [EMAIL PROTECTED] wrote:
Hi List,
Coudl someone please help me out to resolve this issue?
1 begin
2* dbms_repcat.do_deferred_repcat_admin('scott_mg',FALSE);
end;
/
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04062: of has been changed
ORA-04062: timestamp of package SYS.DBMS_REPCAT_RPC has been
changed ORA-06512: at SYS.DBMS_REPCAT_MAS, line 812
ORA-06512: at SYS.DBMS_REPCAT, line 532
ORA-06512: at line 2
-tamizh
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
services -
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jared Still
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:
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: Tanel Poder
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).
Isolating one of the replication DB
Hi List, We have 4 multi master database setup in our shop and like to isolate (disconnect/remove) one of the database from replication. What are the steps to be performed( the remaining 3 db should not be affected). Thanks in advance -tamizh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Isolating one of the replication DB
Hi List, We have 4 multi master database setup in our shop and like to isolate (disconnect/remove) one of the database from replication. What are the steps to be performed( the remaining 3 db should not be affected). Thanks in advance -tamizh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Replication
I'm sorry - been very busy these last several days. Yes, a somewhat flippant answer, but I built replication for our place (asynchronous, master-master, multiple remote instances with full constraint support) years ago, and its still running very reliably. Must be cheaper than Oracle's product... ! If you really want more details, then contact me off-line. peter edinburgh -Original Message- Sent: Wednesday, October 22, 2003 12:39 PM To: Multiple recipients of list ORACLE-L Peter, your reply was empty, could pls. send it again, maybe you have valuable information... rgds gb Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Gunnar=20Berglund?= 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). * 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. .http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter 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 : ORA-04068: existing state of packages has been discarded
Hi List,
Coudl someone please help me out to resolve this issue?
1 begin
2* dbms_repcat.do_deferred_repcat_admin('scott_mg',FALSE);
end;
/
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04062: of has been changed
ORA-04062: timestamp of package SYS.DBMS_REPCAT_RPC has been changed
ORA-06512: at SYS.DBMS_REPCAT_MAS, line 812
ORA-06512: at SYS.DBMS_REPCAT, line 532
ORA-06512: at line 2
-tamizh
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Replication : ORA-04068: existing state of packages has been
Have you recently made any changes to your database?
Upgrades, etc?
This is the message you will receive when the state
of a package is invalid. It either needs recompiled,
as something it is dependent on has changed, and/or
it is broken for the same reason.
One possible explanation for this is an incomplete
upgrade.
You can recompile all stored code in the database
by logging in as SYS and running $ORACLE_HOME/rdbms/admin/utlrp.sql.
There's another script for this as well, but I can't recall
it at the moment. The above script is generally used as
a final step in an upgrade.
Jared
On Sat, 2003-10-25 at 10:14, [EMAIL PROTECTED] wrote:
Hi List,
Coudl someone please help me out to resolve this issue?
1 begin
2* dbms_repcat.do_deferred_repcat_admin('scott_mg',FALSE);
end;
/
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04062: of has been changed
ORA-04062: timestamp of package SYS.DBMS_REPCAT_RPC has been changed
ORA-06512: at SYS.DBMS_REPCAT_MAS, line 812
ORA-06512: at SYS.DBMS_REPCAT, line 532
ORA-06512: at line 2
-tamizh
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jared Still
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 : ORA-04068: existing state of packages has been
Thanks Jared.
Recently we did run catrepr.sql and catrep.sql to recreate replication catalog.
I was getting the same error even after recompiled all the invalid objects(few
packages were invalid). Then restared my instance and now it is woking fine.
Thanks again
-tamizh
- Original Message -
Date: Saturday, October 25, 2003 2:04 pm
Have you recently made any changes to your database?
Upgrades, etc?
This is the message you will receive when the state
of a package is invalid. It either needs recompiled,
as something it is dependent on has changed, and/or
it is broken for the same reason.
One possible explanation for this is an incomplete
upgrade.
You can recompile all stored code in the database
by logging in as SYS and running $ORACLE_HOME/rdbms/admin/utlrp.sql.
There's another script for this as well, but I can't recall
it at the moment. The above script is generally used as
a final step in an upgrade.
Jared
On Sat, 2003-10-25 at 10:14, [EMAIL PROTECTED] wrote:
Hi List,
Coudl someone please help me out to resolve this issue?
1 begin
2* dbms_repcat.do_deferred_repcat_admin('scott_mg',FALSE);
end;
/
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04062: of has been changed
ORA-04062: timestamp of package SYS.DBMS_REPCAT_RPC has been
changed ORA-06512: at SYS.DBMS_REPCAT_MAS, line 812
ORA-06512: at SYS.DBMS_REPCAT, line 532
ORA-06512: at line 2
-tamizh
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
services -
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jared Still
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:
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 : ORA-04068: existing state of packages has been
There's another script for this as well, but I can't recall it at the moment. The above script is generally used as a final step in an upgrade. Jared Hi Jared, Did you mean: utlirp.sql - UTiLity script to Invalidate Recompile Pl/sql modules Which does the extra invalidate first that utlrp.sql doesn't do. utlirp.sql uses utlip.sql first to invalidate all PL/SQL and then uses utlrp.sql to recompile all the invalid packages. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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 : ORA-04068: existing state of packages has been
Thanks Pete, that was the one. Jared On Sat, 2003-10-25 at 15:09, Pete Finnigan wrote: There's another script for this as well, but I can't recall it at the moment. The above script is generally used as a final step in an upgrade. Jared Hi Jared, Did you mean: utlirp.sql - UTiLity script to Invalidate Recompile Pl/sql modules Which does the extra invalidate first that utlrp.sql doesn't do. utlirp.sql uses utlip.sql first to invalidate all PL/SQL and then uses utlrp.sql to recompile all the invalid packages. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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: Jared Still 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).
Setup a replication (multi-master)
Hi all,
I am trying to setup a replication and it went smoothly up-to here, any ideas what I can do...
SQL EXECUTE Dbms_Repcat.Create_Master_Repobject('TEST55', 'TESTHOST5', 'TABLE', gname='MYREPGRP',copy_rows=false);BEGIN Dbms_Repcat.Create_Master_Repobject('TEST55', 'TESTHOST5', 'TABLE', gname='MYREPGRP',c
*ERROR at line 1:ORA-23308: object TEST55.TESTHOST5 does not exist or is invalidORA-06512: at "SYS.DBMS_REPCAT_MAS", line 2627ORA-06512: at "SYS.DBMS_REPCAT", line 562ORA-06512: at line 1Want to chat instantly with your online friends? Get the FREE Yahoo!
Messenger
Replication
Hi all, I have an environment where we are replication from Master to Slave a number of tables. But there is one table which needs to replicate also both ways. Currently I have setup snapshots/mviews master-slave, how I can implement this one table to be replicated also other way... rgds gbWant to chat instantly with your online friends? Get the FREE Yahoo! Messenger
RE: Replication
--_=_NextPart_001_01C39882.D1104260 Content-Type: text/plain; charset=iso-8859-1 Use Oracla's advanced replication (only available with Enterprise Edition). Or use the patented Robson method!! peter -Original Message- Sent: Wednesday, October 22, 2003 11:45 AM To: Multiple recipients of list ORACLE-L Hi all, I have an environment where we are replication from Master to Slave a number of tables. But there is one table which needs to replicate also both ways. Currently I have setup snapshots/mviews master-slave, how I can implement this one table to be replicated also other way... rgds gb _ Want to chat instantly with your online friends? http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.co m/ Get the FREE Yahoo! Messenger * 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. .http://www.bgs.ac.uk * --_=_NextPart_001_01C39882.D1104260 Content-Type: text/html; charset=iso-8859-1 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 META content=MSHTML 6.00.2800.1106 name=GENERATOR/HEAD BODY DIVSPAN class=840295409-22102003FONT face=Arial color=#ff size=2Use Oracla's advanced replication (only available with Enterprise Edition). Or use the patented Robson method!!/FONT/SPAN/DIV DIVSPAN class=840295409-22102003FONT face=Arial color=#ff size=2/FONT/SPANnbsp;/DIV DIVSPAN class=840295409-22102003FONT face=Arial color=#ff size=2peter/FONT/SPAN/DIV DIVSPAN class=840295409-22102003FONT face=Arial color=#ff size=2/FONT/SPANnbsp;/DIV BLOCKQUOTE style=PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #ff 2px solid DIV class=OutlookMessageHeader dir=ltr align=leftFONT face=Tahoma size=2-Original Message-BRBFrom:/B Gunnar Berglund [mailto:[EMAIL PROTECTED]BRBSent:/B Wednesday, October 22, 2003 11:45 AMBRBTo:/B Multiple recipients of list ORACLE-LBRBSubject:/B Replication BRBR/FONT/DIV DIVHi all,/DIV DIVnbsp;/DIV DIVI have an environment where we are replication from Master to Slave a number of tables./DIV DIVnbsp;/DIV DIVBut there is one table which needs to replicate also both ways./DIV DIVnbsp;/DIV DIVCurrently I have setup snapshots/mviews master-slave, how I can implement this one table to be replicated also other way.../DIV DIVnbsp;/DIV DIVrgds/DIV DIVgb/DIV P HR SIZE=1 FONT face=Arial size=2Want to chat instantly with your online friends?nbsp;A href=http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.com/;BGet the FREE Yahoo! Messenger/B/A/FONT/BLOCKQUOTEFONT SIZE=3BR BR *BR This e-mail message, and any files transmitted with it, areBR confidential and intended solely for the use of the addressee. IfBR this message was not addressed to you, you have received it in errorBR and any copying, distribution or other use of any part of it isBR strictly prohibited. Any views or opinions presented are solely thoseBR of the sender and do not necessarily represent those of the BritishBR Geological Survey. The security of e-mail communication cannot beBR guaranteed and the BGS accepts no liability for claims arising as aBR result of the use of this medium to transmit messages from or to theBR BGS. .http://www.bgs.ac.ukBR *BR /FONT /BODY/HTML --_=_NextPart_001_01C39882.D1104260-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter 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
Peter, your reply was empty, could pls. send it again, maybe you have valuable information... rgds gb Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Gunnar=20Berglund?= 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 Error -ORA-23394: duplicate propagator
Hi List, I am getting ORA-23394: duplicate propagator, but when I execute DBMS_DEFER_SYS.UNREGISTER_PROPAGATOR, it says ORA-23357: the propagator does not exist. How do i resolve this issue? Anyhelp would be really greatful. Kindly see below = SQL connect system/[EMAIL PROTECTED] Connected. SQL BEGIN 2 DBMS_DEFER_SYS.REGISTER_PROPAGATOR ( 3 username = 'repadmin'); 4 END; 5 / BEGIN * ERROR at line 1: ORA-23394: duplicate propagator ORA-06512: at SYS.DBMS_SYS_ERROR, line 79 ORA-06512: at SYSTEM.DEF$_PROPAGATOR_TRIG, line 9 ORA-04088: error during execution of trigger 'SYSTEM.DEF$_PROPAGATOR_TRIG' ORA-06512: at SYS.DBMS_DEFER_INTERNAL_SYS, line 1572 ORA-06512: at SYS.DBMS_DEFER_SYS, line 2460 ORA-06512: at line 2 SQL BEGIN 2 DBMS_DEFER_SYS.UNREGISTER_PROPAGATOR ( 3 username= 'repadmin'); 4 END; 5 / BEGIN * ERROR at line 1: ORA-23357: the propagator does not exist ORA-06512: at SYS.DBMS_SYS_ERROR, line 79 ORA-06512: at SYS.DBMS_DEFER_SYS, line 2508 ORA-06512: at line 2 How do i resolve this issue? Anyhelp would be really greatful. Thanks in advance, __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA 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 from DB2 to Oracle
Forgot to add one more aspect. You may consider "extproc"; A Java/C program interface From DB2 equivalent of "extproc" of oracle. DB2 to pass values to the Java/C program which will in turn connect to Oracle and carry out DMLs. HTH GovindanK-Original Message- From: Govindan KSent: 9/25/2003 1:15:22 PMTo: [EMAIL PROTECTED];[EMAIL PROTECTED]Subject: Re: Replication from DB2 to Oracle Take a look at Oracle Gateway or the Equivalent of it in DB2. AFAIK, online replication across Databases of diff.vendors is still not avbl. though it seems you can do DMLs from Oracle to other databases (viz, SQL Server, Sybase, DB2) in 10G. Don't know about the reverse. Or you may considering any of the following: 1. Dump the DB2 data onto flat file and load using sqlldr / External Tables. 2. Generate SQL insert statements using the equivalent of triggers (capturing the DMLs in the same sequence) and run it in Oracle. In either of the above cases , how are you going to handle DDLs if any that are being done in DB2. The same need to be propogated to Oracle too and the subsequent data inserted correctly. HTH GovindanK -Original Message- From: [EMAIL PROTECTED]Sent: 9/25/2003 12:05:43 PMTo: [EMAIL PROTECTED]Subject: Re: Replication from DB2 to OracleHi, Do any of you have any recommendation about any tools / software which replicate data between DB2 and Oracle ? Are there any good products out in the market ? I would really appreciate if you could suggest something. I am looking to replicate around couple of hundred thousand rows a day. The replication can be every couple of hours. Our main concern is performance on the transactional system ( source system running db2) should not have significant performance impact. Thanks. Thanks Rishi Jain ___Get Your 10MB account for FREE at http://mail.arabia.com !Access MILLIONS of JOBS NOW! ___Get Your 10MB account for FREE at http://mail.arabia.com !Access MILLIONS of JOBS NOW!
Replication from DB2 to Oracle
Hi, Do any of you have any recommendation about any tools / software which replicate data between DB2 and Oracle ? Are there any good products out in the market ? I would really appreciate if you could suggest something. I am looking to replicate around couple of hundred thousand rows a day. The replication can be every couple of hours. Our main concern is performance on the transactional system ( source system running db2) should not have significant performance impact. Thanks. Thanks Rishi Jain -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Replication from DB2 to Oracle
Take a look at Oracle Gateway or the Equivalent of it in DB2. AFAIK, online replication across Databases of diff.vendors is still not avbl. though it seems you can do DMLs from Oracle to other databases (viz, SQL Server, Sybase, DB2) in 10G. Don't know about the reverse. Or you may considering any of the following: 1. Dump the DB2 data onto flat file and load using sqlldr / External Tables. 2. Generate SQL insert statements using the equivalent of triggers (capturing the DMLs in the same sequence) and run it in Oracle. In either of the above cases , how are you going to handle DDLs if any that are being done in DB2. The same need to be propogated to Oracle too and the subsequent data inserted correctly. HTH GovindanK -Original Message- From: [EMAIL PROTECTED]Sent: 9/25/2003 12:05:43 PMTo: [EMAIL PROTECTED]Subject: Re: Replication from DB2 to OracleHi, Do any of you have any recommendation about any tools / software which replicate data between DB2 and Oracle ? Are there any good products out in the market ? I would really appreciate if you could suggest something. I am looking to replicate around couple of hundred thousand rows a day. The replication can be every couple of hours. Our main concern is performance on the transactional system ( source system running db2) should not have significant performance impact. Thanks. Thanks Rishi Jain ___Get Your 10MB account for FREE at http://mail.arabia.com !Access MILLIONS of JOBS NOW!
Re: Replication from DB2 to Oracle
Oracle heterogenous services + ODBC. Included in EE, maybe in SE as well. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 10:09 PM Hi, Do any of you have any recommendation about any tools / software which replicate data between DB2 and Oracle ? Are there any good products out in the market ? I would really appreciate if you could suggest something. I am looking to replicate around couple of hundred thousand rows a day. The replication can be every couple of hours. Our main concern is performance on the transactional system ( source system running db2) should not have significant performance impact. Thanks. Thanks Rishi Jain -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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 in NOARCHIVELOGMODE
Sorry if my question sounds too simple. what are the pros/cons of the above? Where will deftran be stored? System tbs?. Should i increase my system tbs size. Thanks Quriyat DBA ___ No banners. No pop-ups. No kidding. Introducing My Way - http://www.myway.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: quriyat 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 in NOARCHIVELOGMODE
Replication is completely different story and independent from archive mode, thus everything will remain the same (well, unless you're doing replication with Streams, but that's a different story) Deftran is a view which is based on def$_aqcall and def$aq_error tables, these tables are in system schema, but in which tablespace they are, depends on your system users default_tablespace setting, in my test db it is tools for example. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 19, 2003 12:29 AM Sorry if my question sounds too simple. what are the pros/cons of the above? Where will deftran be stored? System tbs?. Should i increase my system tbs size. Thanks Quriyat DBA ___ No banners. No pop-ups. No kidding. Introducing My Way - http://www.myway.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: quriyat 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: Tanel Poder 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 in Oracle RDBMS
Dear Friends, Can somebody send me / direct me to startup documents for ORacle Replication. TIA, Rajuveera ** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Veeraraju_Mareddi 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 in Oracle RDBMS
For replication docs, go to: http://download-west.oracle.com/docs/cd/A91202_01/901_doc/server.901/a87499/toc.htm Fermin. -Mensaje original- De: Veeraraju_Mareddi [mailto:[EMAIL PROTECTED] Enviado el: miércoles, 10 de septiembre de 2003 13:09 Para: Multiple recipients of list ORACLE-L Asunto: Replication in Oracle RDBMS Dear Friends, Can somebody send me / direct me to startup documents for ORacle Replication. TIA, Rajuveera ** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Veeraraju_Mareddi 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: Fermin Bernaus 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).
REPLICATION: ORA-23313: object group PUBLIC.HR_REPG is not mastered at ORC1.WORLD
Hi list I am using Oracle 9.2.0.1.0 enterprise on windows. I am going thru the examples provided in Replication Management API Reference-Part No. A96568-01. While creating MVIEW REPLICATION GROUP, getting the following error (page # 5-7) SQL CONNECT mviewadmin/[EMAIL PROTECTED] Connected. SQL BEGIN 2 DBMS_REPCAT.CREATE_MVIEW_REPGROUP ( 3 gname = 'hr_repg', 4 master = 'orc1.world', 5 propagation_mode = 'ASYNCHRONOUS'); 6 END; 7 / BEGIN * ERROR at line 1: ORA-23313: object group PUBLIC.HR_REPG is not mastered at ORC1.WORLD ORA-06512: at SYS.DBMS_SYS_ERROR, line 105 ORA-06512: at SYS.DBMS_REPCAT_SNA_UTL, line 2424 ORA-06512: at SYS.DBMS_REPCAT_SNA_UTL, line 1757 ORA-06512: at SYS.DBMS_REPCAT_SNA, line 64 ORA-06512: at SYS.DBMS_REPCAT, line 1262 ORA-06512: at line 2 Any help would be really greatful. Thanks Sami __ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA 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: ORA-23313: object group PUBLIC.HR_REPG is not mastered at ORC1.WORLD
Hi list I am using Oracle 9.2.0.1.0 enterprise on windows. I am going thru the examples provided in Replication Management API Reference-Part No. A96568-01. While creating MVIEW REPLICATION GROUP, getting the following error (page # 5-7) SQL CONNECT mviewadmin/[EMAIL PROTECTED] Connected. SQL BEGIN 2 DBMS_REPCAT.CREATE_MVIEW_REPGROUP ( 3 gname = 'hr_repg', 4 master = 'orc1.world', 5 propagation_mode = 'ASYNCHRONOUS'); 6 END; 7 / BEGIN * ERROR at line 1: ORA-23313: object group PUBLIC.HR_REPG is not mastered at ORC1.WORLD ORA-06512: at SYS.DBMS_SYS_ERROR, line 105 ORA-06512: at SYS.DBMS_REPCAT_SNA_UTL, line 2424 ORA-06512: at SYS.DBMS_REPCAT_SNA_UTL, line 1757 ORA-06512: at SYS.DBMS_REPCAT_SNA, line 64 ORA-06512: at SYS.DBMS_REPCAT, line 1262 ORA-06512: at line 2 Any help would be really greatful. Thanks Sami __ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA 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: ORA-23313: object group PUBLIC.HR_REPG is not mastered at ORC1.WORLD
Before you create the Materialized View Group, you must create the REPGROUP at the Master site, which in you case is ORC1.world. In the database ORC1, use the DBMS_REPCAT.CREATE_MASTER_REPGROUP and DBMS_REPCAT.CREATE_MASTER_REPOBJECT before calling the procedure DBMS_REPCAT.CREATE_MVIEW_REPGROUP. HTH. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 01, 2003 4:24 PM mastered at ORC1.WORLD Hi list I am using Oracle 9.2.0.1.0 enterprise on windows. I am going thru the examples provided in Replication Management API Reference-Part No. A96568-01. While creating MVIEW REPLICATION GROUP, getting the following error (page # 5-7) SQL CONNECT mviewadmin/[EMAIL PROTECTED] Connected. SQL BEGIN 2 DBMS_REPCAT.CREATE_MVIEW_REPGROUP ( 3 gname = 'hr_repg', 4 master = 'orc1.world', 5 propagation_mode = 'ASYNCHRONOUS'); 6 END; 7 / BEGIN * ERROR at line 1: ORA-23313: object group PUBLIC.HR_REPG is not mastered at ORC1.WORLD ORA-06512: at SYS.DBMS_SYS_ERROR, line 105 ORA-06512: at SYS.DBMS_REPCAT_SNA_UTL, line 2424 ORA-06512: at SYS.DBMS_REPCAT_SNA_UTL, line 1757 ORA-06512: at SYS.DBMS_REPCAT_SNA, line 64 ORA-06512: at SYS.DBMS_REPCAT, line 1262 ORA-06512: at line 2 Any help would be really greatful. Thanks Sami __ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA 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: REPLICATION: ORA-23313: object group PUBLIC.HR_REPG is not mastered at ORC1.WORLD
Dear Arup, Thanks for your response. But i have done the same which is mentioned in page # 3-6(Replication API Reference Manual). Please see below. What else could be wrong? TIA CONNECT repadmin/[EMAIL PROTECTED] BEGIN DBMS_REPCAT.CREATE_MASTER_REPGROUP ( gname = 'hr_repg'); END; / BEGIN DBMS_REPCAT.CREATE_MASTER_REPOBJECT ( gname = 'hr_repg', type = 'TABLE', oname = 'departments', sname = 'hr', use_existing_object = TRUE, copy_rows = FALSE); END; / --- Arup Nanda [EMAIL PROTECTED] wrote: Before you create the Materialized View Group, you must create the REPGROUP at the Master site, which in you case is ORC1.world. In the database ORC1, use the DBMS_REPCAT.CREATE_MASTER_REPGROUP and DBMS_REPCAT.CREATE_MASTER_REPOBJECT before calling the procedure DBMS_REPCAT.CREATE_MVIEW_REPGROUP. HTH. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 01, 2003 4:24 PM mastered at ORC1.WORLD Hi list I am using Oracle 9.2.0.1.0 enterprise on windows. I am going thru the examples provided in Replication Management API Reference-Part No. A96568-01. While creating MVIEW REPLICATION GROUP, getting the following error (page # 5-7) SQL CONNECT mviewadmin/[EMAIL PROTECTED] Connected. SQL BEGIN 2 DBMS_REPCAT.CREATE_MVIEW_REPGROUP ( 3 gname = 'hr_repg', 4 master = 'orc1.world', 5 propagation_mode = 'ASYNCHRONOUS'); 6 END; 7 / BEGIN * ERROR at line 1: ORA-23313: object group PUBLIC.HR_REPG is not mastered at ORC1.WORLD ORA-06512: at SYS.DBMS_SYS_ERROR, line 105 ORA-06512: at SYS.DBMS_REPCAT_SNA_UTL, line 2424 ORA-06512: at SYS.DBMS_REPCAT_SNA_UTL, line 1757 ORA-06512: at SYS.DBMS_REPCAT_SNA, line 64 ORA-06512: at SYS.DBMS_REPCAT, line 1262 ORA-06512: at line 2 Any help would be really greatful. Thanks Sami __ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA 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). __ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA 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: ORA-23313: object group PUBLIC.HR_REPG is not mastered at ORC1.WORLD
Sami, Setting up replication is pretty straight forward as long as you follow all the steps dilligently. Unfortunately if a step is missed, it's hard to diagnose the problem until one is at the terminal looking at the actual database. In this case there are several steps that my not have been correctly executed. Here are some: (1) Have you built the replication support for the master group? begin dbms_repcat.generate_replication_support( sname='HR', oname='DEPATMENTS', type='TABLE', min_communication=TRUE); end; (2) Have you started replication activity? begin dbms_repcat.resume_master_activity( gname='HR_REPG'); end; (3) Have you created the snaphsot group at the MV Site using dbms_refresh.make? You should do this steps before you create the MV RepGroup. You may find an article I wrote for DBAZine (http://www.dbazine.com/nanda2.html), a related but separate issue. And please let us know your progress. HTH. Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 01, 2003 5:09 PM mastered at ORC1.WORLD Dear Arup, Thanks for your response. But i have done the same which is mentioned in page # 3-6(Replication API Reference Manual). Please see below. What else could be wrong? TIA CONNECT repadmin/[EMAIL PROTECTED] BEGIN DBMS_REPCAT.CREATE_MASTER_REPGROUP ( gname = 'hr_repg'); END; / BEGIN DBMS_REPCAT.CREATE_MASTER_REPOBJECT ( gname = 'hr_repg', type = 'TABLE', oname = 'departments', sname = 'hr', use_existing_object = TRUE, copy_rows = FALSE); END; / --- Arup Nanda [EMAIL PROTECTED] wrote: Before you create the Materialized View Group, you must create the REPGROUP at the Master site, which in you case is ORC1.world. In the database ORC1, use the DBMS_REPCAT.CREATE_MASTER_REPGROUP and DBMS_REPCAT.CREATE_MASTER_REPOBJECT before calling the procedure DBMS_REPCAT.CREATE_MVIEW_REPGROUP. HTH. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 01, 2003 4:24 PM mastered at ORC1.WORLD Hi list I am using Oracle 9.2.0.1.0 enterprise on windows. I am going thru the examples provided in Replication Management API Reference-Part No. A96568-01. While creating MVIEW REPLICATION GROUP, getting the following error (page # 5-7) SQL CONNECT mviewadmin/[EMAIL PROTECTED] Connected. SQL BEGIN 2 DBMS_REPCAT.CREATE_MVIEW_REPGROUP ( 3 gname = 'hr_repg', 4 master = 'orc1.world', 5 propagation_mode = 'ASYNCHRONOUS'); 6 END; 7 / BEGIN * ERROR at line 1: ORA-23313: object group PUBLIC.HR_REPG is not mastered at ORC1.WORLD ORA-06512: at SYS.DBMS_SYS_ERROR, line 105 ORA-06512: at SYS.DBMS_REPCAT_SNA_UTL, line 2424 ORA-06512: at SYS.DBMS_REPCAT_SNA_UTL, line 1757 ORA-06512: at SYS.DBMS_REPCAT_SNA, line 64 ORA-06512: at SYS.DBMS_REPCAT, line 1262 ORA-06512: at line 2 Any help would be really greatful. Thanks Sami __ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA 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). __ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858
Replication options Was: SharePlex info
Hi there In the past few weeks, there have been lots of discussion about HA, data replication and using Shareplex, dataguard, Streams, logical physical standby. As most of you have found out each has it own pros and cons. You also need two sets of Database licences and Shareplex licences. Then there are real technical issues like DDLs, db patches/upgrades, external files like INIT.ORA etc etc. I would like to suggest that you also consider using filesystem replication. At one site I have the following Prod }--- Sync replication - Standby }--- Async replication - DR I also use checkpoints/snapshots on the Prod box which gets replicated to the target boxes as well. This allows me to start the standby/DR box to any point in time that had the checkpoint/snapshot. Why did I recommend this to the client? because it does not need a highly paid DBA to do any of the work required. Now depending on your situation and country, you do not need to purchase oracle for the Standby and DR site. The cost savings can go towards the cost of using this filesystem replication option. Which ones? Try NetApps and Veritas Volume replicator. my 2cents worth ta tony At 09:49 AM 21/08/2003 -0800, you wrote: Hi All, I'm trying to find some technical details about SharePlex, that is: - How much network bandwidth I'd expect to replicate from database, generating 1-5 MB/sec redo. Does SharePlex send SQL text over the network or data in some internal (hopefully compressed) format - How much CPU on the source DB server side would it cost - just a ball park - very little- little - or a lot - Of two options, using 9.2 physical async standby db and clone whole database vs replicate 50% (enough from business requirements) of tables using SharePlex, which one sounds preferrable keeping in mind minimizing CPU burden on the source database. Any opinion or pointer to any benchmark is highly appreciated. Thanks a lot Vadim
Replication book
With the talk about replication lately, I thought I would see what might be out there in book land and came across this. It is currently a vapor book. http://www.dba-oracle.com/bp/bp_book4_replication.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee 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: advanced replication knowledge resources
Hello Robert We are working with advance replication in 8.1.6.3.4. You need the following in the instances: global_names = true unique global name in each database job_queue_processes = 10 ( at least) archive enabled I will send you offline the script that I use to create replication. It does all the job from start to end. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 12:20 AM We'll need to set up multi-master replication between two 8.1.7 databases within the next few months. We're not experienced with replication beyond relatively simple snapshots and snapshot groups. Can anyone suggest good training, web, and/or printed resources we can use to get up to speed? I see Oracle offers 2 distributed systems courses and the book Oracle Distributed Systems by Charles Dye is available. Any experience with these references? Thanks for you help. Bob Stauffer DE Communications Ephrata, PA USA [EMAIL PROTECTED] **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Stauffer 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: Yechiel Adar 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: advanced replication knowledge resources
One good book to have is Oracle Built-in Packages from O'Reilly. It does more than merely show the syntax for the packages, but shows how the packages are used. There is a chapter on Advanced Replication. I have found this book to be one of the more useful books that I have bought. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee 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: advanced replication knowledge resources
Robert - I have studied this issue quite a bit and my opinion (based on reading, not experience) is that the success in replication is in the organization, not the technology. The question is whether your organization and application are ready for replication. It sounds like you have some experience, so I will just recommend Marie Buretta's book Data Replication. I have a checklist based on this book if you want to email me privately. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, March 04, 2003 4:20 PM To: Multiple recipients of list ORACLE-L We'll need to set up multi-master replication between two 8.1.7 databases within the next few months. We're not experienced with replication beyond relatively simple snapshots and snapshot groups. Can anyone suggest good training, web, and/or printed resources we can use to get up to speed? I see Oracle offers 2 distributed systems courses and the book Oracle Distributed Systems by Charles Dye is available. Any experience with these references? Thanks for you help. Bob Stauffer DE Communications Ephrata, PA USA [EMAIL PROTECTED] **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Stauffer 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: DENNIS WILLIAMS 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).
advanced replication knowledge resources
We'll need to set up multi-master replication between two 8.1.7 databases within the next few months. We're not experienced with replication beyond relatively simple snapshots and snapshot groups. Can anyone suggest good training, web, and/or printed resources we can use to get up to speed? I see Oracle offers 2 distributed systems courses and the book Oracle Distributed Systems by Charles Dye is available. Any experience with these references? Thanks for you help. Bob Stauffer DE Communications Ephrata, PA USA [EMAIL PROTECTED] **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Stauffer 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
Title: Message I was asked of a problem in a friend's site about replication. The problem. They implemented replication using Materialized Views with an refresh update of ON DEMAND and some immediate. It works for some days and suddenly some MV stop replicating. He has checked metalink, but can't open a TAR. Is there any recommendation that you can give him to check. Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121
Re: Replication
Title: Message
Is the MV set up for FAST REFRESH or
COMPLETE?
If FAST REFRESH, check to see if the tablespace of
MV Log table, named MLOG$_tablename where tablename is the first
20 characters of the table on which the log is based, has enough space for the
mlog$ to grow.
If complete refresh, do it manually from command
line
exec
DBMS_SNAPSHOT.REFRESH('tablename,'CF')
and see what error message is given. A few things
come to my mind
(1) not enough temp space for the sorting to occur
for he MV
(2) not enough rollback segment space.
Either way, you will see the exact error it fails
on.
HTH.
Arup Nanda
- Original Message -
From:
Ramon E. Estevez
To: Multiple recipients of list ORACLE-L
Sent: Friday, February 21, 2003 8:19
AM
Subject: Replication
I was asked of a
problem in a friend's site about replication.
The
problem.
They implemented
replication using Materialized Views with an refresh update of ON DEMAND and
some immediate. It works for some days and suddenly some MV stop
replicating.
He has checked
metalink, but can't open a TAR.
Is there any
recommendation that you can give him to check.
Ramon E.
Estevez
[EMAIL PROTECTED]
809-565-3121
RE: Replication
Title: Message
Thks
Arup, I'll let him know those points.
Tks
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Arup NandaSent:
Friday, February 21, 2003 10:30 AMTo: Multiple recipients of list
ORACLE-LSubject: Re: Replication
Is the MV set up for FAST REFRESH or
COMPLETE?
If FAST REFRESH, check to see if the tablespace
of MV Log table, named MLOG$_tablename where tablename is the
first 20 characters of the table on which the log is based, has enough space
for the mlog$ to grow.
If complete refresh, do it manually from command
line
exec
DBMS_SNAPSHOT.REFRESH('tablename,'CF')
and see what error message is given. A few things
come to my mind
(1) not enough temp space for the sorting to
occur for he MV
(2) not enough rollback segment
space.
Either way, you will see the exact error it fails
on.
HTH.
Arup Nanda
- Original Message -
From:
Ramon E. Estevez
To: Multiple recipients of list ORACLE-L
Sent: Friday, February 21, 2003 8:19
AM
Subject: Replication
I was asked of
a problem in a friend's site about replication.
The
problem.
They
implemented replication using Materialized Views with an refresh update of
ON DEMAND and some immediate. It works for some days and suddenly some
MV stop replicating.
He has checked
metalink, but can't open a TAR.
Is there any
recommendation that you can give him to check.
Ramon E.
Estevez
[EMAIL PROTECTED]
809-565-3121
Re: Replication..
Yep - advanced replication is updateable snapshots and master-to-master replication, whereas basic replication is read-only snapshots (known these days as materialized views). And here's the reply from Dominic Delmolino regarding versions: Hey Mogens! I'll be seeing you at the conference -- bring me an ice-cold bottle of Denmark's finest akvavit. No, wait, that was the wrong one. Sorry. Here's the one I was thinking about... Advanced replication was introduced in 7.1.6 Best regards, Mogens Richard Ji wrote: My understanding is that Basic replication is "readonly snapshot". Anything above that, including updatable snapshot is advanced replication. Richard -Original Message- Sent: Wednesday, January 29, 2003 4:24 PM To: Multiple recipients of list ORACLE-L Paul - That is not my understanding. If you look in the Oracle guide that shows the differences between Standard Edition and Enterprise Edition, Standard has something named "Basic Replication", and Enterprise has "Advanced Replication". Advanced means multimaster replication. Basic means snapshots. In between there are several other replication alternatives, like updatable snapshots, but I haven't seen a clear explanation of where basic stops and advanced starts. If anyone knows, I would appreciate their posting the facts. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 29, 2003 2:59 PM To: Multiple recipients of list ORACLE-L I believe that "Advanced Replication" was just a name change, introduced in either Oracle8 or Oracle8i. PB --- Mogens_Nrgaard [EMAIL PROTECTED] wrote: The person I know who can answer this is the guy who was Mr Replication in Cary's SPG-group from the beginning, namely Dominic Delmolino. He was truly a pioneer with that stuff. I'll ask him and get back. Mogens DENNIS WILLIAMS wrote: Chaim - I agree with your note, but isn't that basic replication? Robert asked about advanced (multimaster) replication. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, January 27, 2003 2:12 PM To: Multiple recipients of list ORACLE-L from metalink note: 28018.1 5.14 Symmetric Replication --- The Oracle symmetric replication facility is new with release 7.1.6. The symmetric replication facility allows multiple copies of data to be maintained at different sites in a distributed environment. It provides immediate, local access to data and allows systems to function autonomously even when other systems in the distributed environment are unavailable, or networks fail. To use the symmetric replication facility, you must have purchased and installed the replication option. The symmetric replication facility is documented in the "Oracle7 Server Distributed Systems: Replicated Data" manual. Freeman Robert - IL [EMAIL PROTECTED]@fatcity.com on 01/27/2003 02:29:24 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Any of you Oracle history buffs remember what version of Oracle that advanced replication was first available in? RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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 HE
Re: Replication..
The person I know who can answer this is the guy who was Mr Replication in Cary's SPG-group from the beginning, namely Dominic Delmolino. He was truly a pioneer with that stuff. I'll ask him and get back. Mogens DENNIS WILLIAMS wrote: Chaim - I agree with your note, but isn't that basic replication? Robert asked about advanced (multimaster) replication. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, January 27, 2003 2:12 PM To: Multiple recipients of list ORACLE-L from metalink note: 28018.1 5.14 Symmetric Replication --- The Oracle symmetric replication facility is new with release 7.1.6. The symmetric replication facility allows multiple copies of data to be maintained at different sites in a distributed environment. It provides immediate, local access to data and allows systems to function autonomously even when other systems in the distributed environment are unavailable, or networks fail. To use the symmetric replication facility, you must have purchased and installed the replication option. The symmetric replication facility is documented in the Oracle7 Server Distributed Systems: Replicated Data manual. Freeman Robert - IL [EMAIL PROTECTED]@fatcity.com on 01/27/2003 02:29:24 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Any of you Oracle history buffs remember what version of Oracle that advanced replication was first available in? RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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..
I believe that Advanced Replication was just a name change, introduced in either Oracle8 or Oracle8i. PB --- Mogens_Nørgaard [EMAIL PROTECTED] wrote: The person I know who can answer this is the guy who was Mr Replication in Cary's SPG-group from the beginning, namely Dominic Delmolino. He was truly a pioneer with that stuff. I'll ask him and get back. Mogens DENNIS WILLIAMS wrote: Chaim - I agree with your note, but isn't that basic replication? Robert asked about advanced (multimaster) replication. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, January 27, 2003 2:12 PM To: Multiple recipients of list ORACLE-L from metalink note: 28018.1 5.14 Symmetric Replication --- The Oracle symmetric replication facility is new with release 7.1.6. The symmetric replication facility allows multiple copies of data to be maintained at different sites in a distributed environment. It provides immediate, local access to data and allows systems to function autonomously even when other systems in the distributed environment are unavailable, or networks fail. To use the symmetric replication facility, you must have purchased and installed the replication option. The symmetric replication facility is documented in the Oracle7 Server Distributed Systems: Replicated Data manual. Freeman Robert - IL [EMAIL PROTECTED]@fatcity.com on 01/27/2003 02:29:24 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Any of you Oracle history buffs remember what version of Oracle that advanced replication was first available in? RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Replication..
Paul - That is not my understanding. If you look in the Oracle guide that shows the differences between Standard Edition and Enterprise Edition, Standard has something named Basic Replication, and Enterprise has Advanced Replication. Advanced means multimaster replication. Basic means snapshots. In between there are several other replication alternatives, like updatable snapshots, but I haven't seen a clear explanation of where basic stops and advanced starts. If anyone knows, I would appreciate their posting the facts. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 29, 2003 2:59 PM To: Multiple recipients of list ORACLE-L I believe that Advanced Replication was just a name change, introduced in either Oracle8 or Oracle8i. PB --- Mogens_Nørgaard [EMAIL PROTECTED] wrote: The person I know who can answer this is the guy who was Mr Replication in Cary's SPG-group from the beginning, namely Dominic Delmolino. He was truly a pioneer with that stuff. I'll ask him and get back. Mogens DENNIS WILLIAMS wrote: Chaim - I agree with your note, but isn't that basic replication? Robert asked about advanced (multimaster) replication. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, January 27, 2003 2:12 PM To: Multiple recipients of list ORACLE-L from metalink note: 28018.1 5.14 Symmetric Replication --- The Oracle symmetric replication facility is new with release 7.1.6. The symmetric replication facility allows multiple copies of data to be maintained at different sites in a distributed environment. It provides immediate, local access to data and allows systems to function autonomously even when other systems in the distributed environment are unavailable, or networks fail. To use the symmetric replication facility, you must have purchased and installed the replication option. The symmetric replication facility is documented in the Oracle7 Server Distributed Systems: Replicated Data manual. Freeman Robert - IL [EMAIL PROTECTED]@fatcity.com on 01/27/2003 02:29:24 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Any of you Oracle history buffs remember what version of Oracle that advanced replication was first available in? RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see
RE: Replication..
My understanding is that Basic replication is readonly snapshot. Anything above that, including updatable snapshot is advanced replication. Richard -Original Message- Sent: Wednesday, January 29, 2003 4:24 PM To: Multiple recipients of list ORACLE-L Paul - That is not my understanding. If you look in the Oracle guide that shows the differences between Standard Edition and Enterprise Edition, Standard has something named Basic Replication, and Enterprise has Advanced Replication. Advanced means multimaster replication. Basic means snapshots. In between there are several other replication alternatives, like updatable snapshots, but I haven't seen a clear explanation of where basic stops and advanced starts. If anyone knows, I would appreciate their posting the facts. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 29, 2003 2:59 PM To: Multiple recipients of list ORACLE-L I believe that Advanced Replication was just a name change, introduced in either Oracle8 or Oracle8i. PB --- Mogens_Nørgaard [EMAIL PROTECTED] wrote: The person I know who can answer this is the guy who was Mr Replication in Cary's SPG-group from the beginning, namely Dominic Delmolino. He was truly a pioneer with that stuff. I'll ask him and get back. Mogens DENNIS WILLIAMS wrote: Chaim - I agree with your note, but isn't that basic replication? Robert asked about advanced (multimaster) replication. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, January 27, 2003 2:12 PM To: Multiple recipients of list ORACLE-L from metalink note: 28018.1 5.14 Symmetric Replication --- The Oracle symmetric replication facility is new with release 7.1.6. The symmetric replication facility allows multiple copies of data to be maintained at different sites in a distributed environment. It provides immediate, local access to data and allows systems to function autonomously even when other systems in the distributed environment are unavailable, or networks fail. To use the symmetric replication facility, you must have purchased and installed the replication option. The symmetric replication facility is documented in the Oracle7 Server Distributed Systems: Replicated Data manual. Freeman Robert - IL [EMAIL PROTECTED]@fatcity.com on 01/27/2003 02:29:24 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Any of you Oracle history buffs remember what version of Oracle that advanced replication was first available in? RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL
Replication..
Any of you Oracle history buffs remember what version of Oracle that advanced replication was first available in? RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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..
from metalink note: 28018.1 5.14 Symmetric Replication --- The Oracle symmetric replication facility is new with release 7.1.6. The symmetric replication facility allows multiple copies of data to be maintained at different sites in a distributed environment. It provides immediate, local access to data and allows systems to function autonomously even when other systems in the distributed environment are unavailable, or networks fail. To use the symmetric replication facility, you must have purchased and installed the replication option. The symmetric replication facility is documented in the Oracle7 Server Distributed Systems: Replicated Data manual. Freeman Robert - IL [EMAIL PROTECTED]@fatcity.com on 01/27/2003 02:29:24 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Any of you Oracle history buffs remember what version of Oracle that advanced replication was first available in? RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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: 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..
Thanks! Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com! -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, January 27, 2003 2:12 PM To: Multiple recipients of list ORACLE-L from metalink note: 28018.1 5.14 Symmetric Replication --- The Oracle symmetric replication facility is new with release 7.1.6. The symmetric replication facility allows multiple copies of data to be maintained at different sites in a distributed environment. It provides immediate, local access to data and allows systems to function autonomously even when other systems in the distributed environment are unavailable, or networks fail. To use the symmetric replication facility, you must have purchased and installed the replication option. The symmetric replication facility is documented in the Oracle7 Server Distributed Systems: Replicated Data manual. Freeman Robert - IL [EMAIL PROTECTED]@fatcity.com on 01/27/2003 02:29:24 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Any of you Oracle history buffs remember what version of Oracle that advanced replication was first available in? RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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: 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: Freeman Robert - IL 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..
Chaim - I agree with your note, but isn't that basic replication? Robert asked about advanced (multimaster) replication. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, January 27, 2003 2:12 PM To: Multiple recipients of list ORACLE-L from metalink note: 28018.1 5.14 Symmetric Replication --- The Oracle symmetric replication facility is new with release 7.1.6. The symmetric replication facility allows multiple copies of data to be maintained at different sites in a distributed environment. It provides immediate, local access to data and allows systems to function autonomously even when other systems in the distributed environment are unavailable, or networks fail. To use the symmetric replication facility, you must have purchased and installed the replication option. The symmetric replication facility is documented in the Oracle7 Server Distributed Systems: Replicated Data manual. Freeman Robert - IL [EMAIL PROTECTED]@fatcity.com on 01/27/2003 02:29:24 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Any of you Oracle history buffs remember what version of Oracle that advanced replication was first available in? RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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: 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: DENNIS WILLIAMS 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] Altering Master Object at materialized view replication environment
Hello! That's one of the nuances of MV replication. If you alter the master table, you have to drop and recreate the MV on the snapshot site. This is as per Oracle's internal documentation. :-( However, there is a trick. If you have created the MV using a prebuilt table, then you can have a workaround. [ ... ] Of course, there are several small but crucial steps to be followed. I have described the procedure completely in http://www.dbazine.com/nanda2.html . Hope this helps. Thank you, it works. But it's reasonable only if a table size is huge ... or channel capacity is small :-), so complete refresh becoms very expensive operation ... /sds PS: About http://www.dbazine.com/nanda2.html , imho, something wrong in this sentence: The table has two columns, COL1 NUMBER (9) and COL2 CHAR(1000), COL3 CHAR(900) ... 8-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dennis Sorokin 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] Altering Master Object at materialized view replication environment
Dennis, I am glad that it worked for you. Of course, it's useful if the table size is big. In case of a small table, you would just drop and recreate the snapshot. Thanks for pointing out the typo. Regards, Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, January 20, 2003 9:44 AM replication environment Hello! That's one of the nuances of MV replication. If you alter the master table, you have to drop and recreate the MV on the snapshot site. This is as per Oracle's internal documentation. :-( However, there is a trick. If you have created the MV using a prebuilt table, then you can have a workaround. [ ... ] Of course, there are several small but crucial steps to be followed. I have described the procedure completely in http://www.dbazine.com/nanda2.html . Hope this helps. Thank you, it works. But it's reasonable only if a table size is huge ... or channel capacity is small :-), so complete refresh becoms very expensive operation ... /sds PS: About http://www.dbazine.com/nanda2.html , imho, something wrong in this sentence: The table has two columns, COL1 NUMBER (9) and COL2 CHAR(1000), COL3 CHAR(900) ... 8-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dennis Sorokin 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: RE: Parallel Replication of Single Table
Larry, As far as I am concerned my present problems are linked to an unpleasant tendency of MTS to freeze, and, while looking at $ORACLE_HOME/rdbms/mesg/oraus.msg for a possibly suitable event to set to get some information, I bumped into 10975 which may possibly be useful in your case. BTW if somebody has an idea why MTS should freeze around 50/55 sessions on a 8.1.7 (Solaris 2.8), I am interested. My stress program has no problem going up to 250 sessions with dedicated servers. No error, no trace, it just freezes. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroul 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).
AW: Replication
Hi David It sounds like Advanced Replication to me. The question is: Will the data you move from instance A to instance B also be changed on instance B ? Is it necessary to propagate changes back to instance A ? - Master-Master Replication. Will the data on instance B remain unchanged and only be queried ? - Plain vanilla snapshots might be enough. Could you be more precise regarding the requirements here ? But anyway, you can take a look at Oracle's replication guide, it explains all the available options pretty well. Regards, Stefan -Ursprüngliche Nachricht- Von: Ehresmann, David [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 16. Januar 2003 16:09 An: Multiple recipients of list ORACLE-L Betreff: List, I have to move data on a regular basis between two instances of 8.1.7 on two different UNIX servers. The schema is exactly the same. There are 543 tables to be refreshed. It is only the new data on one of the servers to move to the other. What is the best and easiest way to do this? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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: Stefan Jahnke 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] Altering Master Object at materialized view replication environment
Dennis, That's one of the nuances of MV replication. If you alter the master table, you have to drop and recreate the MV on the snapshot site. This is as per Oracle's internal documentation. However, there is a trick. If you have created the MV using a prebuilt table, then you can have a workaround. When you build an MV on a table, Oracle simply assumes the type of the segment as MV rather than the table, i.e. the segment that used to be known as the table is now known as the MV. when the MV is dropped, Oracle does not drop the segment; rather it reverts the type to the table as it used to be. So when you alter the master table, follow the sequence of steps. stop replication drop the MV alter the master table alter the prebuilt table in the same way. Build the MV on the prebuilt table again. Of course, there are several small but crucial steps to be followed. I have described the procedure completely in http://www.dbazine.com/nanda2.html . Hope this helps. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 14, 2003 3:53 AM replication environment Hello How can i replicate DDL on table (modify column for example) in materialized view replication environment ? DBMS_REPCAT.ALTER_MASTER_REPOBJECT alter the object, put changes are not propagated to MV site ... I try DBMS_REFRESH.REFRESH and DBMS_REPCAT.REFRESH_MVIEW_REPGROUP at MV site, but I steel don't see the changes. Is it possible to propagate DDL to MV site ? Thnx. /sds -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dennis Sorokin 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: Parallel Replication of Single Table
Larry, Thanks for taking the time to explain this. You are really patient when it comes to writing! I see now how Oracle does the refresh. I also remember now seeing a post in this list some time ago asking about the possibility of tuning a similar sql. I think it was you :) The way Oracle is pushing the changes make sense since they care nothing about the transactions themselves and only care about the final image of the data ( I thought they'd care about the transactions). As I see in the sql you sent, all the sql are using bind variables. This indicates that changes are done row by row in a procedural method instead of a single sql (update, insert) that handles all the changes in one shot. When we talk about parallelizing it, then there are two choices: The first one is using parallelism in the sql engine itself and firing one sql statement that handles either all the updates or the entire deletes to the target table. Parallel updates is not available in releases below 9.2. Also using this method does not give a chance to handle any other processing (if there is) that is related to the refresh process/rows refreshed during the refresh. The second choice is to continue doing it in a procedural way but spawning many Oracle processes, and let the master process read the rows from the sql and dequeue/distribute them to the parallel job processes. The parallel jobs processes will do their jobs the same way (procedural) the single process does. So I think the first choice (if it's available) will not be available in any Oracle releases before 9.2. The second method if it's available will be available for a big packaged Oracle option like replication. I asked a friend who handles replication and here is the thread: -Original Message- Sent: Wednesday, January 15, 2003 10:57 AM To: Khedr, Waleed Subject:RE: Question for you True - this meaning of parallel propagation refers to the act of pushing repgroups concurrently to multiple destinations. There is no way that I'm aware of to make the queues be read by multiple background processes, thereby pushed in parallel. Replication was never intended for large DSS systems and it certainly has it's limitations. ETL-type solutions may be a better road to take for DSS or otherwise extremely large databases. -Original Message- Sent: Wednesday, January 15, 2003 10:46 AM To: my friend Subject:RE: Question for you If the parallel push is assoc with a rep group then it may be there to handle different tables concurrently and it's not guaranteed that if a rep group has only one table that it will be done in parallel. Am I right? any thoughts? Regards, Waleed -Original Message- Sent: Tuesday, January 14, 2003 8:25 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Waleed, Thanks for chiming in. Regarding refreshing multiple tables in parallel, well yes, that could be done on a group level. Instead, though, they choose to have the scheduling tool kick off multiple single table refreshes. They start many at the same time, so they do in essence get parallelism of multiple tables at one time. And this way they get paged with a specific should something fail. Regarding the other comments, the replication logic seems to handle the dependency you are talking about. There really isn't any order per se, so the same issues you raise would apply to serial processing as well, right? All those rows are in the MLOG$ table with a 1/1/4000 date -- in what order did they occur? Obviously an insert has to occur before the update to occur (with xceptions -- e.g. update, delete, then insert same PK row, etc). And we don't care how many updates have occurred since we are only interested in pushing the current image of the row. Now, what about deletes? Let's say you see deletes and inserts in the MLOG$ table. Well, they will all have the 1/1/4000 date prior to kicking off. How do we know which occurred first -- did we delete an existing row and then re-insert? Or did we insert and then delete? Well, that's handled by joining to the core table itself -- if the row exists, then you are going to push it, the insert would have happened after the delete. If it doesn't exist, then you know the delete happened after the insert. So the deletes are processed first using the existence in the base table test. With tracing turned on you can see how the replication logic handles this: Step 1 -- get the != 'I' where it's not in the existing table -- e.g. we know the last action was a delete, not an insert or update since the row no longer exists: SELECT /*+ remote_mapped(link) */ DISTINCT LOG$.OBJECT_ID FROM (SELECT MLOG$.OBJECT_ID FROM SCHEMA.MLOG$_MY_PTEST@link MLOG$ WHERE SNAPTIME$$ :1 AND (DMLTYPE$$ != 'I')) LOG$ WHERE (LOG$.OBJECT_ID) NOT IN (SELECT MAS_TAB$.OBJECT_ID FROM SCHEMA.MY_PTEST@LINK MAS_TAB$ WHERE LOG$.OBJECT_ID = MAS_TAB$.OBJECT_ID) Step 2 -- process those deletes: DELETE FROM SCHEMA.MV_MY_PTEST
RE: Parallel Replication of Single Table
Larry, Thanks for taking the time to explain this. You are really patient when it comes to writing! I see now how Oracle does the refresh. I also remember now seeing a post in this list some time ago asking about the possibility of tuning a similar sql. I think it was you :) It was me. I was asking about reverse key indexes and if anyone had seen issues. The Oracle replication query to resolve what to process was running for a few hours, just the query -- I would pull it out and run it, very bad. But the execution plan was good, what we would want. The PK was a reverse key index based on a sequence. So I understand why the folks were tempted, based on lots of what is written out there, to use a reverse key index. Changed to a normal b-tree, and testing the query, it finished very quickly. Changed back to reverse, the query to resolve what to process ran for ages. And then back to b-tree, good performance again. So I asked the list if anyone had seen similar things with reverse key indexes. You think other people would have seen similar things if it was a problem with the reverse key index. Anyway, we ditched the custom code that had a couple of issues -- instead of fixing that code went with a normal b-tree index, ditching the reverse key index, and went with Oracle's standard replication. It has worked fine, until recent changes in a feed that is causing a *lot* of updates. Now it's not so good (but the query still resolves quickly ;-)) Still don't know that we can attribute the query performance issue strictly to a reverse key thing. As I see in the sql you sent, all the sql are using bind variables. This indicates that changes are done row by row in a procedural method instead of a single sql (update, insert) that handles all the changes in one shot. Yep. But it would still be possible, I think, to parellelize that even though it is done a row at a time. Divide and conquer and retain precedence. I've done that in the past with custom code for pushing changes. When we talk about parallelizing it, then there are two choices: The first one is using parallelism in the sql engine itself and firing one sql statement that handles either all the updates or the entire deletes to the target table. And this is where maybe the idea of remote transactions comes in and the comments I referred to in the prior email. Could very well be missing something here about why they serialize when going remotely. But it's still interesting the parallelism you can get with a insert, for example, depending on which side you initiate it, something you touched on in an earlier email. And the following comment from the 8.1.7 Data Warehousing Guide is interesting and why we (I really, pressing on others) have been pursuing this: If the user has done a lot of updates to the table, ... In the warehouse, after a bulk load, the user should enable parallel DML in the session and perform the refresh. Oracle will use parallel DML to do the refresh, which will enhance performance tremendously. There is more to gain if the materialized view is partitioned. Note that the references are to a table, and updates (understanding the limitations of parallel updates in 8.1.7 and across partitions, not within) not a group of tables. But the one thing they don't say in that statement is if the MV is local, or if it is remote. So you find the following comment in the Distributed Concepts Manual: If the table referenced in the table_expression_clause of an INSERT, UPDATE, or DELETE statement is remote, then execution is serial rather than parallel. So that tends to make you think the parallelism is not going to happen when refreshing a remote object. But heck, I can't even get a test case using an MV and parallelism with a local object. So that's why I think I'm totally missing something. And the thousands of pages of Oracle doc's is a lot to go through to get the answer, though I'm trying ;-) Parallel updates is not available in releases below 9.2. They are across different partitions, just not in the same partition, or so we read, and I think I tested some time back. And I did a test case in 9.2, not believing just the plan but actually observing, and saw the parallelism within a single partition. The second choice is to continue doing it in a procedural way but spawning many Oracle processes, and let the master process read the rows from the sql and dequeue/distribute them to the parallel job processes. The parallel jobs processes will do their jobs the same way (procedural) the single process does. And that's what we had, though a couple of issues. And once the query resolution performance was resolved, we went with standard replication. But now it looks like we will dig out the old code that performs in the manner you describe, fix the couple of issues with it, and run with that. We are still testing capabilities -- hate to go with a custom solution if standard features can do the job. But we have been
[Replication] Altering Master Object at materialized view replication environment
Hello How can i replicate DDL on table (modify column for example) in materialized view replication environment ? DBMS_REPCAT.ALTER_MASTER_REPOBJECT alter the object, put changes are not propagated to MV site ... I try DBMS_REFRESH.REFRESH and DBMS_REPCAT.REFRESH_MVIEW_REPGROUP at MV site, but I steel don't see the changes. Is it possible to propagate DDL to MV site ? Thnx. /sds -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dennis Sorokin 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: Parallel Replication of Single Table
Hi Larry, In the distributed manual it makes a comment about DML serializing when doing remote operations. I am not sure about replication but in the past (on 8.1.5 and 8.1.6 versions) this has been my experience with CTAS over a dblink or DML over dblink in that it serializes. In order to achieve parallelism, the only workaround we had was (though not pretty :-) ) to use the ROWID hint on the CTAS and build a set of partition tables at the target and then merge them into a single table. Regards, Madhavan http://www.dpapps.com -- Madhavan Amruthur DecisionPoint Applications -- http://fastmail.fm - Accessible with your email software or over the web -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Madhavan Amruthur 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: Parallel Replication of Single Table
Hi Larry, I do not know really how you want to parallelize this kind of operations! The final goal is to push the changes in site 1 to site 2 and get the data in both tables in sync. Changes include inserts, updates, and deletes. These changes (dml operations) could be cascaded on the same row which means that the final image of the data in the table is completely dependent on the order and sequence of these dml operations. This is why I think that a single table refresh requires it to be a serial operation. But on the other hand if a single refresh was requested for many tables, then this could be parallelized on the job level not the table level. Does it make sense or am I missing something? Regards, Waleed -Original Message- Sent: Monday, January 13, 2003 7:51 PM To: Multiple recipients of list ORACLE-L Listers, How can one use parallelism when fast refreshing a *single* table? Pulling my hair out on this one. We want to use parallelism when replicating updates/inserts from a single partitioned table between DB's -- partitioned on both DB's. Both are 8.1.7.4 Solaris 8 64 bit. Using fast refresh and primary key method. Have the MV in the target, have the source along with the associated MLOG$. The job queues, parallel parameters, etc are all way up there. We manually pull on occasion when doing restructuring or mass mods and have no problems getting parallelism on each side. But we have to initiate from the target side as a pull to get that. Have set degree 8 on MLOG$, source, and target. Specifically, when I crank up the refresh, with only updates, the update on the target serializes. Info in the docs is a little confusing. Much is made of partitioning a table in the DW guide to allow parallelism of the refresh. But it is unclear if they are talking an MV based on an object in the same DB, or, based on a remote object, or both. In the distributed manual it makes a comment about DML serializing when doing remote operations. Now someone looked into this a while back and opened a TAR to get an explanation -- the analyst said to simply use the parallelism parameter of the DBMS_SNAPSHOT.REFRESH. Well this didn't do it. Then he comes back and says it is possible to replicate a single table using parallelism if you use advanced replication (or maybe we read that somewhere). Guess I'll create a second 8.1.7 DB on my home machine and give that a go. But I'm probably missing something obvious here. So it's back to a simple question -- how can one use parallelism to refresh a single table? We can write our own routines to do this, but I would rather use native capabilities as opposed to re-inventing the wheel. Feeling pretty stupid here. Oh well, time to setup and test advanced replication. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Larry Elkins 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: Khedr, Waleed 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: Parallel Replication of Single Table
I am not sure about replication but in the past (on 8.1.5 and 8.1.6 versions) this has been my experience with CTAS over a dblink or DML over dblink in that it serializes. In order to achieve parallelism, the only workaround we had was (though not pretty :-) ) to use the ROWID hint on the CTAS and build a set of partition tables at the target and then merge them into a single table. We are able to achieve parallelism (8.1.7) with CTAS or inserts across DB's as long as we initiate the SQL from the *target* side. In this case you will see the parallelism on both the source and target side. Use it fairly often to move massive amounts of data. Larry G. Elkins [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Larry Elkins 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: Parallel Replication of Single Table
Waleed, Thanks for chiming in. Regarding refreshing multiple tables in parallel, well yes, that could be done on a group level. Instead, though, they choose to have the scheduling tool kick off multiple single table refreshes. They start many at the same time, so they do in essence get parallelism of multiple tables at one time. And this way they get paged with a specific should something fail. Regarding the other comments, the replication logic seems to handle the dependency you are talking about. There really isn't any order per se, so the same issues you raise would apply to serial processing as well, right? All those rows are in the MLOG$ table with a 1/1/4000 date -- in what order did they occur? Obviously an insert has to occur before the update to occur (with xceptions -- e.g. update, delete, then insert same PK row, etc). And we don't care how many updates have occurred since we are only interested in pushing the current image of the row. Now, what about deletes? Let's say you see deletes and inserts in the MLOG$ table. Well, they will all have the 1/1/4000 date prior to kicking off. How do we know which occurred first -- did we delete an existing row and then re-insert? Or did we insert and then delete? Well, that's handled by joining to the core table itself -- if the row exists, then you are going to push it, the insert would have happened after the delete. If it doesn't exist, then you know the delete happened after the insert. So the deletes are processed first using the existence in the base table test. With tracing turned on you can see how the replication logic handles this: Step 1 -- get the != 'I' where it's not in the existing table -- e.g. we know the last action was a delete, not an insert or update since the row no longer exists: SELECT /*+ remote_mapped(link) */ DISTINCT LOG$.OBJECT_ID FROM (SELECT MLOG$.OBJECT_ID FROM SCHEMA.MLOG$_MY_PTEST@link MLOG$ WHERE SNAPTIME$$ :1 AND (DMLTYPE$$ != 'I')) LOG$ WHERE (LOG$.OBJECT_ID) NOT IN (SELECT MAS_TAB$.OBJECT_ID FROM SCHEMA.MY_PTEST@LINK MAS_TAB$ WHERE LOG$.OBJECT_ID = MAS_TAB$.OBJECT_ID) Step 2 -- process those deletes: DELETE FROM SCHEMA.MV_MY_PTEST SNAP$ WHERE OBJECT_ID = :1 Step 3 -- Look for the != 'D' where it *exists* in the table. This will be the I's and U's. And because you handled the true deletes (as in no longer exists) in the prior step, then you know these go: SELECT /*+ remote_mapped(link) */ CURRENT$.OWNER, CURRENT$.OBJECT_NAME,CURRENT$.SUBOBJECT_NAME,CURRENT$.OBJECT_ID, CURRENT$.DATA_OBJECT_ID,CURRENT$.OBJECT_TYPE,CURRENT$.CREATED, CURRENT$.LAST_DDL_TIME,CURRENT$.TIMESTAMP,CURRENT$.STATUS, CURRENT$.TEMPORARY,CURRENT$.GENERATED,CURRENT$.SECONDARY FROM (SELECT /*+ */ MY_PTEST.OWNER OWNER,MY_PTEST.OBJECT_NAME OBJECT_NAME,MY_PTEST.SUBOBJECT_NAME SUBOBJECT_NAME, MY_PTEST.OBJECT_ID OBJECT_ID,MY_PTEST.DATA_OBJECT_ID DATA_OBJECT_ID,MY_PTEST.OBJECT_TYPE OBJECT_TYPE, MY_PTEST.CREATED CREATED,MY_PTEST.LAST_DDL_TIME LAST_DDL_TIME, MY_PTEST.TIMESTAMP TIMESTAMP,MY_PTEST.STATUS STATUS, MY_PTEST.TEMPORARY TEMPORARY,MY_PTEST.GENERATED GENERATED, MY_PTEST.SECONDARY SECONDARY FROM SCHEMA.MY_PTEST@LINK MY_PTEST) CURRENT$, (SELECT DISTINCT MLOG$.OBJECT_ID FROM SCHEMA.MLOG$_MY_PTEST@LINK MLOG$ WHERE SNAPTIME$$ :1 AND (DMLTYPE$$ != 'D')) LOG$ WHERE CURRENT$.OBJECT_ID = LOG$.OBJECT_ID Steps 4 and 5 (intermixed) -- process the inserts/updates, if you update before you insert, no big deal since you want the current image and the insert will handle it and no row to update will not fail. And if you try to insert before you update, no big deal since you will still be pushing the current image. So this goes: UPDATE SCHEMA.MV_MY_PTEST SET OWNER = :1,OBJECT_NAME = :2, SUBOBJECT_NAME = :3,OBJECT_ID = :4,DATA_OBJECT_ID= :5,OBJECT_TYPE = :6,CREATED = :7,LAST_DDL_TIME = :8,TIMESTAMP = :9,STATUS = :10, TEMPORARY = :11,GENERATED = :12,SECONDARY = :13 WHERE OBJECT_ID = :4 INSERT INTO SCHEMA.MV_MY_PTEST (OWNER,OBJECT_NAME,SUBOBJECT_NAME, OBJECT_ID,DATA_OBJECT_ID,OBJECT_TYPE,CREATED,LAST_DDL_TIME, TIMESTAMP,STATUS,TEMPORARY,GENERATED,SECONDARY) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13) Now I may have missed a few things there, but it sounds like it handles the dependencies. And what code and action may happen that doesn't manifest itself as SQL -- you see analyzes computing number of distinct, max, min, etc. But you don't see clustering and density factor calculations in terms of SQL. I need to do some more work on this, and the Advanced Replication guide does talk about dependencies and their impact on whether or not some things can parallelized, but I've got to dig a bit more into that. But still focusing on basic replication. Now the fun part is doing the replication in the *same* DB. I could get parallelism on the SELECT's, or at least the trace file said so, but they weren't observed, nor were the delete/updates/inserts observed working in parallel. So I still need to do
RE: Parallel Replication of Single Table
I remember too being able to achieve parallelism (8.1.7) with CTAS or inserts across DB's too but I'm not able to achieve this now. I tried it from the source side and the target side without success. It's always serial. Curious how you are able to test this. Thanks Waleed -Original Message- Sent: Tuesday, January 14, 2003 7:59 PM To: Multiple recipients of list ORACLE-L I am not sure about replication but in the past (on 8.1.5 and 8.1.6 versions) this has been my experience with CTAS over a dblink or DML over dblink in that it serializes. In order to achieve parallelism, the only workaround we had was (though not pretty :-) ) to use the ROWID hint on the CTAS and build a set of partition tables at the target and then merge them into a single table. We are able to achieve parallelism (8.1.7) with CTAS or inserts across DB's as long as we initiate the SQL from the *target* side. In this case you will see the parallelism on both the source and target side. Use it fairly often to move massive amounts of data. Larry G. Elkins [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Larry Elkins 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: Khedr, Waleed 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: Parallel Replication of Single Table
Waleed, Initiated from the target side. Parallel DML is enabled with an alter session. And you know it's using parallelism by watching the sessions spawned off on each side, the work they are doing, and the PQ stats. Another member of the list I work with (a darn genius I tell you, with a mind that never forgets anything, never forgetting any nuance or issue ;-) ) spent a little time this afternoon ripping 230 million rows from a large dimension across the db's. That was the workaround because the standard replication as is just couldn't handle the recent increase in the volume of changes. So normal replication couldn't keep up. And probably right now he is switching the objects, renaming and handling the grants -- our only occasional window before nightly stuff kicks in. So do a full copy from the staging DB. We (or maybe just I, though I'm sure the other person would have preferred to be doing other things) want to avoid having to do that -- we would rather keep up with normal replication. And we normally do, just a little more changes now and for the next 6 months or so. And then the feeds will get things up to normal and the volume of changes, at least with regard to updates, will decrease significantly. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Khedr, Waleed Sent: Tuesday, January 14, 2003 8:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: Parallel Replication of Single Table I remember too being able to achieve parallelism (8.1.7) with CTAS or inserts across DB's too but I'm not able to achieve this now. I tried it from the source side and the target side without success. It's always serial. Curious how you are able to test this. Thanks Waleed -Original Message- Sent: Tuesday, January 14, 2003 7:59 PM To: Multiple recipients of list ORACLE-L I am not sure about replication but in the past (on 8.1.5 and 8.1.6 versions) this has been my experience with CTAS over a dblink or DML over dblink in that it serializes. In order to achieve parallelism, the only workaround we had was (though not pretty :-) ) to use the ROWID hint on the CTAS and build a set of partition tables at the target and then merge them into a single table. We are able to achieve parallelism (8.1.7) with CTAS or inserts across DB's as long as we initiate the SQL from the *target* side. In this case you will see the parallelism on both the source and target side. Use it fairly often to move massive amounts of data. Larry G. Elkins [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Larry Elkins 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: Khedr, Waleed 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: Larry Elkins 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: Parallel Replication of Single Table
I knew I ran a parallel CTAS some time ago but was not successful doing this today. And here is why (you will like this): From 8.1.7 doc: DML statements and CREATE TABLE ... AS SELECT statements that reference remote objects can run in parallel. However, the remote object must really be on a remote database. The reference cannot loop back to an object on the local database (for example, by way of a synonym on the remote database pointing back to an object on the local database). I was testing using a database link pointing to the same database. Regards, Waleed -Original Message- Sent: Tuesday, January 14, 2003 10:04 PM To: Multiple recipients of list ORACLE-L Waleed, Initiated from the target side. Parallel DML is enabled with an alter session. And you know it's using parallelism by watching the sessions spawned off on each side, the work they are doing, and the PQ stats. Another member of the list I work with (a darn genius I tell you, with a mind that never forgets anything, never forgetting any nuance or issue ;-) ) spent a little time this afternoon ripping 230 million rows from a large dimension across the db's. That was the workaround because the standard replication as is just couldn't handle the recent increase in the volume of changes. So normal replication couldn't keep up. And probably right now he is switching the objects, renaming and handling the grants -- our only occasional window before nightly stuff kicks in. So do a full copy from the staging DB. We (or maybe just I, though I'm sure the other person would have preferred to be doing other things) want to avoid having to do that -- we would rather keep up with normal replication. And we normally do, just a little more changes now and for the next 6 months or so. And then the feeds will get things up to normal and the volume of changes, at least with regard to updates, will decrease significantly. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Khedr, Waleed Sent: Tuesday, January 14, 2003 8:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: Parallel Replication of Single Table I remember too being able to achieve parallelism (8.1.7) with CTAS or inserts across DB's too but I'm not able to achieve this now. I tried it from the source side and the target side without success. It's always serial. Curious how you are able to test this. Thanks Waleed -Original Message- Sent: Tuesday, January 14, 2003 7:59 PM To: Multiple recipients of list ORACLE-L I am not sure about replication but in the past (on 8.1.5 and 8.1.6 versions) this has been my experience with CTAS over a dblink or DML over dblink in that it serializes. In order to achieve parallelism, the only workaround we had was (though not pretty :-) ) to use the ROWID hint on the CTAS and build a set of partition tables at the target and then merge them into a single table. We are able to achieve parallelism (8.1.7) with CTAS or inserts across DB's as long as we initiate the SQL from the *target* side. In this case you will see the parallelism on both the source and target side. Use it fairly often to move massive amounts of data. Larry G. Elkins [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Larry Elkins 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: Khedr, Waleed 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: Larry Elkins 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
Parallel Replication of Single Table
Listers, How can one use parallelism when fast refreshing a *single* table? Pulling my hair out on this one. We want to use parallelism when replicating updates/inserts from a single partitioned table between DB's -- partitioned on both DB's. Both are 8.1.7.4 Solaris 8 64 bit. Using fast refresh and primary key method. Have the MV in the target, have the source along with the associated MLOG$. The job queues, parallel parameters, etc are all way up there. We manually pull on occasion when doing restructuring or mass mods and have no problems getting parallelism on each side. But we have to initiate from the target side as a pull to get that. Have set degree 8 on MLOG$, source, and target. Specifically, when I crank up the refresh, with only updates, the update on the target serializes. Info in the docs is a little confusing. Much is made of partitioning a table in the DW guide to allow parallelism of the refresh. But it is unclear if they are talking an MV based on an object in the same DB, or, based on a remote object, or both. In the distributed manual it makes a comment about DML serializing when doing remote operations. Now someone looked into this a while back and opened a TAR to get an explanation -- the analyst said to simply use the parallelism parameter of the DBMS_SNAPSHOT.REFRESH. Well this didn't do it. Then he comes back and says it is possible to replicate a single table using parallelism if you use advanced replication (or maybe we read that somewhere). Guess I'll create a second 8.1.7 DB on my home machine and give that a go. But I'm probably missing something obvious here. So it's back to a simple question -- how can one use parallelism to refresh a single table? We can write our own routines to do this, but I would rather use native capabilities as opposed to re-inventing the wheel. Feeling pretty stupid here. Oh well, time to setup and test advanced replication. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Larry Elkins 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).
Cross version SNAPSHOT/MATERIALIZED VIEW replication
Our current master is 8.1.6.3 as is our Snapshot database. However, at some time in the future our master database will be upgraded to 8.1.7.4. Our options are to stay with 8.1.6.3, upgrade to 8.1.7.4, or upgrade to 9.1.2. We can do this either before or after the master's upgrade. So our possible configurations are: MASTERSLAVE 8.1.6.3 8.1.7.4 8.1.6.3 9.1.2 8.1.7.4 8.1.6.3 8.1.7.4 8.1.7.4 8.1.7.4 9.1.2 These will be upgrades in place. Also, our customers are using a variety of methods to access the snapshot database including SQLNet and ODBC. I don't think that the OS environments are an issue but the master is on a DEC/Alpha UNIX box and the snapshot is on a Win2K box. Has anybody done this (upgrades in place for any of the master/slave pairs) and, if so, did you run into any issues? Any input will be gratefully accepted in the spirit in which it is offered. We are RTing the FMs for all they're worth but the upgrade in place is treated as a non-issue (which I suspect is not the case) and I'd rather hear from someone who has actually done it. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day 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).
Oracle Advanced Replication
To all,
I have a 5-way multi-master replication set up on Oracle 817 and Sun Solaris
2.7.
In the replication group, we would like to add a new column to a replicated
table.
Not only that, we would like to add this new column to the primary key of this
replicated table.
What are the steps that I would need to do?
I seems to remember that if we add any new columns in the replicated object, we
would need to
1) quieced the whole environment
2) drop this object from the replication group
3) add the new column in the MDS as well as all other master sites
4) add this table back to the replication group
5) generate replication support
6) resume replication again
Would some replication expert tell me if I am correct or not? (I did try to look
in the doc, but I can't find it any where)
Thanks for your help!
Winnie
--
\ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~
(@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~
/ V \ Oracle Database Administrator`~`~
o--m-m--o Infonet Services Corporation `~`~
# mailto:[EMAIL PROTECTED]`~`~
~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Oracle Advanced Replication
Is there some reason that you can't use DBMS_REPCAT.EXECUTE_DDL? See
the Supplied PL/SQL Packages reference; here's the description:
EXECUTE_DDL Procedure
This procedure supplies DDL that you want to have executed at some or
all master sites. You can call this procedure only from the master
definition site.
This package is intended to replicate changes made to objects that
belong to a replication group, so it should be suitable for use here,
as well as being a whole lot simpler than the approach you'd otherwise
have to take.
HTH.
--- [EMAIL PROTECTED] wrote:
To all,
I have a 5-way multi-master replication set up on Oracle 817 and Sun
Solaris
2.7.
In the replication group, we would like to add a new column to a
replicated
table.
Not only that, we would like to add this new column to the primary
key of this
replicated table.
What are the steps that I would need to do?
I seems to remember that if we add any new columns in the replicated
object, we
would need to
1) quieced the whole environment
2) drop this object from the replication group
3) add the new column in the MDS as well as all other master sites
4) add this table back to the replication group
5) generate replication support
6) resume replication again
Would some replication expert tell me if I am correct or not? (I did
try to look
in the doc, but I can't find it any where)
Thanks for your help!
Winnie
--
\ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~
(@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~
/ V \ Oracle Database Administrator`~`~
o--m-m--o Infonet Services Corporation `~`~
# mailto:[EMAIL PROTECTED]`~`~
~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Oracle Advanced Replication
The only reason is that we have to change the primary key constraint. That's
mean, we got to drop and recreate the primary key constraint. And if the
replicated object is still in the replication group, it probably won't allow me
to drop the primary key though. (or maybe I got it all wrong?)
Thanks for your help anyway,
Winnie
--
\ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~
(@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~
/ V \ Oracle Database Administrator`~`~
o--m-m--o Infonet Services Corporation `~`~
# mailto:[EMAIL PROTECTED]`~`~
~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~
Paul Baumgartel
treegarden@yahooTo: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
.comcc:
Sent by: Subject: Re: Oracle Advanced
Replication
[EMAIL PROTECTED]
12/11/02 04:58 PM
Please respond to
ORACLE-L
Is there some reason that you can't use DBMS_REPCAT.EXECUTE_DDL? See
the Supplied PL/SQL Packages reference; here's the description:
EXECUTE_DDL Procedure
This procedure supplies DDL that you want to have executed at some or
all master sites. You can call this procedure only from the master
definition site.
This package is intended to replicate changes made to objects that
belong to a replication group, so it should be suitable for use here,
as well as being a whole lot simpler than the approach you'd otherwise
have to take.
HTH.
--- [EMAIL PROTECTED] wrote:
To all,
I have a 5-way multi-master replication set up on Oracle 817 and Sun
Solaris
2.7.
In the replication group, we would like to add a new column to a
replicated
table.
Not only that, we would like to add this new column to the primary
key of this
replicated table.
What are the steps that I would need to do?
I seems to remember that if we add any new columns in the replicated
object, we
would need to
1) quieced the whole environment
2) drop this object from the replication group
3) add the new column in the MDS as well as all other master sites
4) add this table back to the replication group
5) generate replication support
6) resume replication again
Would some replication expert tell me if I am correct or not? (I did
try to look
in the doc, but I can't find it any where)
Thanks for your help!
Winnie
--
\ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~
(@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~
/ V \ Oracle Database Administrator`~`~
o--m-m--o Infonet Services Corporation `~`~
# mailto:[EMAIL PROTECTED]`~`~
~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ: http
Re: Replication Manager
Building replication is usually somewhat lengthy process. I spent sometime with an Oracle expert and built a skeleton script to build my replication via sqlplus. However, I use the replication manager to track the progress of the build process and to check the results. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 25, 2002 7:39 PM Has anyone used Replication Manager with success? Any feedback on issues you may have run into would be greatly appreciated. Does it come bundled with OEM or is it typically on a separate CD as a Management Pack? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Sardin 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.com -- Author: Yechiel Adar 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).
