reg backup control file

[satish]

Dear Erman,

We are about to start a refresh of a instance.


1)When controlfile auto backup is on,is it required to INCLUDE CURRENT CONTROLFILE clause as below

BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL=0 spfile format '${BACKUPDIR}/spfile_%d_%s_%T.bak' DATABASE INCLUDE CURRENT CONTROLFILE PLUS ARCHIVELOG;

2)if we issue above command,Control file was being backed up by rman at the end of the backup.what was the issue if it takes the backup of control file in the begining of backup instead of taking at the end of backup?

Thank you for all the support

[ErmanArslansOracleBlog]

When you have controlfile autobackup on, (CONFIGURE CONTROLFILE AUTOBACKUP ON;)

RMAN backs up the control file whenever the database structure metadata in the control file changes or/and whenever a backup record is added.

In other words; a successful rman backup completes or a structural change is done.
database
For non-CDBs, RMAN automatically backs up the control file after a successful BACKUP command. (so at the end of the backup)

The advantage of getting controlfile backup, before and after a databae backups changes according to your needs.
For ex: Recovery to a past point in time is done by having a backup control file that reflects the database structure at the desired point-in-time.

[satish]

thanks erman