Monday, 1 August 2016

Unable to Open database after database clone or Recover from backup

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.

No comments:

Post a Comment