• 不完全恢复(until cancel)


    环境:

    DB:11.2.0.4

    1.使用说明

    recover database until cancel;

    选择AUTO会自动应用所有归档日志,但是不会应用redo日志,需要手工输入;

    SQL下模式,应用归档日志(AUTO) + 状态为current的redo日志(手工指定),若是数据库是异地关闭的不知道那个是current的日志组可以尝试每个日志组都输入试下;

    2.例子如下

    SQL>startup mount;
    RMAN>restore database;

    SQL> recover database until cancel;
    ORA-00279: change 1629228 generated at 11/09/2021 04:17:06 needed for thread 1
    ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_09/o1_mf_1_86_jrnh64xd_.arc
    ORA-00280: change 1629228 for thread 1 is in sequence #86
    
    
    Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
    auto
    ORA-00279: change 1629302 generated at 11/09/2021 04:17:56 needed for thread 1
    ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_09/o1_mf_1_87_jrnh651p_.arc
    ORA-00280: change 1629302 for thread 1 is in sequence #87
    ORA-00278: log file '/u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_09/o1_mf_1_86_jrnh64xd_.arc' no longer needed for this recovery
    
    
    ORA-00279: change 1629310 generated at 11/09/2021 04:17:57 needed for thread 1
    ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_09/o1_mf_1_88_jrnht6b9_.arc
    ORA-00280: change 1629310 for thread 1 is in sequence #88
    ORA-00278: log file '/u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_09/o1_mf_1_87_jrnh651p_.arc' no longer needed for this recovery
    
    
    ORA-00279: change 1630314 generated at 11/09/2021 04:28:38 needed for thread 1
    ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_09/o1_mf_1_89_jrnht9ym_.arc
    ORA-00280: change 1630314 for thread 1 is in sequence #89
    ORA-00278: log file '/u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_09/o1_mf_1_88_jrnht6b9_.arc' no longer needed for this recovery
    
    
    ORA-00279: change 1630581 generated at 11/09/2021 04:28:41 needed for thread 1
    ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_09/o1_mf_1_90_jrnhw2bj_.arc
    ORA-00280: change 1630581 for thread 1 is in sequence #90
    ORA-00278: log file '/u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_09/o1_mf_1_89_jrnht9ym_.arc' no longer needed for this recovery
    
    
    ORA-00279: change 1630655 generated at 11/09/2021 04:29:38 needed for thread 1
    ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_09/o1_mf_1_91_jrnjw209_.arc
    ORA-00280: change 1630655 for thread 1 is in sequence #91
    ORA-00278: log file '/u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_09/o1_mf_1_90_jrnhw2bj_.arc' no longer needed for this recovery
    
    
    ORA-00279: change 1632220 generated at 11/09/2021 04:46:41 needed for thread 1
    ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_09/o1_mf_1_92_jrp5m698_.arc
    ORA-00280: change 1632220 for thread 1 is in sequence #92
    ORA-00278: log file '/u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_09/o1_mf_1_91_jrnjw209_.arc' no longer needed for this recovery
    
    
    ORA-00279: change 1632749 generated at 11/09/2021 19:46:30 needed for thread 1
    ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_09/o1_mf_1_93_jrp5mblz_.arc
    ORA-00280: change 1632749 for thread 1 is in sequence #93
    ORA-00278: log file '/u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_09/o1_mf_1_92_jrp5m698_.arc' no longer needed for this recovery
    
    
    ORA-00279: change 1633035 generated at 11/09/2021 19:46:34 needed for thread 1
    ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_09/o1_mf_1_94_jrp8m2tf_.arc
    ORA-00280: change 1633035 for thread 1 is in sequence #94
    ORA-00278: log file '/u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_09/o1_mf_1_93_jrp5mblz_.arc' no longer needed for this recovery
    
    
    ORA-00279: change 1637450 generated at 11/09/2021 20:37:38 needed for thread 1
    ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_09/o1_mf_1_95_jrp8yky1_.arc
    ORA-00280: change 1637450 for thread 1 is in sequence #95
    ORA-00278: log file '/u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_09/o1_mf_1_94_jrp8m2tf_.arc' no longer needed for this recovery
    
    
    ORA-00279: change 1637644 generated at 11/09/2021 20:43:45 needed for thread 1
    ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_09/o1_mf_1_96_jrp8yqyh_.arc
    ORA-00280: change 1637644 for thread 1 is in sequence #96
    ORA-00278: log file '/u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_09/o1_mf_1_95_jrp8yky1_.arc' no longer needed for this recovery
    
    
    ORA-00279: change 1637926 generated at 11/09/2021 20:43:51 needed for thread 1
    ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_09/o1_mf_1_97_jrpb3bsx_.arc
    ORA-00280: change 1637926 for thread 1 is in sequence #97
    ORA-00278: log file '/u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_09/o1_mf_1_96_jrp8yqyh_.arc' no longer needed for this recovery
    
    
    ORA-00279: change 1639495 generated at 11/09/2021 21:03:22 needed for thread 1
    ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_10/o1_mf_1_98_%u_.arc
    ORA-00280: change 1639495 for thread 1 is in sequence #98
    ORA-00278: log file '/u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_09/o1_mf_1_97_jrpb3bsx_.arc' no longer needed for this recovery
    
    
    ORA-00308: cannot open archived log '/u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_10/o1_mf_1_98_%u_.arc'
    ORA-27037: unable to obtain file status
    Linux-x86_64 Error: 2: No such file or directory
    Additional information: 3
    
    
    SQL> recover database until cancel;
    ORA-00279: change 1639495 generated at 11/09/2021 21:03:22 needed for thread 1
    ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_10/o1_mf_1_98_%u_.arc
    ORA-00280: change 1639495 for thread 1 is in sequence #98
    
    
    Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
    auto
    ORA-00308: cannot open archived log '/u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_10/o1_mf_1_98_%u_.arc'
    ORA-27037: unable to obtain file status
    Linux-x86_64 Error: 2: No such file or directory
    Additional information: 3
    
    
    ORA-00308: cannot open archived log '/u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_10/o1_mf_1_98_%u_.arc'
    ORA-27037: unable to obtain file status
    Linux-x86_64 Error: 2: No such file or directory
    Additional information: 3
    
    
    SQL> recover database until cancel;
    ORA-00279: change 1639495 generated at 11/09/2021 21:03:22 needed for thread 1
    ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_10/o1_mf_1_98_%u_.arc
    ORA-00280: change 1639495 for thread 1 is in sequence #98
    
    
    Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
    /u01/app/oracle/oradata/slnngk/redo03.log
    ORA-00310: archived log contains sequence 96; sequence 98 required
    ORA-00334: archived log: '/u01/app/oracle/oradata/slnngk/redo03.log'
    
    
    SQL> recover database until cancel;
    ORA-00279: change 1639495 generated at 11/09/2021 21:03:22 needed for thread 1
    ORA-00289: suggestion : /u01/app/oracle/fast_recovery_area/SLNNGK/archivelog/2021_11_10/o1_mf_1_98_%u_.arc
    ORA-00280: change 1639495 for thread 1 is in sequence #98
    
    
    Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
    /u01/app/oracle/oradata/slnngk/redo01.log
    Log applied.
    Media recovery complete.
    SQL> alter database open resetlogs;
    
    Database altered.
  • 相关阅读:
    PHP学习
    python获取命令行参数 启动文件
    SQLServer中char、varchar、nchar、nvarchar的区别
    VBA
    python 爬虫资料
    python乱码问题之爬虫篇
    angularjs component
    通过jQuery Ajax使用FormData对象上传文件
    directive完成UI渲染后执行JS
    交易日志
  • 原文地址:https://www.cnblogs.com/hxlasky/p/15533315.html
Copyright © 2020-2023  润新知