cancel
Showing results for 
Search instead for 
Did you mean: 

Revert Switchover of Database (DataGuard)

Former Member
0 Kudos

Hi

I have created a RQ9_PRD system and also created as standby system as RQ9_DRS. I have configured the activities successfully and also log get
applied. Now I have done the role switchover from and now PRD become standby and stand by become primary. The db_unique_name for both are different as  primary is RQ9_PRD and disaster is RQ9_DRS.Now the status shown as below:

At Primary
==========
SQL> select name,open_mode,database_role from v$standby;

NAME                 OPEN_MODE                 DATABASE_ROLE
===========     ================== ================
RQ9                      READ_ONLY                 PHYSICAL STANDBY


At Standby
==========
SQL> select name,open_mode,database_role from v$standby;

NAME              OPEN_MODE                 DATABASE_ROLE
=========== ================== ================
RQ9                 READ WRITE                 PRIMARY


Please suggest how to go back as PRimary as READ WRITE and DR as STANDBY Mode.

Pl help us.

Regards

Vimal

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi

I have tried the below option to make our primary database open in read write mode.
but result is unsucessful.


Command 1 : Check the status as below:
--------------------------------------

SQL> select open_mode,database_role from v$database;

OPEN_MODE  DATABASE ROLE
==============  =================
MOUNTED   PHYSICAL STANDBY


Command 2 : Try to open database :
--------------------------------------
SQL> Alter database openl

Database altered


Command 3 : Check the status as below:
--------------------------------------
SQL> select open_mode,database_role from v$database;

OPEN_MODE  DATABASE ROLE
==============  =================
READ ONLY  PHYSICAL STANDBY

Command 4: Shutdown database
--------------------------------------

SQL> SHUTDOWN IMMDIATE;

Command 5: Startup database
--------------------------------------
SQL> STARTUP MOUNT;
SQL> ALTER DATABASE OPEN READ WRITE ;

Error ORA-16003: standby database is restricted to read-only access

Command 6: Start recover database
--------------------------------------
SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

Error: Ora-16136: Managed Standby Recovery not active


Command 7: Start recover database force fully
--------------------------------------------

SQL> alter database recover managed standby database finish force;

Result: 1) Going in infinit loop. No comming out to SQL prompt
        2) In alert log showing as
        "Media Recovery log E:\ORACLE\RQ9\ORAFLASH\RQ9_PRD|.............
        there are 17 entry

Please note that I have stuck on the issue. I have take the help
from link "https://forums.oracle.com/thread/2234918".
I just hold this as it is and want to know that what is wrong. Pl do the needful

Thanks in Advance

Regards

Vimal

Former Member
0 Kudos

Has any expert can help us...