Skip to content
July 19, 2013 / doganay

ORA-00283: ORA-00314: ORA-00312: Error and solution


Problem:

ORA-00283: recovery session canceled due to errors
ORA-00314: log 2 of thread 1, expected sequence# 2 doesn't match 11
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/mydb/redo02.log'


While:

Trying to restore controlfile from backup , while recovery

Solution:

$ sqlplus / as sysdba
SQL> shu immediate
SQL> startup mount
SQL> exit
$ rman target /
RMAN> restore database;
RMAN> recover database;
RMAN> exit
$ sqlplus / as sysdba
SQL> shu immediate
SQL> startup
SQL> alter database clear logfile '/u01/app/oracle/oradata/mydb/redo02.log';
SQL> recover database until cancel;
SQL> alter database open resetlogs;

Leave a comment