OraFAQ Forum: Data Guard » Doubt regarding switchover from logical standby to primary

Home » Server Options » Data Guard » Doubt regarding switchover from logical standby to primary

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

Doubt regarding switchover from logical standby to primary [message #310934]

Wed, 02 April 2008 20:27

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 ?

Report message to a moderator