Revert Switchover of Database (DataGuard)

[Former Member]

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

[Former Member]

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]

Has any expert can help us...