When does the RMAN backup automatically back up the control file?

Target DB/RMAN Client: 11.2.0.1.0

1. When configure controlfile autobackup off;, only system01.dbf is backed up, the control file is automatically backed up;

2. When configure controlfile autobackup on; is enabled, any files (data files/archive logs) backed up will be automatically backed up to control files.

RMAN> show all;

RMAN configuration parameters for database with db_unique_name T11A are:
Configure retention policy to redundancy 1; # default
Configure backup optimization off; # default
Configure default device type to disk; # default
Configure controlfile autobackup off; # default
Configure controlfile autobackup format for device type disk to '% F'; # default
Configure device type disk parallelism 1 backup type to backupset; # default
Configure datafile backup copies for device type disk to 1; # default
Configure archivelog backup copies for device type disk to 1; # default
Configure maxsetsize to unlimited; # default
Configure encryption for database off; # default
Configure encryption algorithm 'aes128 '; # default
Configure compression algorithm 'basic 'as of release 'default' optimize for load true; # DEFAULT
Configure archivelog deletion policy to none; # default
Configure snapshot controlfile name to 'd: \ ORA11G \ ORASOFT \ DATABASE \ SNCFT11A. ORA '; # default

RMAN> backup datafile 1;

Starting backup at 05-JUN-12
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 = D: \ ORA11G \ ORADATA \ T11A \ SYSTEM01.DBF
Channel ORA_DISK_1: starting piece 1 at 05-JUN-12
Channel ORA_DISK_1: finished piece 1 at 05-JUN-12
Piece handle = D: \ ORA11G \ FLASH_RECOVERY_AREA \ T11A \ BACKUPSET \ 2012_06_05 \ tags tag = TAG20120605T151702 comment = NONE
Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Channel ORA_DISK_1: starting full datafile backup set
Channel ORA_DISK_1: specifying datafile (s) in backup set
Including current control file in backup set
Including current SPFILE in backup set
Channel ORA_DISK_1: starting piece 1 at 05-JUN-12
Channel ORA_DISK_1: finished piece 1 at 05-JUN-12
Piece handle = D: \ ORA11G \ FLASH_RECOVERY_AREA \ T11A \ BACKUPSET \ 2012_06_05 \ tags tag = TAG20120605T151702 comment = NONE
Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 05-JUN-12

RMAN> list backup;

List of Backup Sets
==============================

BS Key Type LV Size Device Type Elapsed Time Completion Time
-------------------------------------------------------------
2 Full 186.25 m disk 00:00:12 05-JUN-12
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20120605T151702
Piece Name: D: \ ORA11G \ FLASH_RECOVERY_AREA \ T11A \ BACKUPSET \ 2012_06_05 \ O1_MF_NNNDF_TAG20120605T151702_7WVDMHGW_.BKP
List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Name
---------------------------------
1 Full 664502 05-JUN-12 D: \ ORA11G \ ORADATA \ T11A \ SYSTEM01.DBF

BS Key Type LV Size Device Type Elapsed Time Completion Time
-------------------------------------------------------------
3 Full 9.36 m disk 00:00:04 05-JUN-12
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20120605T151702
Piece Name: D: \ ORA11G \ FLASH_RECOVERY_AREA \ T11A \ BACKUPSET \ 2012_06_05 \ O1_MF_NCSNF_TAG20120605T151702_7WVDN1PN_.BKP
SPFILE encoded ded: Modification time: 05-JUN-12
SPFILE db_unique_name: T11A
Control File Included: Ckp SCN: 664507 Ckp time: 05-JUN-12

RMAN> delete backup;

Using channel ORA_DISK_1

List of Backup Pieces
BP Key BS Key Pc # Cp # Status Device Type Piece Name
----------------------------------------------------
2 2 1 1 available disk d: \ ORA11G \ FLASH_RECOVERY_AREA \ T11A \ BACKUPSET \ 2012_06_05 \ O1_MF_NNNDF_TAG20120605T151702_7WVDMHGW_.BKP
3 3 1 1 available disk d: \ ORA11G \ FLASH_RECOVERY_AREA \ T11A \ BACKUPSET \ 2012_06_05 \ O1_MF_NCSNF_TAG20120605T151702_7WVDN1PN_.BKP

Do you really want to delete the above objects (enter YES or NO )? Y
Deleted backup piece
Backup piece handle = D: \ ORA11G \ FLASH_RECOVERY_AREA \ T11A \ BACKUPSET \ 2012_06_05 \ O1_MF_NNNDF_TAG20120605T151702_7WVDMHGW_.BKP RECID = 2 STAMP =
Deleted backup piece
Backup piece handle = D: \ ORA11G \ FLASH_RECOVERY_AREA \ T11A \ BACKUPSET \ 2012_06_05 \ O1_MF_NCSNF_TAG20120605T151702_7WVDN1PN_.BKP RECID = 3 STAMP =
Deleted 2 objects

RMAN> backup datafile 2;

Starting backup at 05-JUN-12
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 = 00002 name = D: \ ORA11G \ ORADATA \ T11A \ SYSAUX01.DBF
Channel ORA_DISK_1: starting piece 1 at 05-JUN-12
Channel ORA_DISK_1: finished piece 1 at 05-JUN-12
Piece handle = D: \ ORA11G \ FLASH_RECOVERY_AREA \ T11A \ BACKUPSET \ 2012_06_05 \ tags tag = TAG20120605T151753 comment = NONE
Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 05-JUN-12

RMAN> list backup;

List of Backup Sets
==============================

BS Key Type LV Size Device Type Elapsed Time Completion Time
-------------------------------------------------------------
4 Full 132.41 m disk 00:00:08 05-JUN-12
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20120605T151753
Piece Name: D: \ ORA11G \ FLASH_RECOVERY_AREA \ T11A \ BACKUPSET \ 2012_06_05 \ O1_MF_NNNDF_TAG20120605T151753_7WVDO1TY_.BKP
List of Datafiles in backup set 4
File LV Type Ckp SCN Ckp Time Name
---------------------------------
2 Full 664556 05-JUN-12 D: \ ORA11G \ ORADATA \ T11A \ SYSAUX01.DBF

RMAN> delete backup;

Using channel ORA_DISK_1

List of Backup Pieces
BP Key BS Key Pc # Cp # Status Device Type Piece Name
----------------------------------------------------
4 4 1 1 available disk d: \ ORA11G \ FLASH_RECOVERY_AREA \ T11A \ BACKUPSET \ 2012_06_05 \ O1_MF_NNNDF_TAG20120605T151753_7WVDO1TY_.BKP

Do you really want to delete the above objects (enter YES or NO )? Y
Deleted backup piece
Backup piece handle = D: \ ORA11G \ FLASH_RECOVERY_AREA \ T11A \ BACKUPSET \ 2012_06_05 \ O1_MF_NNNDF_TAG20120605T151753_7WVDO1TY_.BKP RECID = 4 STAMP =
Deleted 1 objects

1 2 Next Page