• 使用RMAN验证备份的有效性


    --验证控制文件和参数文件:
    RMAN> restore validate controlfile;
    
    Starting restore at 22-JUL-14
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: SID=36 device type=DISK
    
    channel ORA_DISK_1: starting validation of datafile backup set
    channel ORA_DISK_1: reading from backup piece /u01/backup/fullbak_ORACLE_20140722_5_1
    channel ORA_DISK_1: piece handle=/u01/backup/fullbak_ORACLE_20140722_5_1 tag=TAG20140722T095956
    channel ORA_DISK_1: restored backup piece 1
    channel ORA_DISK_1: validation complete, elapsed time: 00:00:02
    Finished restore at 22-JUL-14
    
    RMAN> restore validate spfile;
    
    Starting restore at 22-JUL-14
    using channel ORA_DISK_1
    
    channel ORA_DISK_1: starting validation of datafile backup set
    channel ORA_DISK_1: reading from backup piece /u01/backup/fullbak_ORACLE_20140722_6_1
    channel ORA_DISK_1: piece handle=/u01/backup/fullbak_ORACLE_20140722_6_1 tag=TAG20140722T095956
    channel ORA_DISK_1: restored backup piece 1
    channel ORA_DISK_1: validation complete, elapsed time: 00:00:02
    Finished restore at 22-JUL-14
    
    
    --验证全备份 一般会很慢
    RMAN>  restore validate database;
    
    Starting restore at 22-JUL-14
    using channel ORA_DISK_1
    
    channel ORA_DISK_1: starting validation of datafile backup set
    channel ORA_DISK_1: reading from backup piece /u01/backup/fullbak_ORACLE_20140722_4_1
    channel ORA_DISK_1: piece handle=/u01/backup/fullbak_ORACLE_20140722_4_1 tag=TAG20140722T095956
    channel ORA_DISK_1: restored backup piece 1
    channel ORA_DISK_1: validation complete, elapsed time: 00:00:16
    channel ORA_DISK_1: starting validation of datafile backup set
    channel ORA_DISK_1: reading from backup piece /u01/backup/fullbak_ORACLE_20140722_3_1
    channel ORA_DISK_1: piece handle=/u01/backup/fullbak_ORACLE_20140722_3_1 tag=TAG20140722T095956
    channel ORA_DISK_1: restored backup piece 1
    channel ORA_DISK_1: validation complete, elapsed time: 00:00:15
    Finished restore at 22-JUL-14
    
    RMAN>
  • 相关阅读:
    2021.6.2 Python网络编程
    2021.6.1 数据库
    2021.5.29 PHP大作业
    2021.5.28 bootstrap和vue
    2021.5.27 三个和尚
    2021.5.26 Python操作Mysql数据库
    2021.5.25 PHP作业
    2021.5.24 Python解析XML
    如何用 GPU 训练模型?
    44 内核中的中断处理(上)
  • 原文地址:https://www.cnblogs.com/polestar/p/5498903.html
Copyright © 2020-2023  润新知