Common advice is to backup to FRA.
Before following advice, evaluate to determine fit and understand any repercussions.
Doesn’t this potentially create SPOF and may require restore from tape unnecessarily?
HINT:
Make sure the following commands are part of backup when backup to FRA.
CONFIGURE CHANNEL DEVICE TYPE DISK CLEAR; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK CLEAR;
DEMO:
Recovery Manager: Release 12.1.0.2.0 - Production on Sun Nov 26 16:02:17 2017 RMAN> show controlfile autobackup; RMAN configuration parameters for database with db_unique_name HAWK are: CONFIGURE CONTROLFILE AUTOBACKUP ON; RMAN> show controlfile autobackup format; RMAN configuration parameters for database with db_unique_name HAWK are: CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default RMAN> backup datafile 1; Starting backup at 26-NOV-17 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00001 name=+DATA/HAWK/DATAFILE/system.258.960967651 channel ORA_DISK_1: starting piece 1 at 26-NOV-17 channel ORA_DISK_1: finished piece 1 at 26-NOV-17 piece handle=+FRA/HAWK/BACKUPSET/2017_11_26/nnndf0_tag20171126t160327_0.274.961085007 tag=TAG20171126T160327 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07 Finished backup at 26-NOV-17 --- Control File and SPFILE Autobackup to FRA Starting Control File and SPFILE Autobackup at 26-NOV-17 piece handle=+FRA/HAWK/AUTOBACKUP/2017_11_26/s_961085014.275.961085015 comment=NONE Finished Control File and SPFILE Autobackup at 26-NOV-17 RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; new RMAN configuration parameters: CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; new RMAN configuration parameters are successfully stored RMAN> show controlfile autobackup format; RMAN configuration parameters for database with db_unique_name HAWK are: CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; --- CONTROLFILE AUTOBACKUP FORMAT is same but ***NOT*** DEFAULT RMAN> backup datafile 1; Starting backup at 26-NOV-17 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00001 name=+DATA/HAWK/DATAFILE/system.258.960967651 channel ORA_DISK_1: starting piece 1 at 26-NOV-17 channel ORA_DISK_1: finished piece 1 at 26-NOV-17 piece handle=+FRA/HAWK/BACKUPSET/2017_11_26/nnndf0_tag20171126t160655_0.276.961085215 tag=TAG20171126T160655 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07 Finished backup at 26-NOV-17 --- Control File and SPFILE Autobackup to ***DISK*** Starting Control File and SPFILE Autobackup at 26-NOV-17 piece handle=/u01/app/oracle/12.1.0.2/db1/dbs/c-3219666184-20171126-01 comment=NONE Finished Control File and SPFILE Autobackup at 26-NOV-17 RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK CLEAR; old RMAN configuration parameters: CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; RMAN configuration parameters are successfully reset to default value RMAN> show controlfile autobackup format; RMAN configuration parameters for database with db_unique_name HAWK are: CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default <-- RMAN> backup datafile 1 FORMAT '%d_%I_%T_%U'; Starting backup at 26-NOV-17 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00001 name=+DATA/HAWK/DATAFILE/system.258.960967651 channel ORA_DISK_1: starting piece 1 at 26-NOV-17 channel ORA_DISK_1: finished piece 1 at 26-NOV-17 piece handle=/u01/app/oracle/12.1.0.2/db1/dbs/HAWK_3219666184_20171126_0oski093_1_1 tag=TAG20171126T161531 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07 Finished backup at 26-NOV-17 Starting Control File and SPFILE Autobackup at 26-NOV-17 piece handle=+FRA/HAWK/AUTOBACKUP/2017_11_26/s_961085738.277.961085739 comment=NONE Finished Control File and SPFILE Autobackup at 26-NOV-17 RMAN>
REFERENCE:
How to KEEP a backup created in the Flash Recovery Area (FRA)? (Doc ID 401163.1) A backup needed to be KEPT, must be created outside the flash recovery area. Why are backups going to $ORACLE_HOME/dbs rather than Flash recovery area via Rman or EM Grid control /FRA not considering Archivelog part of it (Doc ID 404854.1) 1. Do not use a FORMAT clause on backup commands. RMAN Uses Flash Recovery Area for Autobackup When Using Format '%F' (Doc ID 338483.1)
Thinking Out Loud 