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;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: