Re: Help! 9.0.2 dead!

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Thu, 25 Aug 2005 10:31:19 +0200
Message-ID: <430d81d8$0$23543$ba620e4c@news.skynet.be>

"none" <tpcolson_at_gmail.com> wrote in message news:1124935212.628027.49190_at_g43g2000cwa.googlegroups.com...
> "sounds like if you cannot find the redo log files you will need to
> perform
> an incomplete recovery. Meaning, in your case, you will lose the
> transaction
> which were in the redo logs. "
>
> Meaning, all edits I made since install date, or all edits since last
> reboot, or when I last did table statistics. The data I'm interested
> in, haven't made in edit since late july/early aug, last archive file
> is aug 18.
>

What do you mean with "last archive file" ? Do you have archive logging enabled (and is there a backup of the archived log files ?). Then you can perform a point-in-time recovery. You will only loose those transactions that were in the lost online redo log files (since they were not yet archived). Maybe they are on a separate disk device and that disk got faulty ? Files don't disappear like that, even on Windows :-)

Matthias Received on Thu Aug 25 2005 - 03:31:19 CDT