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;