Configuring AUTOBACKUP of CONTROLFILE and SPFILE in Oracle database 11gR2
Posted by Mir Sayeed Hassan on February 17th, 2018
Configuring AUTOBACKUP of CONTROLFILE and SPFILE in Oracle database 11gR2
Whenever you perform any RMAN backup, Configure the Control file & SPFILE
To setup the control file & spfile auto backup
RMAN>; configure controlfile autobackup on; old RMAN configuration parameters: CONFIGURE CONTROLFILE AUTOBACKUP OFF; new RMAN configuration parameters: CONFIGURE CONTROLFILE AUTOBACKUP ON; new RMAN configuration parameters are successfully stored
After enable the RMAN with automatically taken backup of control file & spfile, by default its specify in DB_RECOVERY_FILE_DEST location
Consider the below example for taking backup of one tablespace “EXAMPLE” from database, You will see RMAN backup of tbs with control file & spfile
[oracle@oracleTestServer ~]$ rman target / Recovery Manager: Release 11.2.0.4.0 - Production on Sat Feb 17 17:52:55 2018 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: TESTDB (DBID=4187434325)
RMAN>; backup tablespace example; Starting backup at 17-FEB-18 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=319 device type=DISK channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00005 name=/u01/app/oracle/oradata/prim/example01.dbf channel ORA_DISK_1: starting piece 1 at 17-FEB-18 channel ORA_DISK_1: finished piece 1 at 17-FEB-18 piece handle=/u01/app/oracle/fast_recovery_area/TESTDB/backupset/2018_02_17/o1_mf_nnndf_TAG20180217T175307_f8jgpd32_.bkp tag=TAG20180217T175307 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 17-FEB-18 Starting Control File and SPFILE Autobackup at 17-FEB-18 piece handle=/u01/app/oracle/fast_recovery_area/TESTDB/autobackup/2018_02_17/o1_mf_s_968349189_f8jgpfch_.bkp comment=NONE Finished Control File and SPFILE Autobackup at 17-FEB-18
To disable the AUTOBACKUP of Control file & SPFILE
RMAN>; configure controlfile autobackup off; old RMAN configuration parameters: CONFIGURE CONTROLFILE AUTOBACKUP ON; new RMAN configuration parameters: CONFIGURE CONTROLFILE AUTOBACKUP OFF; new RMAN configuration parameters are successfully stored