Failed to request gap sequence

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.


  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值