Re: How to backup a control file to roll forward after disaster recovery

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Wed, 19 Mar 2003 06:48:14 +1100
Message-ID: <SzKda.3064$dE2.7587@newsfeeds.bigpond.com>

"Joe Condle" <condjp_at_chp.edu> wrote in message news:64a5ef9b.0303181123.780a7ea9_at_posting.google.com...
> I recoverd my database from the latest cold backup. I can not roll
> forward using my archivelogs because I do not have a control file from
> before the mock crash.

That's got nothing to do with it. Did you, by any chance, restore the *entire* database? Including the online redo logs? Because if so, it's not surprising that no recovery is possible -because no recovery is required!

If you don't restore the redo logs, then recovery will be prompted.

>In the future how can I backup my control
> file. I do not think backing up to trace does that for me.

There's very little need for anything other than the backup to trace, unless you are using RMAN without a recovery catalog (because RMAN stores its stuff in that case in the control file of the target database, and that information is not included in the backup-to-trace file. And quite clearly you aren't using RMAN for this exercise.

Regards
HJR
> I think I
> need a binary version. Any thoughts.
>
> Joe
Received on Tue Mar 18 2003 - 13:48:14 CST