Convert Physical Standby to Snapshot Standby Database | Oracle Database

The following opinions expressed in this post are my own and in no way connected to my employer. 

If you are currently running your database in physical standby and want to convert it to snapshot standby, you can use below to perform the same:

Check Current DB Role and sync status at Standby Database

select status,instance_name,database_role,open_mode from v$database,v$Instance;

select process,status,sequence# from v$managed_standby;

Cancel Sync between primary and Standby

alter database recover managed standby database cancel;

Shutdown database and Bring up in Mount State

shut immediate

startup mount

Convert to Snapshot Standby

alter database convert to snapshot standby;

alter database open;

select status,instance_name,database_role,open_mode from v$database,v$Instance;