OraFAQ Forum: Data Guard

Home » Server Options » Data Guard » Switchover (Oracle 10.2.0.1.0 - Linux)

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

Switchover [message #350631]

Thu, 25 September 2008 12:53

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.

Report message to a moderator

Re: Switchover [message #350644 is a reply to message #350631]

Thu, 25 September 2008 14:27

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!

Report message to a moderator

Re: Switchover [message #352923 is a reply to message #350644]

Fri, 10 October 2008 04:41

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

Report message to a moderator

Re: Switchover [message #353008 is a reply to message #352923]

Fri, 10 October 2008 09:47

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!

Report message to a moderator

Re: Switchover [message #353134 is a reply to message #353008]

Sat, 11 October 2008 15:01

paczan
Messages: 2
Registered: October 2008

Junior Member

It's working fine.
Thanks a lot!!!

Report message to a moderator

Previous Topic:	Standby is not caught up
Next Topic:	Is there a max number of mins for DELAY parameter?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 28 04:13:31 CDT 2025