oracle backup database 备份片大小,RMAN笔记之备份集和备份片

RMAN> configure device type disk backup type to copy;   //设置备份生成镜像复制

=====================================================================================

备份集(backup set)：

备份集就是输入文件的备份，它是一个逻辑概念，物理上由备份片(backup piece)组成。一个备份集可以包含多个输入文件，一个输入文件可以分散在多个备份片上。例子如下：

RMAN> list backupset;

List of Backup Sets

===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

1       Full    1005.80M   DISK        00:00:04     23-OCT-14

BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20141023T111812

Piece Name: /oracle/app/oracle/fast_recovery_area/ZLB/backupset/2014_10_23/o1_mf_nnndf_TAG20141023T111812_b4jwvo17_.bkp

List of Datafiles in backup set 1

File LV Type Ckp SCN    Ckp Time  Name

---- -- ---- ---------- --------- ----

1       Full 1094205    23-OCT-14 /oracle/app/oracle/oradata/zlb/system01.dbf

2       Full 1094205    23-OCT-14 /oracle/app/oracle/oradata/zlb/sysaux01.dbf

3       Full 1094205    23-OCT-14 /oracle/app/oracle/oradata/zlb/undotbs01.dbf

4       Full 1094205    23-OCT-14 /oracle/app/oracle/oradata/zlb/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

2       Full    9.36M      DISK        00:00:01     23-OCT-14

BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20141023T111812

Piece Name: /oracle/app/oracle/fast_recovery_area/ZLB/backupset/2014_10_23/o1_mf_ncsnf_TAG20141023T111812_b4jwvx3s_.bkp

SPFILE Included: Modification time: 22-OCT-14

SPFILE db_unique_name: ZLB

Control File Included: Ckp SCN: 1094209      Ckp time: 23-OCT-14

BSKey Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

3     Full    1.01G      DISK        00:00:10     23-OCT-14

List of Datafiles in backup set 3

File LV Type Ckp SCN    Ckp Time  Name

---- -- ---- ---------- --------- ----

1       Full 1122962    23-OCT-14 /oracle/app/oracle/oradata/zlb/system01.dbf

2       Full 1122962    23-OCT-14 /oracle/app/oracle/oradata/zlb/sysaux01.dbf

3       Full 1122962    23-OCT-14 /oracle/app/oracle/oradata/zlb/undotbs01.dbf

4       Full 1122962    23-OCT-14 /oracle/app/oracle/oradata/zlb/users01.dbf

Backup Set Copy #1 of backup set 3

Device Type Elapsed Time Completion Time Compressed Tag

----------- ------------ --------------- ---------- ---

DISK        00:00:10     23-OCT-14       NO         TAG20141023T225841

List of Backup Pieces for backup set 3 Copy #1

BP KeyPc# Status      Piece Name

------- --- ----------- ----------

31   AVAILABLE   /oracle/app/oracle/fast_recovery_area/ZLB/backupset/2014_10_23/o1_mf_nnndf_TAG20141023T225841_b4l5x1ph_.bkp

42   AVAILABLE   /oracle/app/oracle/fast_recovery_area/ZLB/backupset/2014_10_23/o1_mf_nnndf_TAG20141023T225841_b4l5x8pw_.bkp

53   AVAILABLE   /oracle/app/oracle/fast_recovery_area/ZLB/backupset/2014_10_23/o1_mf_nnndf_TAG20141023T225841_b4l5xcq0_.bkp

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

4       Full    9.36M      DISK        00:00:01     23-OCT-14

BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20141023T225841

Piece Name: /oracle/app/oracle/fast_recovery_area/ZLB/backupset/2014_10_23/o1_mf_ncsnf_TAG20141023T225841_b4l5xftm_.bkp

SPFILE Included: Modification time: 23-OCT-14

SPFILE db_unique_name: ZLB

Control File Included: Ckp SCN: 1122966      Ckp time: 23-OCT-14

=================================================================================================================

backup命令生成的备份集的数量由以下几个因素决定：