天萃荷净
运维DBA在维护Oracle Data Guard时,常用的Physical Standby和Snapshot Standby切换步骤与注意事项
Physical Standby Database and Snapshot Standby Database
1.Converting a Physical Standby Database into a Snapshot Standby Database
shutdown immedaite
startup mount
ALTER DATABASE CONVERT TO SNAPSHOT STANDBY;
alter database open;
2.Converting a Snapshot Standby Database into a Physical Standby Database
shutdown immedaite
startup mount
ALTER DATABASE CONVERT TO PHYSICAL STANDBY;
alter database open;--如果出现ORA-01507: database not mounted,重启数据库
alter database recover managed standby database disconnect from session;
alter database recover managed standby database using current logfile disconnect from session;
--------------------------------------ORACLE-DBA----------------------------------------
最权威、专业的Oracle案例资源汇总之学习笔记:Oracle Data Guard Physical Standby和Snapshot Standby切换案例