需要手工register logfile的情况

来源：互联网发布：sql 数据库置疑编辑：程序博客网时间：2024/06/04 23:19

10.2.0.5 on windows 2008 64 bit physical standby

logfile sequence# 101已经传到standby 上，从standby 的v$archived_log里可以看出

select sequence#,archived,applied,status from v$archived_log；

101 YES NO A

在开启MRP前，在primary和standby将logfile 101删除或改名，在primary修改日志明主要是防止其通过FAL重传日志。crosscheck archivelog

select sequence#,archived,applied,status from v$archived_log；

101 YES NO X

alter log日志出现：

FAL[client]: Failed to request gap sequence
GAP - thread 1 sequence 101-101
DBID 2279087842 branch 849630480
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.
-------------------------------------------------------------

这时在standby上把logfile 101恢复回来，但是MRP还是没有主动发现101日志已经回来了，此时是只能手动resgister

SQL> alter database recover managed standby database cancel;

Database altered.

此时MRP就go through the gap ，开始恢复日志。

另外在整个过程中在v$archive_gap都没有资料。。。

0 0