Re: Database recovery scenario....Help!
- From: "Joel Garry" <joelgarry@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 8 Oct 2004 10:38:28 -0700
>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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
