ORA-01194: file 1 needs more recovery to be consistent
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/prod/system01.dbf’ Suppose we are facing this issue while opening the database with resetlogs option. We have to check how many files have been recovered. We can check with the … Read more