Convert Physical Standby Database into snap shot mode

Convert Physical Standby Database into snap shot mode

1)

SQL> select name,open_mode,controlfile_type,database_role from v$database;

NAME      OPEN_MODE            CONTROL DATABASE_ROLE

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

EASYDB      MOUNTED              STANDBY PHYSICAL STANDBY

check show parameter recover and check the space in path

2) alter database recover managed standby database cancel;

3.

##Check if Flashback is enabled.

select flashback_on from v$database;

alter database flashback on;

select flashback_on from v$database;------

4.

###convert db to snapshot standby and open db 

alter database convert to snapshot standby;

ALTER DATABASE OPEN;

===================================================================================revert===========================================

##once app testing is completed and confirmed by apps team

##shutdown DR , restart it and convert to physical standby

shut immediate

startup mount    cat the script mount and open wallet

(check the wallet status)

col WRL_PARAMETER for a35

select * from V$ENCRYPTION_WALLET; ----status should be open 

alter database convert to physical standby;

shut immediate

run manually db with below script 

/oraEASYDB/EASYDB/admin/startup_scripts----------start_EASYDB_as_STANDBY.sh---ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY "EASYDB12345678";

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

Once dc-dr IS IN SYNC do below step in DR

alter database flashback off;

==============================