RAC + DG 搭建归档日志缺失遭遇记
SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;
PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS
--------- ------------ ---------- ---------- ---------- ----------
ARCH CLOSING 2 39 1 9
ARCH CLOSING 1 83 1 94
MRP0 WAIT_FOR_GAP 1 74 0 0 --丢失，而且在RAC主库上也找不到了
RFS IDLE 1 84 18197 1
RFS IDLE 0 0 0 0
RFS IDLE 2 40 8875 25
RFS IDLE 0 0 0 0
7 rows selected.
SQL> select * from v$archive_gap;
THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#
---------- ------------- --------------
1 74 76
2 30 32
SQL> SELECT max(sequence#) from v$archived_log where applied='YES';
MAX(SEQUENCE#)
--------------
--全都没有应用
SQL> select message from v$dataguard_status;
MESSAGE
--------------------------------------------------------------------------------
ARC0: Archival started
ARC1: Archival started
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
ARC1: Becoming the heartbeat ARCH
Attempt to start background Managed Standby Recovery process
MRP0: Background Managed Standby Recovery process started
Managed Standby Recovery not using Real Time Apply
Clearing online redo logfile 1 /u01/app/oracle/oradata/orcl/datafile/group_1.257
.752366993
MESSAGE
--------------------------------------------------------------------------------
Clearing online redo logfile 1 complete
Clearing online redo logfile 2 /u01/app/oracle/oradata/orcl/datafile/group_2.258
.752366993
Clearing online redo logfile 2 complete
Clearing online redo logfile 3 /u01/app/oracle/oradata/orcl/datafile/group_3.265
.752368247
Clearing online redo logfile 3 complete
Clearing online redo logfile 4 /u01/app/oracle/oradata/orcl/datafile/group_4.266
.752368247
MESSAGE
--------------------------------------------------------------------------------
Clearing online redo logfile 4 complete
Media Recovery Waiting for thread 1 sequence 74
MRP0: Background Media Recovery cancelled with status 16037
MRP0: Background Media Recovery process shutdown
Managed Standby Recovery Canceled
Attempt to start background Managed Standby Recovery process
MRP0: Background Managed Standby Recovery process started
Managed Standby Recovery starting Real Time Apply
Media Recovery Waiting for thread 1 sequence 74
Redo Shipping Client Connected as PUBLIC
MESSAGE
--------------------------------------------------------------------------------
-- Connected User is Valid
RFS[1]: Assigned to RFS process 491768
RFS[1]: Identified database type as 'physical standby'
Primary database is in MAXIMUM PERFORMANCE mode
Primary thread 1 already marked as open; setting 'closed'
Primary thread 2 already marked as open; setting 'closed'
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[2]: Assigned to RFS process 475138
RFS[2]: Identified database type as 'physical standby'
Primary database is in MAXIMUM PERFORMANCE mode
MESSAGE
--------------------------------------------------------------------------------
Primary database is in MAXIMUM PERFORMANCE mode
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[3]: Assigned to RFS process 495864
RFS[3]: Identified database type as 'physical standby'
RFS[2]: Successfully opened standby log 5: '/u01/app/oracle/oradata/orcl/datafil
e/redo_st_05.log'
RFS[3]: Successfully opened standby log 6: '/u01/app/oracle/oradata/orcl/datafil
e/redo_st_06.log'
MESSAGE
--------------------------------------------------------------------------------
Fetching gap sequence in thread 1, gap sequence 74-76
Error 12521 received logging on to the standby
FAL[client, MRP0]: Error 12521 connecting to orcl2 for fetching gap sequence
Error 12521 received logging on to the standby
FAL[client, MRP0]: Error 12521 connecting to orcl2 for fetching gap sequence
Error 12521 received logging on to the standby
FAL[client, MRP0]: Error 12521 connecting to orcl2 for fetching gap sequence
Error 12521 received logging on to the standby
FAL[client, MRP0]: Error 12521 connecting to orcl2 for fetching gap sequence
Error 12528 received logging on to the standby
FAL[client, MRP0]: Error 12528 connecting to orcl2 for fetching gap sequence
MESSAGE
--------------------------------------------------------------------------------
FAL[client]: Failed to request gap sequence
GAP - thread 1 sequence 74-76
DBID 1280194524 branch 752413788
FAL[client]: All defined FAL servers have been attempted.
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[4]: Assigned to RFS process 491538
RFS[4]: Identified database type as 'physical standby'
Primary database is in MAXIMUM PERFORMANCE mode
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
MESSAGE
--------------------------------------------------------------------------------
RFS[5]: Assigned to RFS process 466972
RFS[5]: Identified database type as 'physical standby'
Primary database is in MAXIMUM PERFORMANCE mode
Primary database is in MAXIMUM PERFORMANCE mode
RFS[5]: Successfully opened standby log 8: '/u01/app/oracle/oradata/orcl/datafil
e/redo_st_08.log'
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[6]: Assigned to RFS process 487430
RFS[6]: Identified database type as 'physical standby'
MESSAGE
--------------------------------------------------------------------------------
RFS[6]: Successfully opened standby log 9: '/u01/app/oracle/oradata/orcl/datafil
e/redo_st_09.log'
Primary database is in MAXIMUM PERFORMANCE mode
RFS[2]: Successfully opened standby log 5: '/u01/app/oracle/oradata/orcl/datafil
e/redo_st_05.log'
Primary database is in MAXIMUM PERFORMANCE mode
RFS[5]: Successfully opened standby log 8: '/u01/app/oracle/oradata/orcl/datafil
e/redo_st_08.log'
MESSAGE
--------------------------------------------------------------------------------
Primary database is in MAXIMUM PERFORMANCE mode
RFS[2]: Successfully opened standby log 5: '/u01/app/oracle/oradata/orcl/datafil
e/redo_st_05.log'
Primary database is in MAXIMUM PERFORMANCE mode
RFS[2]: Successfully opened standby log 5: '/u01/app/oracle/oradata/orcl/datafil
e/redo_st_05.log'
Primary database is in MAXIMUM PERFORMANCE mode
RFS[5]: Successfully opened standby log 8: '/u01/app/oracle/oradata/orcl/datafil
e/redo_st_08.log'
MESSAGE
--------------------------------------------------------------------------------
Primary database is in MAXIMUM PERFORMANCE mode
RFS[5]: Successfully opened standby log 8: '/u01/app/oracle/oradata/orcl/datafil
e/redo_st_08.log'
Primary database is in MAXIMUM PERFORMANCE mode
RFS[5]: Successfully opened standby log 8: '/u01/app/oracle/oradata/orcl/datafil
e/redo_st_08.log'
Primary database is in MAXIMUM PERFORMANCE mode
RFS[2]: Successfully opened standby log 5: '/u01/app/oracle/oradata/orcl/datafil
MESSAGE
--------------------------------------------------------------------------------
e/redo_st_05.log'
Primary database is in MAXIMUM PERFORMANCE mode
RFS[2]: Successfully opened standby log 5: '/u01/app/oracle/oradata/orcl/datafil
e/redo_st_05.log'
Primary database is in MAXIMUM PERFORMANCE mode
RFS[5]: Successfully opened standby log 8: '/u01/app/oracle/oradata/orcl/datafil
e/redo_st_08.log'
Primary database is in MAXIMUM PERFORMANCE mode
MESSAGE
--------------------------------------------------------------------------------
RFS[5]: Successfully opened standby log 8: '/u01/app/oracle/oradata/orcl/datafil
e/redo_st_08.log'
Primary database is in MAXIMUM PERFORMANCE mode
RFS[2]: Successfully opened standby log 5: '/u01/app/oracle/oradata/orcl/datafil
e/redo_st_05.log'
MRP0: Background Media Recovery cancelled with status 16037
Managed Standby Recovery not using Real Time Apply
MRP0: Background Media Recovery process shutdown
Managed Standby Recovery Canceled
MESSAGE
--------------------------------------------------------------------------------
Attempt to start background Managed Standby Recovery process
MRP0: Background Managed Standby Recovery process started
Managed Standby Recovery starting Real Time Apply
Media Recovery Waiting for thread 1 sequence 74
Fetching gap sequence in thread 1, gap sequence 74-76
FAL[client]: Failed to request gap sequence
GAP - thread 1 sequence 74-76
DBID 1280194524 branch 752413788
FAL[client]: All defined FAL servers have been attempted.
112 rows selected.
SQL> SELECT THREAD#, SEQUENCE#, APPLIED FROM V$ARCHIVED_LOG;
THREAD# SEQUENCE# APP
---------- ---------- ---
1 77 NO
2 33 NO
1 78 NO
2 34 NO
1 79 NO
1 80 NO
2 35 NO
2 36 NO
2 37 NO
1 81 NO
1 82 NO
THREAD# SEQUENCE# APP
---------- ---------- ---
2 38 NO
2 39 NO
1 83 NO
14 rows selected.
Google了好久，都没有找到解决办法，最后只好根据现有的RAC重新RMAN备份，再重新建立了DG。如果网友有别的解决办法，望赐教。
