RMAN: Setting the Autobackup of the Control File

RMAN: Setting the Autobackup of the Control File
Андрей Волков

Андрей Волков

Системное, сетевое администрирование +DBA. И немного программист!))  Профиль автора.

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... 2464 views Андрей Волков Sat, 29 Feb 2020, 10:14:03
RMAN: Using Online or Offline ...
RMAN: Using Online or Offline ... 1623 views Андрей Волков Sat, 29 Feb 2020, 10:01:33
RMAN: Checking for Corruption ...
RMAN: Checking for Corruption ... 26911 views Андрей Волков Thu, 30 Sep 2021, 11:57:27
RMAN: Setting the Degree of Pa...
RMAN: Setting the Degree of Pa... 8226 views Андрей Волков Tue, 03 Mar 2020, 16:04:20
Comments (0)
There are no comments posted here yet
Leave your comments
Posting as Guest
×
Suggested Locations