Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Database recovery scenario....Help!
>So, I do recovery, I roll forward, and I try to do an open resetlogs,
and I get: ERROR at >line 1:
>ORA-01152: file 85 was not restored from a sufficiently old backup
>ORA-01110: data file 85: '/dev/vx/rdsk/prerac_undo/inp_vundo01_n1'
>
>So, at this point, there is no valid, supportable way to recover,
right?
>
>I ended up setting "_allow_resetlogs_corruption=3Dtrue", and that got
the database open.
>
>So, my question is, did I have any other alternatives? I'm pretty sure
I had no choice >other than to set the resetlogs corruption parameter.
Besides RECOVER DATAFILE with the proper file, I think not, the reason being other things besides rollback segments are in that ts. If you are in manual undo management mode, I guess you might be able to do something like in metalink Note:94114.1 c) Recovery of missing datafile with rollback segment.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 08 2004 - 12:34:03 CDT
![]() |
![]() |