Activate Physical Standby Database

Login to Standby database and run below commands 

 

SQL> select database_role,open_mode,name from gv$database;

DATABASE_ROLE    OPEN_MODE            NAME

---------------- -------------------- ---------

PRIMARY         READ ONLY WITH APPLY  TSTSTDBY

 

SQL> alter database recover managed standby database cancel;

Database altered.

 

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;

Database altered.

 

SQL> ALTER DATABASE ACTIVATE STANDBY DATABASE;

Database altered.

 

SQL> select open_mode from v$database;

OPEN_MODE

--------------------

MOUNTED

 

SQL>  select database_role,open_mode,name from gv$database;

DATABASE_ROLE    OPEN_MODE            NAME

---------------- -------------------- ---------

PRIMARY          MOUNTED              TSTSTDBY

 

SQL> alter database open;

Database altered.

 

SQL> select database_role,open_mode,name from gv$database;

DATABASE_ROLE    OPEN_MODE            NAME

---------------- -------------------- ---------

PRIMARY          READ WRITE           TSTSTDBY