oracle 的ADG,oracle ADG启动顺序

一、oracle ADG启动顺序

1.启动主备库监听

[oracle@dgdb1 ~]$ lsnrctl start

[oracle@dgdb2 ~]$ 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;

3.启动主库

SQL> startup

4.切换主库日志

SQL> alter system switch logfile;

此时备库就会开始应用主库传输过来的归档日志

Mon Nov 11 16:03:22 2019

Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

RFS[1]: Assigned to RFS process 2876

RFS[1]: Selected log 5 for thread 1 sequence 22 dbid 1233426471 branch 1023461799

Mon Nov 11 16:03:23 2019

Archived Log entry 12 added for thread 1 sequence 22 ID 0x49842c27 dest 1:

Mon Nov 11 16:03:27 2019

Fetching gap sequence in thread 1, gap sequence 20-21

RFS[1]: Opened log for thread 1 sequence 21 dbid 1233426471 branch 1023461799

Archived Log entry 13 added for thread 1 sequence 21 rlc 1023461799 ID 0x49842c27 dest 2:

Mon Nov 11 16:03:28 2019

RFS[2]: Assigned to RFS process 2884

RFS[2]: Selected log 4 for thread 1 sequence 20 dbid 1233426471 branch 1023461799

Mon Nov 11 16:03:28 2019

Archived Log entry 14 added for thread 1 sequence 20 ID 0x49842c27 dest 1:

RFS[1]: Selected log 4 for thread 1 sequence 23 dbid 1233426471 branch 1023461799

Mon Nov 11 16:03:31 2019

Archived Log entry 15 added for thread 1 sequence 23 ID 0x49842c27 dest 1:

Mon Nov 11 16:03:31 2019

Primary database is in MAXIMUM PERFORMANCE mode

RFS[3]: Assigned to RFS process 2888

RFS[3]: Selected log 4 for thread 1 sequence 24 dbid 1233426471 branch 1023461799

Mon Nov 11 16:03:38 2019

Media Recovery Log /u01/app/oracle/fast_recovery_area/STDDB/archivelog/2019_11_11/o1_mf_1_20_gwl5gjpf_.arc

Media Recovery Log /u01/app/oracle/fast_recovery_area/STDDB/archivelog/2019_11_11/o1_mf_1_21_gwl5gjl4_.arc

Media Recovery Log /u01/app/oracle/fast_recovery_area/STDDB/archivelog/2019_11_11/o1_mf_1_22_gwl5gc6y_.arc

Media Recovery Log /u01/app/oracle/fast_recovery_area/STDDB/archivelog/2019_11_11/o1_mf_1_23_gwl5gm4j_.arc

Media Recovery Waiting for thread 1 sequence 24 (in transit)

二、oracle ADG关闭顺序

1.关闭主库

SQL> shutdown immediate

2.取消备库应用归档日志

SQL> alter database recover managed standby database cancel;

3.关闭备库

SQL> shutdown immediate

4.关闭主备库监听

[oracle@dgdb1 ~]$ lsnrctl stop

[oracle@dgdb2 ~]$ lsnrctl stop