RE: Data Guard vs Streams for a RAC database

  • From: Michael Dinh <mdinh@xxxxxxxxx>
  • To: "'sjaffarhussain@xxxxxxxxx'" <sjaffarhussain@xxxxxxxxx>, Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 8 Dec 2010 09:01:46 -0800

I would use Data Guard (physical standby) because it's easy to implement and 
development on streams has stopped after the acquisition of Golden Gate.

If you don't have EE, then you can use DBvisit as suggested in the thread.

I have not used DBvisit myself.

Michael Dinh

NOTICE OF CONFIDENTIALITY - This material is intended for the use of the 
individual or entity to which it is addressed, and may contain information that 
is privileged, confidential and exempt from disclosure under applicable laws.  
BE FURTHER ADVISED THAT THIS EMAIL MAY CONTAIN PROTECTED HEALTH INFORMATION 
(PHI). BY ACCEPTING THIS MESSAGE, YOU ACKNOWLEDGE THE FOREGOING, AND AGREE AS 
FOLLOWS: YOU AGREE TO NOT DISCLOSE TO ANY THIRD PARTY ANY PHI CONTAINED HEREIN, 
EXCEPT AS EXPRESSLY PERMITTED AND ONLY TO THE EXTENT NECESSARY TO PERFORM YOUR 
OBLIGATIONS RELATING TO THE RECEIPT OF THIS MESSAGE.  If the reader of this 
email (and attachments) is not the intended recipient, you are hereby notified 
that any dissemination, distribution or copying of this communication is 
strictly prohibited. Please notify the sender of the error and delete the 
e-mail you received. Thank you.
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Syed Jaffar Hussain
Sent: Wednesday, December 08, 2010 5:30 AM
To: Oracle-L Freelists
Subject: Data Guard vs Streams for a RAC database

Good day everyone,

We are in need of preparing a backup server for one of the business critical 
RAC databases at our company. Since the DRC setup will take some considerable 
time, application owner requested to maintain a backup database server (active) 
for the database to be able to survive from any scary incidents. Although my 
vote goes to Data guard configuration, we would like to choose the best and a 
very light weight option to fulfill the requirement. Any pros and cons or 
comparision between these two would be highly appreciated.

--
Best Regards,

Syed Jaffar Hussain
Oracle Certified Master (10g)
http://www.oracle.com/technology/ocm/shussain.html
Co-author Oracle 11gR1/R2 RAC Handbook
http://www.packtpub.com/oracle-11g-r1-r2-real-application-clusters-handbook/book
Oracle ACE
http://apex.oracle.com/pls/otn/f?p=19297:4:4640302666204919::NO:4:P4_ID:186
OCP 8i,9i,10g & 11g DBA
RAC Certified Expert
Official Oracle RAC SIG Representative for Saudi Arabian region  
(http://www.oracleracsig.org/)
I blog at
http://jaffardba.blogspot.com/
LinkedIn : http://www.linkedin.com/in/sjaffarhussain
--------------------
"Winners don't do different things. They do things differently."

Other related posts: