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).
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).
Multimaster Replication Doubt...
1. It is my understanding that Oracle 7.x has continuous purge of the propogated deftrans. There is no option of scheduling periodic purge at specific time. Am I correct? 2. How to schedule continuous purge of propogated deftrans in Oracle 8i from command line? prompt SCHEDULE PURGE AT MASTER SITE BEGIN DBMS_DEFER_SYS.SCHEDULE_PURGE ( NEXT_DATE = SYSDATE, INTERVAL = 'SYSDATE + 1/24', DELAY_SECONDS = 0, ROLLBACK_SEGMENT = ''); END; / Manual says set DELAY_SECONDS to 500,000 and set INTERVAL to a value less than DELAY_SECONDS. I could not understand exactly how this works... +Rahul ___ ______ ___ ___ / /\ / /\ / /\ / /\ / /\ / /::\ / /::\/ /:// /:// /:/ / /:/\:\ / /:/:| / /:// /:// /:/ / /::\ \:\ / /:/|:| / /::\ __ / /:/ ___ / /:/ /__/:/\:\_\:\ /__/::\|:| /__/:/\:\/ /\ /__/:/ / /\ /__/:/ \__\/~|::\/:/ \__\/\:\:| \__\/ \:\/:/ \ \:\ / /:/ \ \:\ | |:|::/ \__\::| \__\::/ \ \:\ /:/ \ \:\ | |:|\/ | |:| / /:/ \ \:\/:/ \ \:\ |__|:| |__|:| /__/:/ \ \::/ \ \:\ \__\| \__\| \__\/ \__\/ \__\/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: multimaster replication
Andrey, Don't even think about implementing this until you've read the manuals and thoroughly understand the concepts. Replication can be very unforgiving when you don't properly design and configure it. You may also find that your application is not even suited for it. - Is it a must for the 2 DBs to be of the same version (release) ? - Is it a must for the 2 DBs to run on the same O/S, hardware etc ... ? NO, to all of the above. One of replication's strength's is that it is Oracle, OS and hardware version independent. Personally, I wouldn't even try implementing it on Oracle7 and given a choice I'd use 8i or 9i. Any combination of currently supported versions will work just fine. I'd start with reading the Oracle Distributed, Replication, and Replication API manuals. I also like Charles Dye's Oracle Distributed Systems (O'Reilly). My Replication Do's and Don'ts paper is available on Christopher Spence's site: http://www.vampired.net/articles/files/replication1.zip Good luck! -- Anita --- Andrey Bronfin [EMAIL PROTECTED] wrote: Dear gurus ! Finally , they caught me ;-( I need to implement multimaster replication (asynchronous) among 2 databases. A couple of general questions before i start : - Is it a must for the 2 DBs to be of the same version (release) ? - Is it a must for the 2 DBs to run on the same O/S, hardware etc ... ? - Do U have to replicate among 2 schemas with the same names ? - Are there any general bugs / issues ? Something to be aware of ? - And , the most important , i'd be very happy if u , gurus , could send me some scripts , how-tos , manuals , articles , your thoughts - simply anything related to advanced replication. Many thanks in advance. Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: multimaster replication
Dear gurus ! I need to implement multimaster replication (asynchronous) among 2 databases. A couple of general questions before i start : - Is it a must for the 2 DBs to be of the same version (release) ? - Is it a must for the 2 DBs to run on the same O/S, hardware etc ... ? - Do U have to replicate among 2 schemas with the same names ? - Are there any general bugs / issues ? Something to be aware of ? - And , the most important , i'd be very happy if u , gurus , could send me some scripts , how-tos , manuals , articles , your thoughts - simply anything related to advanced replication. Many thanks in advance. Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
multimaster replication
Dear gurus ! Finally , they caught me ;-( I need to implement multimaster replication (asynchronous) among 2 databases. A couple of general questions before i start : - Is it a must for the 2 DBs to be of the same version (release) ? - Is it a must for the 2 DBs to run on the same O/S, hardware etc ... ? - Do U have to replicate among 2 schemas with the same names ? - Are there any general bugs / issues ? Something to be aware of ? - And , the most important , i'd be very happy if u , gurus , could send me some scripts , how-tos , manuals , articles , your thoughts - simply anything related to advanced replication. Many thanks in advance. Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Multimaster Replication
hi gurus My Asynchronus multimaster replication is working fine. But the moment i remove the physical connectiviy (network link),it hangs without even updating local data base. i mean it's not allowing me to commit insert statement at one location. Can anybody helps me in this. thanks -Nihar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nihar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Multimaster Replication
Nihar, Don't remove the network link!! O.KI'm not a replication guru, but my thoughts are that the way replication is setup, the commit can only happen if the data can be replicated as it should. If there is no network connectivity, the instance cannot get to one of the other required instances...and it hangs until it finds it. Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Monday, May 21, 2001 5:51 PM To: Multiple recipients of list ORACLE-L hi gurus My Asynchronus multimaster replication is working fine. But the moment i remove the physical connectiviy (network link),it hangs without even updating local data base. i mean it's not allowing me to commit insert statement at one location. Can anybody helps me in this. thanks -Nihar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nihar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Multimaster Replication
Hi! Well, i am not going to remove the link but What if the internet connectivity fails. My DB servers are at different locations and i am doing it through WAN link .Is there any way to queup the data till links come up. thanks -Nihar -Original Message- Sent: Tuesday, May 22, 2001 3:56 AM To: Multiple recipients of list ORACLE-L Nihar, Don't remove the network link!! O.KI'm not a replication guru, but my thoughts are that the way replication is setup, the commit can only happen if the data can be replicated as it should. If there is no network connectivity, the instance cannot get to one of the other required instances...and it hangs until it finds it. Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Monday, May 21, 2001 5:51 PM To: Multiple recipients of list ORACLE-L hi gurus My Asynchronus multimaster replication is working fine. But the moment i remove the physical connectiviy (network link),it hangs without even updating local data base. i mean it's not allowing me to commit insert statement at one location. Can anybody helps me in this. thanks -Nihar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nihar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nihar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Multimaster Replication
Nihar, This is not normal. Asynchronous propagation populates the deferred transactions queues which are then pushed at a later time, so the only thing that should happen when network connectivity is lost is that the job pushing the queues will fail. Once connectivity is re-established the job wil lresume pushing, unless it failed 16 times and was marked broken in which case it will need to be manually run or marked unbroken. Even with synchronous replication it shouldn't hang indefinitely. Eventually a timeout will be reached and an error will be returned since the transaction cannot commit at all sites. What Oracle and OS versions are involved? When your insert session is hanging, what is the wait event in V$SESSION_WAIT for that session? HTH, -- Anita --- Nihar [EMAIL PROTECTED] wrote: Hi! Well, i am not going to remove the link but What if the internet connectivity fails. My DB servers are at different locations and i am doing it through WAN link .Is there any way to queup the data till links come up. thanks -Nihar -Original Message- Sent: Tuesday, May 22, 2001 3:56 AM To: Multiple recipients of list ORACLE-L Nihar, Don't remove the network link!! O.KI'm not a replication guru, but my thoughts are that the way replication is setup, the commit can only happen if the data can be replicated as it should. If there is no network connectivity, the instance cannot get to one of the other required instances...and it hangs until it finds it. Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Monday, May 21, 2001 5:51 PM To: Multiple recipients of list ORACLE-L hi gurus My Asynchronus multimaster replication is working fine. But the moment i remove the physical connectiviy (network link),it hangs without even updating local data base. i mean it's not allowing me to commit insert statement at one location. Can anybody helps me in this. thanks -Nihar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nihar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nihar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Multimaster Replication setup
Hi I am trying to setup multimaster replication environment. I have two machines. On on windows NT and one on linux. I followed all the steps listed in oracle8i Api reference manuals till chapter 3. But when I update emp table. It corresponding updations are not reflected in second database. Can anyone please help me in setting up of replication server. Also can anyone tell me sites giving Complete steps for setting up replication server. I am here not going for snapshot site I am just trying for multimaster replication Regards Brijesh __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
