DG备库报：No standby redo logfiles available for thread 1

郑全

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