学习笔记:Oracle Data Guard Physical Standby和Snapshot Standby切换案例

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切换案例

本文由大师惜分飞原创分享，网址：http://www.oracleplus.net/arch/514.html

Oracle研究中心

关键词：

Oracle Data Guard

Physical Standby和Snapshot Standby切换案例