Re: Help! 9i hosed!

tpcolson_at_gmail.com wrote:
> <choke> yeah, we have all the spatial data floating around, but none of
> the edits were backed up. This is a research shop with no tech
> support....
>
> http://www4.ncsu.edu/~tpcolson/alert_hydro.txt
>
> Lots of scary messages in there. So at a minimum, what kind of damage
> am I looking at? I remember turing some kind of archive thing on, have
> 250 archive logs in the archive folder.

difficult to say, seems you lost redo 2 (but crash recovery takes place at redo1 ok)

do a backup (as Malcolm sayd)

open the controlfile with notepad and identify the datafiles. Check what else is missing in your database

google keywords : redo lost

regards

stefan Received on Tue Aug 23 2005 - 14:27:41 CDT