Login  Register

Re: reg backup control file

Posted by ErmanArslansOracleBlog on May 29, 2018; 8:51am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/reg-backup-control-file-tp6102p6111.html

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.