Home » Server Options » Data Guard » Recreating Physical Standby (Oracle 10g RHEL)
Recreating Physical Standby [message #459387] Fri, 04 June 2010 10:17 Go to next message
bank_master
Messages: 73
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
Re: Recreating Physical Standby [message #459419 is a reply to message #459387] Fri, 04 June 2010 21:49 Go to previous messageGo to next message
ebrian
Messages: 2794
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.
Re: Recreating Physical Standby [message #459433 is a reply to message #459387] Sat, 05 June 2010 02:49 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You will need to create your standby logs, too.
Re: Recreating Physical Standby [message #459454 is a reply to message #459433] Sat, 05 June 2010 10:27 Go to previous messageGo to next message
bank_master
Messages: 73
Registered: April 2007
Location: Guyana
Member

Ok thanks guys i will comment on how it went.
Re: Recreating Physical Standby [message #459461 is a reply to message #459454] Sat, 05 June 2010 11:45 Go to previous messageGo to next message
bank_master
Messages: 73
Registered: April 2007
Location: Guyana
Member

Everything worked fine no problems thanks again
Re: Recreating Physical Standby [message #459466 is a reply to message #459461] Sat, 05 June 2010 14:06 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Glad we could help.

Thanks for the feedback.
Previous Topic: Error occurred Data Guard during intial DB duplicate to standby server
Next Topic: using DBMS_LOGSTDBY
Goto Forum:
  


Current Time: Fri Mar 29 07:58:39 CDT 2024