Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP! recovery problem
Joerg,
AFAIK, you need a recent controlfile (or backup controlfile) to do the recovery.
I hope, you got your controlfiles duplexed. If not you are out of luck.
Karsten
In article <7uuthm$hel$1_at_news2.inter.net.il>,
"sysdba" <sysdba_at_inter.net.il> wrote:
> 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
> >
> >
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Oct 25 1999 - 04:52:26 CDT