- 概要步骤
#关闭顺序：
1:先关闭主库
2:暂停备库redo应用
3:后关闭备库
4:关闭OS
#启动顺序：
1:先启动备库
2:后启动主库
3:启动备库redo应用
- 具体步骤如下(关闭)
#关闭顺序：
1:先关闭主库
[oracle@XAG191 ~]$ sqlplus / as sysdba
SQL> shutdown immediate;
SQL> exit
[oracle@XAG191 ~]$ lsnrctl stop
[oracle@XAG191 ~]$ systemctl poweroff -i
2:暂停备库redo应用
[oracle@XAG192 ~]$ sqlplus / as sysdba
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
3:后关闭备库
SQL> SHUTDOWN IMMEDIATE;
SQL> exit
[oracle@XAG192 ~]$ lsnrctl stop
4:关闭OS
[oracle@XAG192 ~]$ systemctl poweroff -i
- 具体步骤如下(启动)
1:先启动备库
[oracle@XAG192 ~]$ lsnrctl start
[oracle@XAG192 ~]$ sqlplus / as sysdba
SQL> startup
2:后启动主库
[oracle@XAG191 ~]$ lsnrctl start
[oracle@XAG191 ~]$ sqlplus / as sysdba
SQL> startup;
3:启动备库应用
[oracle@XAG192 ~]$ sqlplus / as sysdba
#開啟實時日誌應用
SQL> alter database recover managed standby database using current logfile disconnect from session;
SQL> select database_role,protection_mode,open_mode from v$database;
DATABASE_ROLE PROTECTION_MODE OPEN_MODE
---------------- -------------------- --------------------
PHYSICAL STANDBY MAXIMUM PERFORMANCE READ ONLY WITH APPLY
#check,查看归档是否及时应用 （备库）
SQL> SELECT sequence#,applied FROM v$archived_log;
SEQUENCE# APPLIED
---------- ---------
9 YES
8 YES
10 YES
11 YES
12 YES
13 YES
15 YES
14 YES
8 rows selected.
#如果发现全部都是YES，证明归档日志已经在同步
#检查主库
[oracle@XAG191 ~]$ sqlplus / as sysdba
SQL> select database_role,protection_mode,open_mode from v$database;
DATABASE_ROLE PROTECTION_MODE OPEN_MODE
---------------- -------------------- --------------------
PRIMARY MAXIMUM PERFORMANCE READ WRITE
