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."