RMAN: Location of the Autobackup for Control File

RMAN: Location of the Autobackup for Control File

When you enable autobackup of the control file, RMAN creates the backup of the control file in one of the following locations:

  • Default location
  • FRA
  • Location specified via the CONFIGURE CONTROLFILE AUTOBACKUP FORMAT command

If you aren’t using an FRA, or if you haven’t specified a location for the control file autobackups, the control file autobackup is written to an OS-dependent default location. In Linux/Unix environments the default location is ORACLE_HOME/dbs; for example,

/u01/app/oracle/product/12.1.0.1/db_1/dbs/c-3423216220-20130109-01

If you’ve enabled an FRA, then RMAN automatically writes the control file autobackup files to directories in the FRA, using an OMF format for the name; for example,

/<fra>/<dbuname>/autobackup/<YYYY_MM_DD>/o1_mf_s_729103049_68fho9z2_.bkp

I don’t usually use the default location or the FRA for control file autobackups. I prefer these backups to be placed in the same directory the database backups are in. Here is an example:

RMAN> configure controlfile autobackup format for device type disk to

'/u01/ORA12C/rman/rman_ctl_%F.bk';

If you want to set the autobackup format back to the default, do so as follows:

RMAN> configure controlfile autobackup format for device type disk clear;

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

RMAN: Specifying the Backup Us...
RMAN: Specifying the Backup Us... 132 views Андрей Волков Sat, 29 Feb 2020, 10:14:03
RMAN: Using Online or Offline ...
RMAN: Using Online or Offline ... 109 views Андрей Волков Sat, 29 Feb 2020, 10:01:33
RMAN: Setting the Degree of Pa...
RMAN: Setting the Degree of Pa... 101 views Андрей Волков Tue, 03 Mar 2020, 16:04:20
Running the RMAN Client Remote...
Running the RMAN Client Remote... 162 views Андрей Волков Sat, 29 Feb 2020, 10:14:17

Comments on RMAN: Location of the Autobackup for Control File

Be the first to comment
Please login to comment