oracle DataGuard停机和启动顺序

一、停机

1、先关闭主库

--登录数据库
sqlplus / as sysdba

sql>shutdown immediate

 

2、再关闭备库

--登录数据库
sqlplus / as sysdba

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

二、启动

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