OraFAQ Forum: Data Guard » Recreating Physical Standby

Home » Server Options » Data Guard » Recreating Physical Standby (Oracle 10g RHEL)

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

Recreating Physical Standby [message #459387]

Fri, 04 June 2010 10:17

bank_master
Messages: 64
Registered: April 2007
Location: Guyana

Member

Hi guys,

I have an issue whereby our standby instance was down for a couple of days and when it came back online we found an archivelog file was missing, so recovery only happened up to a point. It appears that the archivelog was deleted therefore we are unable to continue with this standby. We are now planning to rebuild the standby database. As far as i know all of the steps originally performed need not be performed to complete this task. So far these are the steps that i have can somebody please assist in overing advise if they steps are correct or complete.

1. Shutdown standby
2. Delete all datafiles & redo logs
3. Copy over datafiles to respective directories
4. Copy online logs and archivelogs to standby.
5. Create a control file for standby database
6. Startup mount standby database
7. start redo apply

Regards,
Kieron

Report message to a moderator

Re: Recreating Physical Standby [message #459419 is a reply to message #459387]

Fri, 04 June 2010 21:49

ebrian
Messages: 2786
Registered: April 2006

Senior Member

Your steps seem accurate assuming you are copying over the datafiles while the primary database is shutdown. In addition, you will not need to copy the online logs over to the standby.

Report message to a moderator