Re: Cold Backups

Jerome Vitalis schreef:

> Chuck Whealton wrote:
>
> > backup the datafiles (a controlfile usually gets included here, I
> > believe)
> > switch the current redologs to archivelogs
> > backup the archivelogs (that now include whatever was in your redologs)
> >
> > If you don't THEN do ANOTHER controlfile backup, I believe the end
> > result is that the controlfile you backed up along with the datafiles
> > in the beginning won't have a record of those last redologs that were
> > switch to archivelogs AFTER your datafiles backup.
> >
> > Just something to keep in mind. The end result would be that you lost
> > the transactions in the redologs if you have to restore because RMAN
> > doesn't backup redologs (at least in 8i/9i). Please correct me if I'm
> > blatently wrong.
>
> You're right if the backups are taken in NOCATALOG mode and if you
> didn't enable the controlfile autobackup (9i). This is a configuration
> to be avoided at all price.

That's why I said:
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; Received on Wed Jul 26 2006 - 09:25:39 CDT