Re: HELP! recovery problem

Jörg Rübensam wrote:
> I had a total disk crash and need to recover our 8.0.4. on Solaris.
> I have a full Offline Backup from some days ago including control files
> and so on plus all archived redo logs.
> So I restored the backup but can't manage to apply the logs !
> The problem must be, that the restored version is completely consistent
> and doesn't "know" about the following log sequence numbers.
> I tried: recover automatic database until time
> '1999-10-22-14:00:00';
> but it says 'Media recovery complete' without any action.
> How can I apply the logs ??
> Thanks... you're saving my live....

When you have had a disk crash you do not need the "UNTIL TIME ..." clause, you better use "UNTIL CANCEL"
With this your database will be rolled forward maximally possible. [As I write this I think you always need UNTIL CANCEL since you do not seem to have the current online redolog nor the control file from the time of the crash]

I also wouldn't use the AUTOMATIC keyword since the you don't know what the database is doing.
Since the controlfiles you use are old (restored) controlfiles, no information was recorded about
which archived redologfiles are to be used. I guess that the RECOVER command couldn't find more archived logs and since the database was consistent,
it reported that the media recovery was complete. This is one of the good reasons why you should have multiple controlfiles, which are on different disks.

Erwin
--
Erwin Dondorp
<http://www.dondorp.com/> Received on Sat Oct 23 1999 - 07:50:49 CDT