Primary Database Revert problem after switch over - Very Urgent Help Require

[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 Pathak   

[stefan_koehler]

Hi Vimal,

this is a forum with / for volunteers, so you can not request or expect urgent help here.

> I just hold this as it is and want to know that what is wrong. Pl do the needful

All of your described issues are just based on lack of know how. The needful is, that you get some training on Oracle Data Guard first before administrating or using it.

SQL> ALTER DATABASE OPEN READ WRITE ;
Error ORA-16003: standby database is restricted to read-only access

Please get into the concepts of Oracle Data Guard and Role Transitions first. This issue is based on that and your understanding of it (Oracle Documentation Role Transitions).

> Result: 1) Going in infinit loop. No comming out to SQL prompt

Works as designed as well based on your used SQL command "alter database recover managed standby database". Please check the official Oracle Documentation about the "ALTER DATABASE RECOVER" command and the DISCONNECT option.

Regards

Stefan