OraFAQ Forum: Backup & Recovery » re-syncing physical stdby DB

Home » RDBMS Server » Backup & Recovery » re-syncing physical stdby DB (Oracle 11.2.0.2 Solaris 2.10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

re-syncing physical stdby DB [message #564787]

Tue, 28 August 2012 12:40

BeefStu
Messages: 208
Registered: October 2011

Senior Member

One of my physical stdby DB's have been offline for a while due to some disk issues,l which were rectified.

I don't have all the .arc files dating back from when the stdby went off line.

Is there an RMAN command/script I can use to re-instantiate the stby DB?

Any examples, would be greatly appreciated.

Report message to a moderator

Re: re-syncing physical stdby DB [message #564788 is a reply to message #564787]

Tue, 28 August 2012 12:46

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

RMAN> DATABASE DUPLICATE;

Report message to a moderator

Re: re-syncing physical stdby DB [message #564791 is a reply to message #564788]

Tue, 28 August 2012 13:11

John Watson
Messages: 8989
Registered: January 2010
Location: Global Village

Senior Member

I've never done it, but you can use BACKUP INCREMENTAL FROM SCN.... to extract all the blocks changed since the SCN of your standby, and recover it. Probably qucker to follow the BlackSwan's advice.

Report message to a moderator