target db / rman client: 11.2.0.1.0 1. 当configure controlfile autobackup off;时，仅备份数据文件1（system01.dbf）时会自动
target db / rman client: 11.2.0.1.0
1. 当configure controlfile autobackup off;时，，仅备份数据文件1（system01.dbf）时会自动备份控制文件；
2. 当configure controlfile autobackup on;时，备份任意文件（数据文件/归档日志）都会自动备份控制文件。
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\o1_mf_nnndf_tag20120605t151702_7wvdmhgw_.bkp 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\o1_mf_ncsnf_tag20120605t151702_7wvdn1pn_.bkp 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.25m 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.36m 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 included: 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=785171823
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=785171841
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\o1_mf_nnndf_tag20120605t151753_7wvdo1ty_.bkp 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.41m 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=785171873
deleted 1 objects