一、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