Re: Recovery Catalog vs Control File

From: hpuxrac <>
Date: Fri, 29 Aug 2008 13:47:24 -0700 (PDT)
Message-ID: <>

On Aug 29, 2:17 pm, wrote:


> What does this mean, and what is the purpose of the different control
> file backup methods?
> The RMAN behavior when the BACKUP command includes datafile 1 depends
> on the CONFIGURE CONTROLFILE AUTOBACKUP setting. If control file
> autobackups are ON and the backup includes datafile 1, RMAN writes the
> control file and SPFILE to a separate autobackup backup set. If
> control file autobackups are OFF and the backup includes datafile 1,
> then RMAN includes the current control file and SPFILE in the same
> backup set as the datafiles.

Well it means what it says. Just read it a couple more times.

Just set it ON and leave it ON.

Data file 1 is the SYSTEM tablespace. In other words whenever you are doing a backup that includes the SYSTEM tablespace you also get a backup of the control file and the spfile ( if you are using an spfile ).

The purpose of having it in a different backupset versus the same one is for the most part not a big thing to worry about.

For normal sized databases ... backup the whole database at the same time please. Received on Fri Aug 29 2008 - 15:47:24 CDT

Original text of this message