Home » Server Options » Data Guard » Switchover (Oracle 10.2.0.1.0 - Linux)
icon4.gif  Switchover [message #350631] Thu, 25 September 2008 12:53 Go to next message
danyromimd
Messages: 73
Registered: August 2008
Member
Hi!
I was trying to perform a switchover and I've put the foot on it!
Now I've got 2 Primary databases and I dont know how to make one of them standby.
I've tried the following commands on both databases and both of them output the same error...

SQL> alter database commit to switchover to physical standby ;
alter database commit to switchover to physical standby
*
ERROR at line 1:
ORA-16416: Switchover target is not synchronized with the primary

SWITCHOVER_STATUS....
SQL> select switchover_status from v$database;
SWITCHOVER_STATUS
--------------------
SESSIONS ACTIVE

SQL> select switchover_status from v$database;
SWITCHOVER_STATUS
--------------------
NOT ALLOWED


Thanks in advance.


Re: Switchover [message #350644 is a reply to message #350631] Thu, 25 September 2008 14:27 Go to previous messageGo to next message
danyromimd
Messages: 73
Registered: August 2008
Member
Already solved it...
All I did was shutdown one of the databases, create a standby control file from the other database, copy the control file to the supposed standby and start it up again.

Bye!
Re: Switchover [message #352923 is a reply to message #350644] Fri, 10 October 2008 04:41 Go to previous messageGo to next message
paczan
Messages: 2
Registered: October 2008
Junior Member
Hi,
I have the same problem with Oracle 11g on Solaris 10.
Both databases are Primary and sync error is coming when I try to change status.

I'm a bit novice in Data Guard... can you tell me how to create standby control file.

Thanks for your help.

Max
Re: Switchover [message #353008 is a reply to message #352923] Fri, 10 October 2008 09:47 Go to previous messageGo to next message
danyromimd
Messages: 73
Registered: August 2008
Member
To create a control file, you have to do the following on the Primary server...

SQL> startup mount;
SQL> alter database create standby controlfile as ‘<file-name>’;
SQL> alter database open;

Then you have to copy the file you created to the Standby server in the corresponding directory (control_files parameter in the init.ora file) with the database in shutdown mode. Start it up and it will be Standby again.


Hope that helps!
Re: Switchover [message #353134 is a reply to message #353008] Sat, 11 October 2008 15:01 Go to previous message
paczan
Messages: 2
Registered: October 2008
Junior Member
It's working fine.
Thanks a lot!!!
Previous Topic: Standby is not caught up
Next Topic: Is there a max number of mins for DELAY parameter?
Goto Forum:
  


Current Time: Sat Dec 10 20:22:30 CST 2016

Total time taken to generate the page: 0.04625 seconds