Re: Cold Backups

From: Jerome Vitalis <vitalismanREMOVETHAT_at_gmail.com>
Date: Sat, 22 Jul 2006 08:48:52 +0200
Message-ID: <44c1ca49$0$165$a3f2974a@nnrp1.numericable.fr>

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. Received on Sat Jul 22 2006 - 01:48:52 CDT