sitemap

RSS地图

收藏本站

设为首页

Oracle研究中心

当前位置:Oracle研究中心 > 产品DBA > Oracle DG >

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

时间:2016-06-24 12:40   来源:Oracle研究中心   作者:惜分飞   点击:

天萃荷净 运维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切换案例

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

Oracle研究中心

关键词:

Oracle Data Guard

Physical Standby和Snapshot Standby切换案例