Skip to main content
Made some corrections
Source Link

I tested in 11g without RMAN catalog. When CONTROLFILE AUTOBACKUP is OFF and you issue backup database; without any additional option, it adds current controlfile and spfile into current backup set. But, when you set

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

then issue just

RMAN> backupBACKUP database;DATABASE;

it'll back up data files without Control File and SPFILE. Upon finishing the main backup RMAN runs again backup for Control File and SPFILE itself and backs up them into AUTOBACKUP folder. It's important because after main backup completes it adds information about the last backup into control file and backs it up with latest changes. Without this feature Control File inside backup set will not include your latest backup information.

Note, that even without settingIf you set CONTROLFILE AUTOBACKUP ON and want to include an old Control File during backup, force it with option ONINCLUDE CURRENT CONTROLFILE you can force it during backup:

RMAN> backupBACKUP databaseDATABASE includeINCLUDE currentCURRENT controlfile;CONTROLFILE;

I tested in 11g without RMAN catalog. When CONTROLFILE AUTOBACKUP is OFF and you issue backup database; without any additional option, it adds current controlfile and spfile into current backup set. But, when you set

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

then issue just

RMAN> backup database;

it'll back up data files without Control File and SPFILE. Upon finishing the main backup RMAN runs again backup for Control File and SPFILE itself and backs up them into AUTOBACKUP folder. It's important because after main backup completes it adds information about the last backup into control file and backs it up with latest changes. Without this feature Control File inside backup set will not include your latest backup information.

Note, that even without setting CONTROLFILE AUTOBACKUP to ON you can force it during backup:

RMAN> backup database include current controlfile;

I tested in 11g without RMAN catalog. When CONTROLFILE AUTOBACKUP is OFF and you issue backup database; without any additional option, it adds current controlfile and spfile into current backup set. But, when you set

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

then issue just

RMAN> BACKUP DATABASE;

it'll back up data files without Control File and SPFILE. Upon finishing the main backup RMAN runs again backup for Control File and SPFILE itself and backs up them into AUTOBACKUP folder. It's important because after main backup completes it adds information about the last backup into control file and backs it up with latest changes. Without this feature Control File inside backup set will not include your latest backup information.

If you set CONTROLFILE AUTOBACKUP ON and want to include an old Control File during backup, force it with option INCLUDE CURRENT CONTROLFILE:

RMAN> BACKUP DATABASE INCLUDE CURRENT CONTROLFILE;
Source Link

I tested in 11g without RMAN catalog. When CONTROLFILE AUTOBACKUP is OFF and you issue backup database; without any additional option, it adds current controlfile and spfile into current backup set. But, when you set

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

then issue just

RMAN> backup database;

it'll back up data files without Control File and SPFILE. Upon finishing the main backup RMAN runs again backup for Control File and SPFILE itself and backs up them into AUTOBACKUP folder. It's important because after main backup completes it adds information about the last backup into control file and backs it up with latest changes. Without this feature Control File inside backup set will not include your latest backup information.

Note, that even without setting CONTROLFILE AUTOBACKUP to ON you can force it during backup:

RMAN> backup database include current controlfile;