-
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?
Thank you for your help
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|