10g standby alert error:
Sun Oct 12 22:21:27 2014
FAL[client]: Failed to request gap sequence
GAP - thread 2 sequence 189587-189686
DBID 1036472754 branch 721688370
FAL[client]: All defined FAL servers have been attempted.
-------------------------------------------------------------
Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization
parameter is defined to a value that is sufficiently large
enough to maintain adequate log switch information to resolve
archivelog gaps.
-------------------------------------------------------------
Sun Oct 12 22:25:07 2014
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
check primary
SQL>
SQL>
SQL> select DEST_ID,SEQUENCE#,DELETED,APPLIED,ARCHIVED from v$archived_log b
2 where b.SEQUENCE#>=189587 and b.THREAD#=2 and b.SEQUENCE#<=189696 and b.DEST_ID=1;
DEST_ID SEQUENCE# DEL APP ARC
---------- ---------- --- --- ---
1 189587 YES NO YES
1 189588 YES NO YES
1 189601 YES NO YES
1 189602 YES NO YES
1 189603 YES NO YES
:::
1 189696 YES NO YES
110 rows selected.
catalog required archivelog
archive log filename=/arch/busdb/archlog2/2_189587_721688370.dbf recid=1532183 stamp=860799060
RMAN>
cataloged archive log
SQL> alter system set log_archive_dest_state_2=defer sid='busdb2';
System altered.
SQL> alter system set log_archive_dest_state_2=ALTERNATE sid='busdb2';
System altered.
SQL>
SQL> l
1 select DEST_ID,SEQUENCE#,DELETED,APPLIED,ARCHIVED from v$archived_log b
2* where b.SEQUENCE#>=189587 and b.THREAD#=2 and b.SEQUENCE#<=189696 and b.DEST_ID=1
SQL> /
DEST_ID SEQUENCE# DEL APP ARC
---------- ---------- --- --- ---
1 189695 YES NO YES
1 189696 YES NO YES
DEST_ID SEQUENCE# DEL APP ARC
---------- ---------- --- --- ---
1 189587 NO NO YES
111 rows selected.
SQL>
standby alert
Sun Oct 12 22:46:36 2014
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[9]: Assigned to RFS process 716836
RFS[9]: Identified database type as 'physical standby'
RFS[9]: Archived Log: '/arch/busdb/archlog/2_189587_721688370.dbf'
Sun Oct 12 22:46:41 2014
Media Recovery Log /arch/busdb/archlog/2_189587_721688370.dbf
Media Recovery Waiting for thread 2 sequence 189588
Fetching gap sequence in thread 2, gap sequence 189588-189687
Sun Oct 12 22:47:46 2014
FAL[client]: Failed to request gap sequence
GAP - thread 2 sequence 189588-189687 <<< 提示为189588,不再是189587
DBID 1036472754 branch 721688370
FAL[client]: All defined FAL servers have been attempted.