Home » Server Options » Data Guard » Doubt regarding switchover from logical standby to primary
Doubt regarding switchover from logical standby to primary [message #310934] Wed, 02 April 2008 20:27 Go to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
I am using Oracle 10g databases on Linux environment

I was trying creating a data guard configuration and once I was successfully done I created a logical standby database from the physical standby . Then I was trying to do a switchover .
By mistake I gave the prepare switchover command in the logical standby before executing it in the primary . And then when I gave it in the primary both the status turned to be "PREPARING SWITCHOVER"

In logical standby
SQL> ALTER DATABASE PREPARE TO SWITCHOVER TO PRIMARY;

Database altered.

SQL>  SELECT SWITCHOVER_STATUS FROM V$DATABASE;

SWITCHOVER_STATUS
--------------------
PREPARING SWITCHOVER
In primary 
SQL> ALTER DATABASE PREPARE TO SWITCHOVER TO LOGICAL STANDBY;

Database altered.

SQL> select switchover_status from v$database;

SWITCHOVER_STATUS
--------------------
PREPARING SWITCHOVER



Now I am not able to commit any of them to primary or logical standby
In primary
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO LOGICAL STANDBY;
ALTER DATABASE COMMIT TO SWITCHOVER TO LOGICAL STANDBY
*
ERROR at line 1:
ORA-16217: prepare to switchover has not completed
ORA-06512: at line 1
In logical standby
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
ALTER DATABASE commit  TO SWITCHOVER TO PRIMARY
*
ERROR at line 1:
ORA-16109: failed to apply log data from previous primary



Let me know what should be done now ? Is there anyway to solve this issue ?

Re: Doubt regarding switchover from logical standby to primary [message #317904 is a reply to message #310934] Sun, 04 May 2008 16:01 Go to previous message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
Did you tried to cancel switchover?

SQL> alter database prepare to switchover cancel;

Sandeep
Previous Topic: Query regarding upgrading protection mode in a data guard
Next Topic: not log in after shutdown
Goto Forum:
  


Current Time: Mon Jul 28 00:33:55 CDT 2014

Total time taken to generate the page: 0.04528 seconds