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;
Comments