Home » Server Options » Data Guard » refresh primary using standby database (Oracle, 10G, windows2003)
refresh primary using standby database [message #576303] Sat, 02 February 2013 18:32 Go to next message
Messages: 83
Registered: July 2006
Hi All,

I was using physical standby but my primary database had had some HW issue.
So I had activated standby database to handle production.
During 3 months, standby database was our live database and our old primary was unavailable.
Now HW issue on primary has been fixed.
And I want to set again my old configuration : means set primary and standby db.
I'm trying this :

1) check the SCN on old primary
2) Rman incremantal backup from scn
3) on primary db : catalog
4) on primary db : recover database noredo

Tell me if it can work or not ?
or another suggestions ?

Thanks in advance.
Re: refresh primary using standby database [message #576310 is a reply to message #576303] Sun, 03 February 2013 01:30 Go to previous message
Michel Cadot
Messages: 67135
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just do as you did to build the ex-standby, make the ex-primary the current standby and switch over.

Previous Topic: not able to get data of primary in standby database (dataguard)
Next Topic: physical standby on windows 2003
Goto Forum:

Current Time: Fri May 29 06:33:24 CDT 2020