1、在备库检查日志缺失
FAL[client]: Failed to request gap sequence
GAP - thread 1 sequence53415-53434
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.
2 在主库中查询缺失的日志的所在路径和名称
SQL>SELECT NAME FROM V$ARCHIVED_LOG WHERE THREAD#=1 AND DEST_ID=1 AND SEQUENCE# BETWEEN 99 AND 109;
3 拷贝到备库的相应目录
oracle@p1a:/home/oracle/arch>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>scp orcl_53717_710350416.log ss1:/home/oracle/archive_gap/
oracle@ss1's password:
4 手工注册日志文件。
SQL> ALTER DATABASE REGISTER LOGFILE '/home/oracle/archive_gap/orcl_53415_710350416.log';
Database altered.
SQL> ALTER DATABASE REGISTER LOGFILE '/home/oracle/archive_gap/orcl_53416_710350416.log';
Database altered.
SQL> ALTER DATABASE REGISTER LOGFILE '/home/oracle/archive_gap/orcl_53417_710350416.log';
Database altered.
。。。。。。。。。
SQL> ALTER DATABASE REGISTER LOGFILE '/home/oracle/archive_gap/orcl_53432_710350416.log';
Database altered.
SQL> ALTER DATABASE REGISTER LOGFILE '/home/oracle/archive_gap/orcl_53433_710350416.log';
Database altered.
SQL> ALTER DATABASE REGISTER LOGFILE '/home/oracle/archive_gap/orcl_53434_710350416.log';
Database altered.
5 查看告警日志
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'
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
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
6 再次查看
SQL> select * from v$archive_gap;
no rows selected
One Response