探索ORACLE之RMAN_03非一致性备份(四)
-------
8 Full 524.66M DISK 00:01:36 23-MAY-12
BP Key:8 Status: AVAILABLE Compressed: NO Tag: TAG20120523T121210
Piece Name:/DBBak/bak_WWL_05_23_0anbmtkr_1_1
List of Datafilesin backup set 8
File LV Type CkpSCN Ckp Time Name
---- -- -------------- --------- ----
1 Full 649219 23-MAY-12 /DBData/WWL/system01.dbf
2 Full 649219 23-MAY-12 /DBData/WWL/undotbs01.dbf
3 Full 649219 23-MAY-12 /DBData/WWL/sysaux01.dbf
4 Full 649219 23-MAY-12 /DBData/WWL/users01.dbf
BS Key Type LVSize Device Type Elapsed TimeCompletion Time
------- ---- -- ---------- ----------- ---------------------------
9 Full 6.80M DISK 00:00:01 23-MAY-12
BP Key:9 Status: AVAILABLE Compressed: NO Tag: TAG20120523T121358
Piece Name:/DBSoft/product/10.2.0/db_1/dbs/c-5520179-20120523-00
Control FileIncluded: Ckp SCN: 649233 Ckp time:23-MAY-12
SPFILE Included:Modification time: 23-MAY-12
www.2cto.com
如下是备份USER表空间信息：
BS Key Type LVSize Device Type Elapsed TimeCompletion Time
------- ---- -- ---------- ----------- ---------------------------
10 Full 432.00K DISK 00:00:01 23-MAY-12
BP Key: 10 Status: AVAILABLE Compressed: NO Tag: TAG20120523T133147
Piece Name:/DBBak/bak_WWL_05_23_0cnbn2a3_1_1
List of Datafilesin backup set 10
File LV Type CkpSCN Ckp Time Name
---- -- -------------- --------- ----
4 Full 651081 23-MAY-12 /DBData/WWL/users01.dbf
BS Key Type LVSize Device Type Elapsed TimeCompletion Time
------- ---- -- ---------- ----------- ---------------------------
11 Full 6.80M DISK 00:00:03 23-MAY-12
BP Key:11 Status: AVAILABLE Compressed: NO Tag: TAG20120523T133151
Piece Name:/DBSoft/product/10.2.0/db_1/dbs/c-5520179-20120523-01
Control FileIncluded: Ckp SCN: 651086 Ckp time:23-MAY-12
SPFILE Included:Modification time: 23-MAY-12 www.2cto.com
如下是备份数据文件1，2，3的信息：
BS Key Type LVSize Device Type Elapsed TimeCompletion Time
------- ---- -- ---------- ----------- ---------------------------
12 Full 524.61M DISK 00:01:42 23-MAY-12
BP Key:12 Status: AVAILABLE Compressed: NO Tag: TAG20120523T133235
Piece Name:/DBBak/bak_WWL_05_23_0enbn2bk_1_1
List of Datafilesin backup set 12
File LV Type CkpSCN Ckp Time Name
---- -- -------------- --------- ----
1 Full 651104 23-MAY-12 /DBData/WWL/system01.dbf
2 Full 651104 23-MAY-12 /DBData/WWL/undotbs01.dbf
3 Full 651104 23-MAY-12 /DBData/WWL/sysaux01.dbf
BS Key Type LVSize Device Type Elapsed TimeCompletion Time
------- ---- -- ---------- ----------- ---------------------------
13 Full 6.80M DISK 00:00:01 23-MAY-12
BP Key:13 Status: AVAILABLE Compressed: NO Tag: TAG20120523T133424
Piece Name:/DBSoft/product/10.2.0/db_1/dbs/c-5520179-20120523-02
Control FileIncluded: Ckp SCN: 651119 Ckp time:23-MAY-12
SPFILE Included:Modification time: 23-MAY-12
如下备份的是控制文件信息：
BS Key Type LVSize Device Type Elapsed TimeCompletion Time
------- ---- -- ---------- ----------- ---------------------------
14 Full 6.77M DISK 00:00:01 23-MAY-12