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:
'/ora_sys/TFSU/system01_TFS.dbf'
SQL> RECOVER DATABASE UNTIL CANCEL;
ORA-00283: recovery session canceled
due to errors
ORA-16433: The database must be opened
in read/write mode.
SQL> ALTER DATABASE OPEN
NORESETLOGS;
ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid
after an incomplete database recovery
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1:
'/ora_sys/TFSU/system01_TFS.dbf'
SQL>alter system set _ALLOW_RESETLOGS_CORRUPTION=true
***Hidden
parameter _ALLOW_RESETLOGS_CORRUPTION=TRUE which will allow us
to
open
database even though it’s not properly recovered ***
SQL> ALTER DATABASE OPEN
RESETLOGS;
Database altered.