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都没有资料。。。