Open Resetlogs Reports Errors ORA-00313 and ORA-00312 to Alert_1366482.1

rongshiyuan發表於2014-05-14
Error

Open Resetlogs Reports Errors ORA-00313 and ORA-00312 to Alert (Doc ID 1366482.1)


In this Document

Symptoms
Cause
Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.0 to 11.2.0.3 [Release 9.0.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 03-Apr-2013***

Symptoms

Issuing 'alter database open resetlogs' reports errors in the alert.log file:

...
Tue Oct 11 15:35:22 2011
alter database open resetlogs
RESETLOGS after incomplete recovery UNTIL CHANGE 35575432
Errors in file /u02/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_ora_14799.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/temp/ORCL/redo01.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Errors 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 1
ORA-00312: online log 2 thread 1: '/u01/temp/ORCL/redo02.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Errors in file /u02/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_ora_14799.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u01/temp/ORCL/redo03.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Errors in file /u02/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_ora_14799.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/temp/ORCL/redo01.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 1 /u01/temp/ORCL/redo01.log

Cause

These messages are informational and occur because the online redo log files do not exist.   This is expected behavior and will occur whenever a database is opened in an environment which does not have existing online redo log files.  

Note, this will also occur with the RMAN duplicate as it will always have to create new online log files on the database open. 

Solution

Messages are informational and as long as Oracle is able to create the online redo log files, no action is required. 




來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17252115/viewspace-1161425/，如需轉載，請註明出處，否則將追究法律責任。

相關文章