Skip to Content
0
Former Member
Dec 20, 2012 at 02:34 PM

warning: RECOVER succeeded but OPEN RESETLOGS would get error below

7419 Views

Well i getting an error when i try to "Recover database using backup controlfile until cancel; "

i start to drag & Drop my archives i drop almost 300 archives and still get the bellow message.

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 2 needs more recovery to be consistent

ORA-01110: data file 2: 'D:\ORACLE\ETD\SAPDATA6\UNDO_1\UNDO.DATA1'

i also after " alter database open resetlogs; " it cames with the error bellow

alter database open resetlogs

*

ERROR at line 1:

ORA-01194: file 2 needs more recovery to be consistent

ORA-01110: data file 2: 'D:\ORACLE\ETD\SAPDATA6\UNDO_1\UNDO.DATA1'

I dont understand why this happens and i dont have any more archives from my source system to restore.