Convert Physical standby to Active standby database

Active Standby database ( 11gR1 Feature):

-- A physical standby database which is in OPEN READ ONLY mode is called as Active Standby database.

-- We can convert the Physical standby to Logical standby as below

-- STEP1: Stop the MRP

-- STEP2:  Open the database in read only mode

-- STEP3:  Start the MRP 

-- Advantage of Active Data guard is standby can serve the DRL ( SELECT ) statements , while currently being synchronized with the primary by the MRP.

STANDBY DB SERVER:

sql>select open_mode, protection_mode, database_role from v$database;

sql>recover managed standby database cancel;    ( STOP MRP )

sql>show database recover

sql>alter database open read only;

sql>recover managed standby database disconnect from session using current logfile;     (START MRP)

sql>select open_mode, protection_mode, database_role from v$database;


---  Now the standby database is in READ ONLY mode. so, we can perform SELECT operations on database ( data can be retrived only but not updated).


sql>select * from scott.emp;

Convert Active standby to Physical standby database

sql>select open_mode, protection_mode, database_role from v$database;


sql>shut immediate

sql>startup mount

sql>recover managed standby database disconnect from session using current logfile;


sql>select open_mode, protection_mode, database_role from v$database;