RMAN: Setting the Autobackup of the Control File

RMAN: Setting the Autobackup of the Control File

You should always configure RMAN to back up the control file automatically after running any RMAN BACKUP or COPY command or after you make physical changes to the database that result in updates to the control file (such as adding/removing a data file). Use the SHOW command to display the current setting of the control file autobackup:

RMAN> show controlfile autobackup;

Here is some sample output:

RMAN configuration parameters for database with db_unique_name O12C are:

CONFIGURE CONTROLFILE AUTOBACKUP ON;

The following line of code shows how to enable automatic backup of the control file feature:

RMAN> configure controlfile autobackup on;

The automatic control file backup always goes into its own backup set. When autobackup of the control file is enabled, if you’re using an spfile, it’s automatically backed up along with the control file.

If, for any reason, you want to disable automatic backup of the control file, you can do so as follows:

RMAN> configure controlfile autobackup off;

Image Note  If autobackup of the control file is off, then any time you back up data file 1 (SYSTEM tablespace data file), RMAN automatically backs up the control file.

Вас заинтересует / Intresting for you:

RMAN: Specifying the Backup Us...
RMAN: Specifying the Backup Us... 69 views Андрей Волков Mon, 06 Jan 2020, 10:10:23
RMAN: Using Online or Offline ...
RMAN: Using Online or Offline ... 56 views Андрей Волков Mon, 06 Jan 2020, 10:30:24
Running the RMAN Client Remote...
Running the RMAN Client Remote... 76 views Андрей Волков Mon, 06 Jan 2020, 09:56:51
Configuring the RMAN Backup Lo...
Configuring the RMAN Backup Lo... 86 views Андрей Волков Mon, 06 Jan 2020, 12:05:39

Comments on RMAN: Setting the Autobackup of the Control File

Be the first to comment
Please login to comment