Failed to request gap sequence

最新推荐文章于 2024-03-21 00:45:06 发布

songyb

最新推荐文章于 2024-03-21 00:45:06 发布

阅读量2.8k

点赞数

分类专栏： Troubleshoot

本文链接：https://blog.csdn.net/songyongbo_107/article/details/41311183

版权

Troubleshoot 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

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.