• 不完全恢复(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.
  • 相关阅读:
    OPPO R9sPlus MIFlash线刷TWRP Recovery ROOT详细教程
    OPPO R11 R11plus系列 解锁BootLoader ROOT Xposed 你的手机你做主
    努比亚(nubia) M2青春版 NX573J 解锁BootLoader 并进入临时recovery ROOT
    华为 荣耀 等手机解锁BootLoader
    青橙 M4 解锁BootLoader 并刷入recovery ROOT
    程序员修炼之道阅读笔03
    冲刺8
    典型用户模板分析
    学习进度八
    冲刺7
  • 原文地址:https://www.cnblogs.com/hxlasky/p/15533315.html
Copyright © 2020-2023  润新知