Physical standby to Active data guard

Change Physical standby to Active data guard (Read only) with Apply

Convert Physical Standby Database To Snapshot Database

Verify Snapshot Standby Database

Do Some Testing In Snapshot Database

Convert Snapshot Database Back To Physical Standby Database

SQL> select database_role from v$database;

DATABASE_ROLE

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

PHYSICAL STANDBY

SQL> alter database recover managed standby database cancel;      

Database altered.

SQL> alter database open;

Database altered.

SQL> select database_role from v$database;

DATABASE_ROLE

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

PHYSICAL STANDBY

SQL> select database_role,open_mode from v$database;

DATABASE_ROLE    OPEN_MODE

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

PHYSICAL STANDBY READ ONLY

SQL> alter database recover managed standby database disconnect from session;

Database altered.

SQL> select PROCESS,STATUS from v$managed_standby;

PROCESS   STATUS

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

ARCH      CLOSING

ARCH      CONNECTED

ARCH      CONNECTED

ARCH      CONNECTED

ARCH      CONNECTED

ARCH      CONNECTED

RFS       IDLE

RFS       IDLE

RFS       IDLE

PROCESS   STATUS

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

RFS       IDLE

MRP0      WAIT_FOR_LOG

35 rows selected.

SQL> select database_role,open_mode from v$database;

DATABASE_ROLE    OPEN_MODE

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

PHYSICAL STANDBY READ ONLY WITH APPLY

[oracle@standby ~]$ ps -ef | grep mrp

oracle   17877     1  0 01:03 ?        00:00:00 ora_mrp0_sbyprod

oracle   17919 17896  0 01:04 pts/2    00:00:00 grep mrp

*************************************************

Return to recovery mode from Read only

*************************************************

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area  651378688 bytes

Fixed Size                  2216184 bytes

Variable Size             390074120 bytes

Database Buffers          255852544 bytes

Redo Buffers                3235840 bytes

Database mounted.

SQL> alter database recover managed standby database disconnect from session;

Database altered.

SQL> archive log list

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            /u01/app/oracle/flash_recovery_area/sbyprod/

Oldest online log sequence     32

Next log sequence to archive   0

Current log sequence           34

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

enable real-time apply of redo 

sql>alter database recover managed standby database using current logfile disconnect;