• 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

  • 相关阅读:
    汉字词组换行
    C#中获取Excel文件的第一个表名
    SQL查找某一条记录的方法
    C#数据库连接字符大全
    整理的asp.net资料!(不得不收藏)
    母版页的优点,及母版页与内容页中相互访问方法
    13范式
    使用 Jackson 树连接线形状
    word2007,取消显示回车符
    三张表之间相互的多对多关系
  • 原文地址:https://www.cnblogs.com/hankyoon/p/5174553.html
Copyright © 2020-2023  润新知