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