也可以执行如下步骤来解决此问题: 1 如果主库和备库的日志归档位置不一样,检查和设置log_file_name_convert 参数。 SQL> alter system set log_file_name_convert = "'',''" scope=spfile; If you are using pfile then set the parameter in init file after shutting down the database: 如果使用了pfil...
备库报 ORA-00313、ORA-00312、ORA-27037,备库alert日志如下:Errorsinfile/data/app/oracle/diag/rdbms/standby/orcl/trace/orcl_m000_31006.trc:ORA-00313:openfailedformembersofloggroup3ofthr
ORA-00313, ORA-00312, ORA-27037 in Standby Database [ID 601835.1] Modified20-APR-2009TypePROBLEMStatusMODERATED In this Document Symptoms Cause Solution References This document is being delivered to you via Oracle Support's ...
ORA-27037: unable to obtain file statusLinux Error: 2: No such file or directoryAdditional information: 3Errors in file /u02/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_ora_14799.trc:ORA-00313: open failed for members of log group 2 of thread 1ORA-00312: online log 2 thread 1: '/...
ORA-00313: open failed for members of log group 9 of thread 1 ORA-00312: online log 9 thread 1: '/data/onlineredo/group_9.265.1176307293' ORA-27037: unable to obtain file status ... 报错的,不只是这一个redo文件。有很多,只是截取这一个,用来体现日志中报错信息。 下面开始分析。3. 问题...
ORA-00313, ORA-00312, ORA-27037 in Standby Database [ID 601835.1] Modified 20-APR-2009Type PROBLEMStatus MODERATED In this Document
ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 7 ORA-00312: online log 7 thread 1: '/u01/app/oracle/oradata/ORCL/onlinelog/redolog8.log' ORA-27037: unable to obtain file status ...
ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 7 ORA-00312: online log 7 thread 1: /u01/app/oracle/oradata/ORCL/onlinelog/redolog8.log ORA-27037: unable to obtain file status ...
备库报 ORA-00313、ORA-00312、ORA-27037 备库alert日志如下:Errors in file /data/app/oracle/diag/rdbms/standby/orcl/trace/orcl_m000_31006.trc:ORA-00313: open failed for members of log group 3 of thread 1ORA-00312: online log 3 thread 1: '/data/oradata/orcl/redo03.log'ORA-27037: ...
ORA-27037: unable to obtain file status 原因: 备库上缺少联机重做日志 解决方法: 可以忽略此错误,因为联机重做日志会在switch over 或者 failover的时候自动建立! If you want to fix these messages then please use following steps: 也可以执行如下步骤来解决此问题: ...