ORA-01194 File 1 needs more recovery to be consistent
I'm getting ORA-01194 File 1 needs more revovery to be consistent error message when I try to open database with resetlogs.
I copied all the PROD servers' *.dbf files to TEST server. I recreated the control file using CREATE CONTROLFILE REUSE SET DATABASE 'TEST' RESETLOGS NOARCHIVELOG and recreating controlfiles were sucessful..but cannot open the database when I issue ALTER DATABASE OPEN RESETLOGS; ...getting ORA-01194 error. ANy ideas?