ITPub博客

首页 > 数据库 > Oracle > 验证oracle 11g数据库的RMAN备份的有效性

验证oracle 11g数据库的RMAN备份的有效性

原创 Oracle 作者:ywxj_001 时间:2017-12-12 18:48:46 0 删除 编辑
[oracle@db1 ~]$ rman target /


Recovery Manager: Release 11.2.0.3.0 - Production on Tue Dec 12 16:08:43 2017


Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


connected to target database: PRD (DBID=893924085)


RMAN> list backup of database;


using target database control file instead of recovery catalog


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




BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
18552   Full    5.70G      DISK        00:10:08     08-DEC-17      
        BP Key: 18552   Status: AVAILABLE  Compressed: YES  Tag: TAG20171208T230015
        Piece Name: /backup/scprd1/rman/Full_SCPRD_20171208_18569.bak
  List of Datafiles in backup set 18552
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  6       Full 1353576289 08-DEC-17 +DATA/scprd/datafile/sce_common.296.929901311
  7       Full 1353576289 08-DEC-17 +DATA/scprd/datafile/sce_component.298.929901313
  10      Full 1353576289 08-DEC-17 +DATA/scprd/datafile/wmwhse3_data.304.929901317
  17      Full 1353576289 08-DEC-17 +DATA/scprd/datafile/wmwhse10_data.318.929901327
  21      Full 1353576289 08-DEC-17 +DATA/scprd/datafile/wmwhse14_data.326.929901333
  25      Full 1353576289 08-DEC-17 +DATA/scprd/datafile/wmwhse18_data.334.929901339
  27      Full 1353576289 08-DEC-17 +DATA/scprd/datafile/wmwhse20_data.338.929901343
  30      Full 1353576289 08-DEC-17 +DATA/scprd/datafile/wmwhse16_data.392.938904035

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
18674   Full    5.73G      DISK        00:09:39     11-DEC-17      
        BP Key: 18674   Status: AVAILABLE  Compressed: YES  Tag: TAG20171211T230016
        Piece Name: /backup/scprd1/rman/Full_SCPRD_20171211_18691.bak
  List of Datafiles in backup set 18674
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  6       Full 1363677571 11-DEC-17 +DATA/scprd/datafile/sce_common.296.929901311
  7       Full 1363677571 11-DEC-17 +DATA/scprd/datafile/sce_component.298.929901313
  10      Full 1363677571 11-DEC-17 +DATA/scprd/datafile/wmwhse3_data.304.929901317
  17      Full 1363677571 11-DEC-17 +DATA/scprd/datafile/wmwhse10_data.318.929901327
  21      Full 1363677571 11-DEC-17 +DATA/scprd/datafile/wmwhse14_data.326.929901333
  25      Full 1363677571 11-DEC-17 +DATA/scprd/datafile/wmwhse18_data.334.929901339
  27      Full 1363677571 11-DEC-17 +DATA/scprd/datafile/wmwhse20_data.338.929901343
  30      Full 1363677571 11-DEC-17 +DATA/scprd/datafile/wmwhse16_data.392.938904035

RMAN> validate backupset 18674;


Starting validate at 12-DEC-17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=3401 instance=SCPRD1 device type=DISK
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece /backup/scprd1/rman/Full_SCPRD_20171211_18691.bak
channel ORA_DISK_1: piece handle=/backup/scprd1/rman/Full_SCPRD_20171211_18691.bak tag=TAG20171211T230016
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:11:45
Finished validate at 12-DEC-17

只针对RMAN的FULL全备进行验证。

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/22996654/viewspace-2148613/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
在零售、金融、互联网行业从事数据库相关工作10余年,有丰富的数据库管理和架构的相关经验。 涉及SQLServer、Oracle、MySQL、PostgreSQL等多种数据库。 目前在一家互联网公司担任DBA经理。 负责整个集团数据库的架构设计和管理工作。

注册时间:2010-01-19

  • 博文量
    247
  • 访问量
    436205