Home » RDBMS Server » Backup & Recovery » RMAN backup strategy for active-active deployments using streams (Oracle 11G)
RMAN backup strategy for active-active deployments using streams [message #561813] Wed, 25 July 2012 06:46 Go to next message
Messages: 1
Registered: July 2012
Junior Member
We are using oracle as database in our application. For high availability we have a cluster of multiple nodes and the data is replicated using oracle streams. All the nodes in the cluster are active. We do not have any concept of stand-by. Now we are planning to use oracle RMAN for backup and recovery. RMAN user's guide doesn't recommend any strategies for such deployments. It mainly focuses on primary/stand-by deployments. Is there any other place I can find info in this regard ??
Re: RMAN backup strategy for active-active deployments using streams [message #561815 is a reply to message #561813] Wed, 25 July 2012 06:55 Go to previous message
John Watson
Messages: 8592
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

You are not going to like this answer. I think you have taken a seriously wrong approach. Replicating multiple databases is not usually the best approach for HA in an Oracle environment. Data Guard is usually a far superior solution, both in terms of functionality and ease of maintenance. Is there any reason not to use it? You may have done a lot of work with Streams already, but it would be better to change now, rather than later.

[Updated on: Wed, 25 July 2012 06:57]

Report message to a moderator

Previous Topic: Oracle 10g RAC - Cannot set IS_RECOVERY_DEST_FILE to YES
Next Topic: Recovery of database from crashed host server
Goto Forum:

Current Time: Sat Sep 18 07:48:04 CDT 2021