Re: Recovery Catalog vs Control File
Date: Fri, 29 Aug 2008 13:47:24 -0700 (PDT)
Message-ID: <01fec2a6-21c8-4794-93c0-6ab6c20a2737@k13g2000hse.googlegroups.com>
On Aug 29, 2:17 pm, e..._at_chicagorsvp.com wrote:
snip
> 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