Database Backup and Recovery (MOSC)

MOSC Banner

Restore a primary RAC using backup taken from physical standby RAC

edited Oct 8, 2013 6:33AM in Database Backup and Recovery (MOSC) 2 commentsAnswered
 Hi,
 I would restore a primary RAC using backup taken from physical standby RAC .
According to doc, backup of datafile, control file in 11.2 should be interchangeable.

Does anyone have real experience about this case?
My proposed procedure is listed as following.
Any comment/suggestion would be much appreciated.

Thanks

Regards
Thomas

Procedure
Backup standby database:
rman target / 
set controlfile autobackup format for device type disk to "+FRADG";
backup database format "+FRADG" plus archivelog format "+FRADG" delete input;

Verify the backup
list backupset of database;

Switch the current log in primary database 
alter system archive log current; -- For RAC, just need to run on 1 node

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center