oracle dg standbylog丢失案例

最新推荐文章于 2023-12-22 07:53:07 发布

原创

最新推荐文章于 2023-12-22 07:53:07 发布 · 1k 阅读

0 ·

CC 4.0 BY-SA版权

在配置Oracle Data Guard从库后，alert日志显示ORA-00313错误，表明在线日志文件10丢失。错误详细信息包含文件不存在的Linux错误。为解决此问题，需停止同步，执行`alter database recover managed standby database cancel;`，然后进行后续修复操作。

在搭建完从库后，在alert中出现下面的提示
Errors in file /home/oracle/app/diagxxxxrc:
ORA-00313: open failed for members of log group 10 of thread 1
ORA-00312: online log 10 thread 1: ‘xxxstdby02a.log’
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 10 thread 1: ‘xxxstdby02b.log’
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
提示standby的日志文件丢失

处理：
1停止同步
alter database recover managed standby database cancel;
2

SQL> select group#, dbid, sequence#, archived, status from v$standby_log;

    GROUP# DBID                                          SEQUENCE# ARCHIV STATUS
---------- ------------------------------------------------------------------------