近期在为一台oracle服务器搭建物理备库时,从库在告警日志中报如下信息:
RFS[3]: Assigned to RFS process 12117
RFS[3]: No standby redo logfiles available for thread 1
RFS[3]: Opened log for thread 1 sequence 56757 dbid 1825607545 branch 833895675
备库standby redo状态全为UNASSIGNED
select GROUP#,THREAD#,SEQUENCE#,ARCHIVED,STATUS from v$standby_log;
status 可以有两种状态,UNASSIGNED和ACTIVE
UNASSIGNED的解释:
ARCHIVED = NO, 表明该standby redo log已经被归档,可再次使用。
ARCHIVED = YES, 表明该standby redo log从未被使用过,处于可用状态。
ACTIVE 的解释:
ARCHIVED = NO, 表明该standby redo log 已完成等待被归档。
ARCHIVED = YES, 表明该 standby redo log 正在被写入所以不能被归档.。对于任一给定线程,应该只有一个 standby redo log 处于该状态。
解决方法可以重建从库的standby log,重建standby log的步骤如下。
(1)取消备库的实时应用
alter database recover managed standby database cancel;
(2)删除standby log日志组
alter database drop standby logfile group 7;
alter database drop standby logfile group 8;
alter database drop standby logfile group 9;
alter database drop standby logfile group 10;
alter database drop standby logfile group 11;
alter database drop standby logfile group 12;
alter database drop standby logfile group 13;
alter database drop standby logfile group 14;
(3)重建standby log
alter database add standby logfile thread 1 group 7 '/U01/app/oracle/fra/test/onlinelog/standbylog07.log' size 100m reuse;
alter database add standby logfile thread 1 group 8 '/U01/app/oracle/fra/test/onlinelog/standbylog08.log' size 100m reuse;
alter database add standby logfile thread 1 group 9 '/U01/app/oracle/fra/test/onlinelog/standbylog09.log' size 100m reuse;
alter database add standby logfile thread 1 group 10 '/U01/app/oracle/fra/test/onlinelog/standbylog10.log' size 100m reuse;
alter database add standby logfile thread 1 group 11 '/U01/app/oracle/fra/test/onlinelog/standbylog11.log' size 100m reuse;
alter database add standby logfile thread 1 group 12 '/U01/app/oracle/fra/test/onlinelog/standbylog12.log' size 100m reuse;
alter database add standby logfile thread 1 group 13 '/U01/app/oracle/fra/test/onlinelog/standbylog13.log' size 100m reuse;
alter database add standby logfile thread 1 group 14 '/U01/app/oracle/fra/test/onlinelog/standbylog14.log' size 100m reuse;
(4)开启备库的实时应用
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;
(5)查看备库的告警日志,看是否还有该信息。