Dataguard Fail back [message #529496] |
Tue, 01 November 2011 09:19 |
|
juniorpeardba
Messages: 31 Registered: April 2011 Location: London
|
Member |
|
|
Hi hopefully a simple question, so here goes
Last week we had to fail over our running env to the standby which is still in operation, as there was a hardware error on one of the ASM disks (FRA)
That problem has now been solved, however we have now been up and running for a week now in the standby environment. I am trying to simplify a method to fail-back to our primary and have things running as they were and should be. After reading a few articles on Dataguard there seems to be numerous methods that I could implement.
1. rman duplicate target database
2. Physical standby Switchover
3. Physical Standby Failover
I am trying to find the easiest with the least amount of downtime, that involves minimum risk.
If you can provide an article or a step-by-step approach that would be most appreciated.
regards
jnrpeardba
|
|
|
Re: Dataguard Fail back [message #529509 is a reply to message #529496] |
Tue, 01 November 2011 10:44 |
John Watson
Messages: 8950 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Hi, man - if you did a failover (rather than a switchover) then your only option is (1), unless you have flashback enabled. Flashback will let you re-instate the old primary as a standby, so you can synchronize them and then use (2).
|
|
|
|
|
Re: Dataguard Fail back [message #551181 is a reply to message #530200] |
Mon, 16 April 2012 01:53 |
|
Hi
I performed switchover between primary and standby database, and again I want to switchover from old standby to old primary database and I am getting this error can any one help to solve this error???
SQL> alter database commit to switchover to physical primary;
alter database commit to switchover to physical primary
*
ERROR at line 1:
ORA-16087: Switchover requires standby or current control file.
|
|
|
|
Re: Dataguard Fail back [message #551190 is a reply to message #551181] |
Mon, 16 April 2012 03:13 |
|
Michel Cadot
Messages: 68687 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
ORA-16087: graceful switchover requires standby or current control file
*Cause: An attempt was made to perform a graceful switchover operation
using a backup or clone control file.
*Action: Convert the backup control file into a current control file prior
to attempting a graceful switchover operation. A clone control file
cannot be used for a graceful switchover operation.
Regards
Michel
|
|
|