【DATAGUARD】手工恢复备库日志中断

<b>1、在备库检查日志缺失</b>

FAL[client]: Failed to request gap sequence

 GAP - thread 1 sequence <b>53415-53434</b>

 DBID 424533136 branch 710350416

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.

<b>2 在主库中查询缺失的日志的所在路径和名称</b>

SQL&gt;SELECT NAME FROM V$ARCHIVED_LOG WHERE THREAD#=1 AND DEST_ID=1 AND SEQUENCE# BETWEEN 99 AND 109;

<b>3 拷贝到备库的相应目录</b>

oracle@p1a:/home/oracle/arch&gt;scp orcl_53716_710350416.log ss1:/home/oracle/archive_gap/

oracle@ss1's password: 

orcl_53716_710350416.log                                                                                                         100%  389MB  35.3MB/s   00:11    

oracle@p1a:/home/oracle/arch&gt;scp orcl_53717_710350416.log ss1:/home/oracle/archive_gap/

<b></b>

<b>4 手工注册日志文件。</b>

SQL&gt; ALTER DATABASE REGISTER LOGFILE '/home/oracle/archive_gap/orcl_53415_710350416.log';

Database altered.

SQL&gt; ALTER DATABASE REGISTER LOGFILE '/home/oracle/archive_gap/orcl_53416_710350416.log';

SQL&gt; ALTER DATABASE REGISTER LOGFILE '/home/oracle/archive_gap/orcl_53417_710350416.log';

。。。。。。。。。

SQL&gt; ALTER DATABASE REGISTER LOGFILE '/home/oracle/archive_gap/orcl_53432_710350416.log';

SQL&gt; ALTER DATABASE REGISTER LOGFILE '/home/oracle/archive_gap/orcl_53433_710350416.log';

SQL&gt; ALTER DATABASE REGISTER LOGFILE '/home/oracle/archive_gap/orcl_53434_710350416.log';

<b>5 查看告警日志</b>

ALTER DATABASE REGISTER LOGFILE '/home/oracle/archive_gap/orcl_53415_710350416.log'

There are 1 logfiles specified.

ALTER DATABASE REGISTER [PHYSICAL] LOGFILE

Completed: ALTER DATABASE REGISTER LOGFILE '/home/oracle/archive_gap/orcl_53415_710350416.log'

Tue Aug 23 11:58:34 2011

Media Recovery Delayed for 1440 minute(s) (thread 1 sequence 53415)

Tue Aug 23 12:00:26 2011

ALTER DATABASE REGISTER LOGFILE '/home/oracle/archive_gap/orcl_53416_710350416.log'

Resynchronizing thread 1 from sequence 53415 to 53416

Completed: ALTER DATABASE REGISTER LOGFILE '/home/oracle/archive_gap/orcl_53416_710350416.log'

Media Recovery Log /home/oracle/archive_gap/orcl_53416_710350416.log

Tue Aug 23 12:12:36 2011

RFS[2]: Selected log 31 for thread 1 sequence 53837 dbid 424533136 branch 710350416

Tue Aug 23 12:12:42 2011

RFS[1]: Selected log 32 for thread 2 sequence 36957 dbid 424533136 branch 710350416

Tue Aug 23 12:12:43 2011

Media Recovery Log /home/oracle/archive_gap/orcl_53417_710350416.log

Tue Aug 23 12:13:10 2011

<b>6 再次查看 </b>

SQL&gt; select * from v$archive_gap;

no rows selected