Database Backup and Recovery (MOSC)

MOSC Banner

Need to rebuild a physical standby from primary rman backups

edited Feb 13, 2014 9:00AM in Database Backup and Recovery (MOSC) 1 commentAnswered

I developed this from reading through docs and would like some feedback does this look appropriate to rebuild a physical standby on a remote server using a RMAN backup and archive logs from the primary . THe instance names between primary and standby are different as are the locations of the datafiles so I used file name convert. The standby was already acting as a standby and I had a failure that broke the recovery chain forcing a rebuild of the standby. How does this look? (Thanks in advance) I fudged the instance names...for obvious reasons.

I have added a datafile to primary since standby failure so I know I have to recreate the control file or restore a control file to standby, advice on that also appreciated. I can do that from a backup to trace and simply edit the appropriate script and create before doing the rman thing. THis would a be anew process for me I usually just put the primary in backup mode and backup control file totrace then copy all the files over to the standby, rebuild the control file then start and mount standby and begin recovery. But I wanted

Tagged:

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