DG备库一直报:No standby redo logfiles available for thread 1
检查日志应用,是同步的,
但检查
select process,status from v$managed_standby;
状态没有为 以下:
MRP0 APPLYING_LOG
重启备库:
报警日志一直在报:
Errors in file /u01/app/oracle/diag/rdbms/db1/db1/trace/db1_lgwr_3404.trc:
ORA-00313: open failed for members of log group 8 of thread 1
ORA-00312: online log 8 thread 1: ‘/u01/app/oracle/oradata/db1/logfile/standbylog08.log’
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
select member from v$logfile;
…
/u01/app/oracle/oradata/db1/logfile/standbylog08.log
…
但磁盘上
ls -ltr /u01/app/oracle/oradata/db1/logfile/standbylog08.log
但发现以下文件:
/u01/app/oracle/oradata/db1/logfile/standbylog087.log
确实不存在,估计被人修改了。
停用日志应用,重新创建对应的备用日志文件
alter database recover managed standby cancel;
alter database drop logfile group 8;
alter database add standby logfile group 8 ‘/u01/app/oracle/oradata/db1/logfile/standbylog08.log’ size 50m;
alter database recover managed standby using current logfile disconnect from session;
之后,不再报错。
备注:
以上问题环境:ORACLE 11.2.0.4+RHEL7.8