DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Friday, January 9, 2015

ORA-01194: file 1 needs more recovery to be consistent

You may face the error

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/d01/TEST/db/apps_st/data/system01'

While trying to issue alter database open resetlogs after cloning the instance using cold backup.

Please follow the below steps to resolve this error

source the Environment and try to recover the database using below command

SQL>  recover database;
RA-00283: recovery session canceled due to errorsRA-01610: recovery using the BACKUP CONTROLFILE option must be done

SQL>  recover database until cancel using BACKUP CONTROLFILE;
ORA-00283: recovery session canceled due to errors

SQL>shut immediate

goto $ORACLE_HOME/dbs and

add _allow_resetlogs_corruption=true in the INIT<SID>.ora


SQL> startup mount;
ORACLE instance started.
Total System Global Area 1069252608 bytes
Fixed Size                  2188408 bytes
Variable Size             436214664 bytes
Database Buffers          616562688 bytes
Redo Buffers               14286848 bytes
Database mounted.

SQL> select name,open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
TEST      MOUNTED

SQL> alter database open resetlogs;

Database altered.

SQL> select name,open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
TEST      READ WRITE



Done!!

No comments: