Re: Help! 9.0.2 dead!

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Thu, 25 Aug 2005 10:33:49 +0200
Message-ID: <dejvpd$hso$1@news.BelWue.DE>

Matthias Hoys wrote:
> "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

Provided there is a backup of the datafiles, too. And if on a server where only the OP is supposed to have access, vital files can disappear, I wouldn't bet my wages on a usable backup..

> 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
>
>

Cheers,
Holger Received on Thu Aug 25 2005 - 03:33:49 CDT