Re: Recovery problem

Hi Foggy,

I don't know the full history here so forgive me.

Are you trying to perform a complete recovery by restoring a hot backup datafile that you haven't yet taken out of backup mode ?

If so, interesting, but assuming the backup has completed, then there shouldn't be a problem (the fact they're still recorded in backup mode should make no difference). Restore the datafile(s), recover the datafile, tablespace, database (depending on what you're trying to recover) and it will simply apply all the required redo logs, resync the buggers and you're away.

You should get the magical Media Recovery Complete message and be able to put the datafile, tablespace or database online.

That's *if* I understood your question correctly.

Good Luck

Richard
"Foggy" <sjefke12_at_hotmail.com> wrote in message news:f78e018a.0209182229.19bcf093_at_posting.google.com...
> Hi,
>
> when i restore the datafiles from a hot backup, then the backup status
> of these
> files is shown as 'ACTIVE' before starting a recovery. Is this normal?
> The problem is that I can't do a complete recovery, and some of you
> suggested
> that the datafiles could still be in backup mode. I cannot set the
> datafiles to 'end backup', because Oracle says that recovery is
> required.
> What am I doing wrong?
>
> Regards, Johan
Received on Thu Sep 19 2002 - 01:50:33 CDT