• oracle11g rman验证备份有效性


    RMAN> restore validate controlfile;

    Starting restore at 21-NOV-13
    using target database control file instead of recovery catalog
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: SID=71 device type=DISK

    channel ORA_DISK_1: starting validation of datafile backup set
    channel ORA_DISK_1: reading from backup piece /u01/archivelog/YOON/autobackup/2013_11_13/o1_mf_s_831423038_988l4gmq_.bkp
    channel ORA_DISK_1: piece handle=/u01/archivelog/YOON/autobackup/2013_11_13/o1_mf_s_831423038_988l4gmq_.bkp tag=TAG20131113T225038
    channel ORA_DISK_1: restored backup piece 1
    channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
    Finished restore at 21-NOV-13

    RMAN> restore validate spfile;

    Starting restore at 21-NOV-13
    using channel ORA_DISK_1

    channel ORA_DISK_1: starting validation of datafile backup set
    channel ORA_DISK_1: reading from backup piece /u01/archivelog/YOON/autobackup/2013_11_13/o1_mf_s_831423038_988l4gmq_.bkp
    channel ORA_DISK_1: piece handle=/u01/archivelog/YOON/autobackup/2013_11_13/o1_mf_s_831423038_988l4gmq_.bkp tag=TAG20131113T225038
    channel ORA_DISK_1: restored backup piece 1
    channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
    Finished restore at 21-NOV-13

    RMAN> restore validate database;

    Starting restore at 21-NOV-13
    using channel ORA_DISK_1

    datafile 5 will be created automatically during restore operation
    datafile 7 will be created automatically during restore operation
    channel ORA_DISK_1: starting validation of datafile backup set
    channel ORA_DISK_1: reading from backup piece /u01/oracle/fast_recovery_area/YOON/backupset/2013_09_08/o1_mf_nnndf_TAG20130908T223042_92tdpm3t_.bkp
    channel ORA_DISK_1: piece handle=/u01/oracle/fast_recovery_area/YOON/backupset/2013_09_08/o1_mf_nnndf_TAG20130908T223042_92tdpm3t_.bkp tag=TAG20130908T223042
    channel ORA_DISK_1: restored backup piece 1
    channel ORA_DISK_1: validation complete, elapsed time: 00:00:15
    failover to previous backup

    datafile 5 will be created automatically during restore operation
    datafile 7 will be created automatically during restore operation
    Finished restore at 21-NOV-13

  • 相关阅读:
    JavaScript大杂烩1
    JavaScript大杂烩0
    Scrum敏捷开发沉思录
    C#的变迁史
    C#的变迁史
    C#的变迁史
    巧用浏览器F12调试器定位系统前后端bug-转载
    Jmeter如何把响应数据的结果保存到本地的一个文件
    Jmeter察看结果树的响应数据中的中文显示乱码问题处理
    Jmeter如何将上一个请求的结果作为下一个请求的参数——使用正则表达式提取器转载
  • 原文地址:https://www.cnblogs.com/hankyoon/p/5174553.html
Copyright © 2020-2023  润新知