Skip to content
Home » Oracle Database » How to Configure AUTOBACKUP

How to Configure AUTOBACKUP

Check AUTOBACKUP ON

The default configuration of AUTOBACKUP is ON in RMAN. For those databases which are disabled, we can enable it like this:

RMAN> configure controlfile autobackup on;

new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored

Please note that, once AUTOBACKUP is ON, the backup set of BACKUP DATABASE will not include SPFILE and CONTROLFILE except that you explicitly add BACKUP CURRENT CONTROLFILE SPFILE in the run block.

Change AUTOBACKUP Location

To change the backup location, you can do this:

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/acfsmounts/acfs1/autobackup/%F';

new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/acfsmounts/acfs1/autobackup/%F';
new RMAN configuration parameters are successfully stored

Please note that, the new location must be a shared location for a RAC environment.

In case of any AUTOBACKUP failure, I recommend to backup the controlfile as a copy to a specific location regularly.

Leave a Reply

Your email address will not be published. Required fields are marked *