
ERROR :
SQL> startup
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: ‘/u01/app/oracle/oradata/denemedb/system01.dbf’
SOLUTION :
SQL> show parameter undo
NAME |TYPE |VALUE
— —| — — — | — — — — — —
undo_management |string |AUTO
SQL> alter system set undo_management=manual scope=spfile;
SQL> ALTER SYSTEM SET “_allow_resetlogs_corruption”= TRUE SCOPE = SPFILE;
SQL> ALTER DATABASE OPEN RESETLOGS;
SQL> alter system set undo_management=AUTO scope=spfile;
SQL> shutdown immediate
SQL> startup