DG 检查

SQL> SELECT MESSAGE FROM V$DATAGUARD_STATUS;（主库执行）
正常的时候
LNS: Standby redo logfile selected for thread 1 sequence 1171 for destination LOG_ARCHIVE_DEST_2
LNS: Standby redo logfile selected for thread 1 sequence 1172 for destination LOG_ARCHIVE_DEST_2
ARC1: Standby redo logfile selected for thread 1 sequence 1170 for destination LOG_ARCHIVE_DEST_2
ARC1: Standby redo logfile selected for thread 1 sequence 1171 for destination LOG_ARCHIVE_DEST_2
LNS: Standby redo logfile selected for thread 1 sequence 1173 for destination LOG_ARCHIVE_DEST_2
FAL[server]: Fail to queue the whole FAL gap
GAP - thread 1 sequence 1172-1172
DBID 873792288 branch 696189603
ARC1: Standby redo logfile selected for thread 1 sequence 1172 for destination LOG_ARCHIVE_DEST_2
LNS: Standby redo logfile selected for thread 1 sequence 1174 for destination LOG_ARCHIVE_DEST_2
ARC1: Standby redo logfile selected for thread 1 sequence 1173 for destination LOG_ARCHIVE_DEST_2

MESSAGE
------------------------------------------------------------------------------------------------------------------------------------------------------
LNS: Standby redo logfile selected for thread 1 sequence 1175 for destination LOG_ARCHIVE_DEST_2
LNS: Standby redo logfile selected for thread 1 sequence 1176 for destination LOG_ARCHIVE_DEST_2
LNS: Standby redo logfile selected for thread 1 sequence 1177 for destination LOG_ARCHIVE_DEST_2
ARCH: Possible network disconnect with primary database



出问题后：
MESSAGE
------------------------------------------------------------------------------------------------------------------------------------------------------
LNS: Standby redo logfile selected for thread 1 sequence 1204 for destination LOG_ARCHIVE_DEST_2
LNS: Standby redo logfile selected for thread 1 sequence 1205 for destination LOG_ARCHIVE_DEST_2
LNS: Standby redo logfile selected for thread 1 sequence 1206 for destination LOG_ARCHIVE_DEST_2
LNS: Standby redo logfile selected for thread 1 sequence 1207 for destination LOG_ARCHIVE_DEST_2
LNS: Standby redo logfile selected for thread 1 sequence 1208 for destination LOG_ARCHIVE_DEST_2
LNS: Standby redo logfile selected for thread 1 sequence 1209 for destination LOG_ARCHIVE_DEST_2
FAL[server]: Fail to queue the whole FAL gap
GAP - thread 1 sequence 1208-1208
DBID 873792288 branch 696189603
LNS: Standby redo logfile selected for thread 1 sequence 1210 for destination LOG_ARCHIVE_DEST_2
LNS: Standby redo logfile selected for thread 1 sequence 1211 for destination LOG_ARCHIVE_DEST_2

MESSAGE
------------------------------------------------------------------------------------------------------------------------------------------------------
LNS: Standby redo logfile selected for thread 1 sequence 1212 for destination LOG_ARCHIVE_DEST_2
LNS: Standby redo logfile selected for thread 1 sequence 1213 for destination LOG_ARCHIVE_DEST_2
LNS: Standby redo logfile selected for thread 1 sequence 1214 for destination LOG_ARCHIVE_DEST_2





丢了 ARC1: Standby redo logfile selected for thread 1 sequence 这样的信息了









主库：
SQL> SELECT min(SEQUENCE#), max(SEQUENCE#) FROM V$ARCHIVED_LOG where applied = 'YES';     

MIN(SEQUENCE#) MAX(SEQUENCE#)
-------------- --------------
          1140           1173
备库：
         
SQL> SELECT min(SEQUENCE#), max(SEQUENCE#) FROM V$ARCHIVED_LOG where applied = 'YES';

MIN(SEQUENCE#) MAX(SEQUENCE#)
-------------- --------------
          1100           1211
         
     
     
主库         
SQL> select dest_name,status from v$archive_dest;

DEST_NAME            STATUS
-------------------- ---------
LOG_ARCHIVE_DEST_1   VALID
LOG_ARCHIVE_DEST_2   VALID
LOG_ARCHIVE_DEST_3   INACTIVE
LOG_ARCHIVE_DEST_4   INACTIVE
LOG_ARCHIVE_DEST_5   INACTIVE
LOG_ARCHIVE_DEST_6   INACTIVE
LOG_ARCHIVE_DEST_7   INACTIVE
LOG_ARCHIVE_DEST_8   INACTIVE
LOG_ARCHIVE_DEST_9   INACTIVE
LOG_ARCHIVE_DEST_10  INACTIVE
STANDBY_ARCHIVE_DEST VALID

11 rows selected.   





SQL> show parameter log_archive_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest                     string
log_archive_dest_1                   string      location=/oracle/oradata/produ
                                                 ct/arch/ valid_for=(all_logfil
                                                 es,all_roles) db_unique_name=s
                                                 td
log_archive_dest_10                  string
log_archive_dest_2                   string      service=pri lgwr async valid_f
                                                 or=(online_logfile,primary_rol
                                                 e) db_unique_name=pri






主
SQL> select PROCESS ,STATUS from v$managed_standby;

PROCESS   STATUS
--------- ------------
ARCH      CLOSING
ARCH      CLOSING
LNS       WRITING


SQL> select PROCESS ,STATUS from v$managed_standby;

PROCESS   STATUS
--------- ------------
ARCH      CLOSING
ARCH      CLOSING
MRP0      WAIT_FOR_GAP
RFS       IDLE