top of page
Writer's pictureblkrishnarao

Convert Snapshot Standby to Physical Standby | Oracle Database

Updated: Apr 16

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


If you are currently running the Standby database in Snapshot Mode and want to put it back in Physical standby perform the below:


ShutDown And Bring up in Mount State

shut immediate
startup mount;

Convert Database to Physical Standby

alter database convert to physical standby;
shut immediate;
startup;
select status,instance_name,database_role,open_mode from v$database,v$Instance;

Re-sync Standby And Primary Database

alter database recover managed standby database disconnectfrom session;
select process,status,sequence# from v$managed_standby;

1 view0 comments

Recent Posts

See All

Comments


bottom of page