Re: Recreating your control files

"Brian Peasland" <oracle_dba_at_remove_spam.peasland.com> wrote in message news:3EFAF17F.55C966C4_at_remove_spam.peasland.com...
> I create a binary backup of the control file and also dump the control
> file to trace. That way, I have both. In most cases, I use the binary
> backup of the control file. And in most cases, the dump to trace is only
> used as a reference.

Well, each to his own.

Since use of the binary backup in a recovery situation *demands* a 'resetlogs', which renders all previous backups and archives non-useful (unless you are prepared to jump through hoops) until you perform a new complete backup, the use of the trace file version of the control file backup is rather more than sensible.

<Deep breath>

There are no circumstances where you would use the binary version of the backup where you couldn't equally well use the trace file version of the backup, with considerably less cost to the on-going health and well-being of your database. Not to mention your DBA.

</Deep Breath>

With one significant exception: if you use RMAN, without a catalogue, then the trace file backup doesn't include all the repository information. And then the binary backup might prove useful.

~QM

>
> HTH,
> Brian
>
> Billy Verreynne wrote:
> >
> > Peter wrote:
> >
> > > When you recreate your control files for a crash recovery, why would
> > > that be a safe thing to do?
> >
> > I always do a daily backup of the control file to trace and then keep an
> > offline copy of the trace file. Not sure what others do, but this sits
more
> > comfortable with me.. :-)
> >
> > --
> > Billy
>
> --
> ===================================================================
>
> Brian Peasland
> oracle_dba_at_remove_spam.peasland.com
>
> Remove the "remove_spam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good. Now pick two out of
> the three"
Received on Sun Jun 29 2003 - 01:37:16 CDT