Oracle DataGuard启动与关闭顺序

Oracle DataGuard启动与关闭顺序

(一)Active DataGuard启动顺序
(1)启动监听,先启从库再起主库

lsnrctl start

(2)启动数据库,先启动备库在启主库

复制代码

--先启备库 sql>startup nomount sql>alter database mount standby database; sql>alter database open; sql>alter database recover managed standby database using current logfile disconnect from session; --再启主库 sql>startup

复制代码

(二)DataGuard关闭顺序
(1)先关主库数据库:

sql>shutdown immediate

(2)再关备用库:

sql>alter database recover managed standby database cancel; --停止同步 sql>shutdown immediate;

分类: ----150 DataGuard

评论

暂无评论