RE: Multimaster replication as alternative backup

2003-12-14 Thread Sami
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 c

Re: Multimaster replication as alternative backup

2003-11-20 Thread Yechiel Adar
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 - O

RE: Multimaster replication as alternative backup

2003-11-19 Thread DENNIS WILLIAMS
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-

Re: Multimaster replication as alternative backup

2003-11-19 Thread Yechiel Adar
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.

Re: Multimaster replication as alternative backup

2003-11-18 Thread Arup Nanda
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 t

Multimaster replication as alternative backup

2003-11-18 Thread VirVit
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 -- Aut