启动顺序：先启动备库，后启动主库
关闭顺序：先关闭主库，后关闭备库

1.正确关闭备库和主库http://www.cndba.cn/hbhe0316/article/4731

主库
SQL>SHUTDOWN IMMEDIATE;
备库:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL>SHUTDOWN IMMEDIATE;

2.正确打开备库和主库

备库:
--先启备库
lsnrctl start
sql>startup nomount
sql>alter database mount standby database;
sql>alter database open read only;
sql>alter database recover managed standby database using current logfile disconnect from session;
主库:
lsnrctl start
SQL> STARTUP;

版权声明：本文为博主原创文章，未经博主允许不得转载。

Linux,oracle