1,将ADG切换至Snapshot Standby
sqlplus / as sysdba
recover managed standby database cancel;
ALTER DATABASE CONVERT TO SNAPSHOT STANDBY;
alter database open;
exit
2,将Snapshot Standby切换至ADG
sqlplus / as sysdba
shutdown immediate;
startup mount;
ALTER DATABASE CONVERT TO PHYSICAL STANDBY;
shutdown immediate;
startup;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
exit