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

Last updated on APRIL 14, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.0 and later
Information 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms