Re: HELP! recovery problem

You can try use the command

"recover database using backup controlfile until change X"

X is the last SCN u need to follow. how u find it ? look at the alert.log and look for the last SEQ# before
the crash.
u can also "guess" it and follow until u wont have more logs, but try find it first :)

If u already work on the database, restore it again and re-do the procedure without opening the database.

--
Asaf Shoval
Oracle Israel Support Center

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 Sun Oct 24 1999 - 07:27:41 CDT