Re: HELP! recovery problem

Hi,
We do this every once in a while when we have to re-set up a hot, standby database.

1) restore your cold back up and all archives
2) "startup mount" your database.  DO NOT OPEN IT.
3) Issue "recover database using backup control file"
4) It should start requesting archive logs

It is essential that you only mount and not open the DB. Once it's open, this will not work.

HTH --
Jim Gregory
Principal Consultant for Keane, Inc.
Currently assigned to NCR
"Opinions are my own and do not reflect   those of Keane or my clients"
Jörg Rübensam <joerg.ruebensam_at_ivz.de> wrote in message news:3811A08D.24AF40D_at_ivz.de...
> Hello.
>
> 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....
>
> Joerg
>
>
Received on Mon Oct 25 1999 - 07:41:30 CDT