piece handle=/opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_ncnnf_TAG20130910T194255_92zp5k2q_.bkp tag=TAG20130910T194255 comment=NONE
2.备份数据库的同时备份控制文件
RMAN> backup database include current controlfile;
Starting backup at 10-SEP-13
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=/opt/oracle/oradata/portaldb/system01.dbf
input datafile file number=00002 name=/opt/oracle/oradata/portaldb/sysaux01.dbf
input datafile file number=00003 name=/opt/oracle/oradata/portaldb/undotbs01.dbf
input datafile file number=00005 name=/oradata/portaldb_ICMLFQ32_01.dbf
input datafile file number=00006 name=/oradata/portaldb_ICMLNF32_01.dbf
input datafile file number=00007 name=/oradata/portaldb_ICMSFQ04_01.dbf
input datafile file number=00008 name=/oradata/portaldb_ICMVFQ04_01.dbf
input datafile file number=00009 name=/oradata/portaldb_ICMLSNDX_01.dbf
input datafile file number=00004 name=/opt/oracle/oradata/portaldb/users01.dbf
channel ORA_DISK_1: starting piece 1 at 10-SEP-13
channel ORA_DISK_1: finished piece 1 at 10-SEP-13
piece handle=/opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_nnndf_TAG20130910T194428_92zp8dmn_.bkp tag=TAG20130910T194428 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:25
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 10-SEP-13
channel ORA_DISK_1: finished piece 1 at 10-SEP-13
piece handle=/opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_ncsnf_TAG20130910T194428_92zpc2pk_.bkp tag=TAG20130910T194428 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 10-SEP-13
3.备份第一个数据文件
RMAN> backup datafile 1;
Starting backup at 10-SEP-13
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=/opt/oracle/oradata/portaldb/system01.dbf
channel ORA_DISK_1: starting piece 1 at 10-SEP-13
channel ORA_DISK_1: finished piece 1 at 10-SEP-13
piece handle=/opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_nnndf_TAG20130910T194942_92zpl6l4_.bkp tag=TAG20130910T194942 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
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 10-SEP-13
channel ORA_DISK_1: finished piece 1 at 10-SEP-13
piece handle=/opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_ncsnf_TAG20130910T194942_92zpmynf_.bkp tag=TAG20130910T194942 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 10-SEP-13
4.查看备份过的控制文件
RMAN> list backup of controlfile;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 9.36M DISK 00:00:02 10-SEP-13
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20130910T181210
Piece Name: /opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_ncsnf_TAG20130910T181210_92zjvd24_.bkp
Control File Included: Ckp SCN: 1131454 Ckp time: 10-SEP-13
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 9.36M DISK 00:00:01 10-SEP-13
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20130910T182338
Piece Name: /opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_ncsnf_TAG20130910T182338_92zkjvfb_.bkp
Control File Included: Ckp SCN: 1132378 Ckp time: 10-SEP-13
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 9.36M DISK 00:00:02 10-SEP-13
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20130910T182444
Piece Name: /opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_ncsnf_TAG20130910T182444_92zklxrc_.bkp
Control File Included: Ckp SCN: 1132421 Ckp time: 10-SEP-13
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Full 9.36M DISK 00:00:01 10-SEP-13
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20130910T183137
Piece Name: /opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_ncsnf_TAG20130910T183137_92zl2t44_.bkp
Control File Included: Ckp SCN: 1133095 Ckp time: 10-SEP-13
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7 Full 9.36M DISK 00:00:01 10-SEP-13
BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20130910T183832
Piece Name: /oradata/backup/bak_0bojh5ft_1_1
Control File Included: Ckp SCN: 1133289 Ckp time: 10-SEP-13
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
10 Full 9.33M DISK 00:00:01 10-SEP-13
BP Key: 10 Status: AVAILABLE Compressed: NO Tag: TAG20130910T194255
Piece Name: /opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_ncnnf_TAG20130910T194255_92zp5k2q_.bkp
Control File Included: Ckp SCN: 1136446 Ckp time: 10-SEP-13
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12 Full 9.36M DISK 00:00:02 10-SEP-13
BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20130910T194428
Piece Name: /opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_ncsnf_TAG20130910T194428_92zpc2pk_.bkp
Control File Included: Ckp SCN: 1136576 Ckp time: 10-SEP-13
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14 Full 9.36M DISK 00:00:02 10-SEP-13
BP Key: 14 Status: AVAILABLE Compressed: NO Tag: TAG20130910T194942
Piece Name: /opt/oracle/flash_recovery_area/PORTALDB/backupset/2013_09_10/o1_mf_ncsnf_TAG20130910T194942_92zpmynf_.bkp
Control File Included: Ckp SCN: 1136736 Ckp time: 10-SEP-13