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.garry.to

--
http://www.freelists.org/webpage/oracle-l