DataGuard关闭和启动顺序(正确).txt

如有DataGuard问题欢迎撩 chenyh828

=====================================DataGuard关闭和启动顺序：正确
$ sqlplus / as sysdba
关闭顺序(先主后从)： 
备库:SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
先关闭主primary: shutdown immediate; 后关闭备从standby: shutdown immediate;

启动顺序(先从后主)： 
$ lsnrctl start 
先从standby: startup nomount; 后主primary: startup;
先从standby: startup mount;   后主primary: startup mount;
先从standby: startup nomount; 后主primary: startup mount;  --最佳,可防止日志报tns错误
备库启动应用归档状态:
SQL> alter database mount standby database;
SQL> alter database open;    --先主后从
SQL> select open_mode,database_role from v$database;
OPEN_MODE            DATABASE_ROLE
-------------------- ----------------
READ ONLY            PHYSICAL STANDBY
SQL> alter database recover managed standby database using current logfile disconnect;  --启动MRP0进程
SQL> select open_mode,database_role from v$database;
OPEN_MODE            DATABASE_ROLE
-------------------- ----------------
READ ONLY WITH APPLY PHYSICAL STANDBY

--查看（备库）是否存在RFS和MRP进程，（主库）是否存在LNS进程
SQL> select process,group#,thread#,sequence# from gv$managed_standby;