设为首页 加入收藏

TOP

验证控制文件、归档文件、不同BLOCK大小的数据文件对应的RMAN备份集不在同一PIECE(五)
2015-07-24 10:56:12 来源: 作者: 【 】 浏览:4
Tags:验证 控制 文件 归档 不同 BLOCK 大小 数据 对应 RMAN 备份 不在 同一 PIECE
n backup set
channel ORA_DISK_1: starting piece 1 at 12-MAY-15
channel ORA_DISK_1: finished piece 1 at 12-MAY-15
piece handle=+FLASH/bys9/backupset/2015_05_12/ncsnf0_tag20150512t231925_0.262.879549601 tag=TAG20150512T231925 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 12-MAY-15

Starting backup at 12-MAY-15
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=24 RECID=10 STAMP=879549604
channel ORA_DISK_1: starting piece 1 at 12-MAY-15
channel ORA_DISK_1: finished piece 1 at 12-MAY-15
piece handle=+FLASH/bys9/backupset/2015_05_12/annnf0_tag20150512t232004_0.266.879549605 tag=TAG20150512T232004 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: deleting archived log(s)
archived log file name=+FLASH/bys9/archivelog/2015_05_12/thread_1_seq_24.263.879549603 RECID=10 STAMP=879549604
Finished backup at 12-MAY-15

-----------

RMAN> list backup of controlfile;


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


BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
21 Full 1.03M DISK 00:00:04 12-MAY-15
BP Key: 21 Status: AVAILABLE Compressed: YES Tag: TAG20150512T231925
Piece Name: +FLASH/bys9/backupset/2015_05_12/ncsnf0_tag20150512t231925_0.262.879549601
Control File Included: Ckp SCN: 261966 Ckp time: 12-MAY-15

RMAN> list backup of archivelog all;


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


BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
17 9.50K DISK 00:00:01 12-MAY-15
BP Key: 17 Status: AVAILABLE Compressed: YES Tag: TAG20150512T231922
Piece Name: +FLASH/bys9/backupset/2015_05_12/annnf0_tag20150512t231922_0.265.879549563

List of Archived Logs in backup set 17
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 23 261837 12-MAY-15 261945 12-MAY-15

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
22 3.00K DISK 00:00:02 12-MAY-15
BP Key: 22 Status: AVAILABLE Compressed: YES Tag: TAG20150512T232004
Piece Name: +FLASH/bys9/backupset/2015_05_12/annnf0_tag20150512t232004_0.266.879549605

List of Archived Logs in backup set 22
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 24 261945 12-MAY-15 261973 12-MAY-15

RMAN> list backup of database;


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


BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
18 Full 101.58M DISK 00:00:23 12-MAY-15
BP Key: 18 Status: AVAILABLE Compressed: YES Tag: TAG20150512T231925
Piece Name: +FLASH/bys9/backupset/2015_05_12/nnndf0_tag20150512t231925_0.264.879549565
List of Datafiles in backup set 18
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 261954 12-MAY-15 +DATA01/bys9/datafile/system.260.876770855
2 Full 261954 12-MAY-15 +DATA01/bys9/datafile/sysaux.261.876770927
3 Full 261954 12-MAY-15 +DATA01/bys9/datafile/undotbs1.262.876770987
4 Full 261954 12-MAY-15 +DATA01/bys9/datafile/users.264.876771015

BS Key Type LV S

首页 上一页 2 3 4 5 下一页 尾页 5/5/5
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇一个测试SQL2005数据库连接的JSP.. 下一篇为什么不记录慢查询?

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容:

·HyperText Transfer (2025-12-26 07:20:48)
·半小时搞懂 HTTP、HT (2025-12-26 07:20:42)
·CPython是什么?PyPy (2025-12-26 06:50:09)
·Python|如何安装seab (2025-12-26 06:50:06)
·python要学习数据分 (2025-12-26 06:50:03)