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
D BID 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
正常的时候
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
D BID 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