Open Resetlogs Reports Errors ORA-00313 and ORA-00312 to Alert
(Doc ID 1366482.1)
Last updated on JUNE 04, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 9.0.1.0 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |