• rman 恢复控制文件


    恢复控制文件错误,数据库不能打开

    SQL> startup
    ORACLE instance started.
    
    Total System Global Area 4999610368 bytes
    Fixed Size            8803024 bytes
    Variable Size         1040190768 bytes
    Database Buffers     3942645760 bytes
    Redo Buffers            7970816 bytes
    ORA-00205: error in identifying control file, check alert log for more info

    恢复:

    RMAN> set DBID=601284688
    
    executing command: SET DBID
    
    RMAN> restore controlfile from autobackup;
    
    Starting restore at 2020-06-19 15:55:37
    using channel ORA_DISK_1
    
    channel ORA_DISK_1: looking for AUTOBACKUP on day: 20200619
    channel ORA_DISK_1: AUTOBACKUP found: c-601284688-20200619-01
    channel ORA_DISK_1: restoring control file from AUTOBACKUP c-601284688-20200619-01
    channel ORA_DISK_1: control file restore from AUTOBACKUP complete
    output file name=/oracle/lu8db/oradata/lu8db/control01.ctl
    output file name=/oracle/lu8db/oradata/lu8db/control02.ctl
    Finished restore at 2020-06-19 15:55:38
    
    RMAN> alter database mount;
    
    Statement processed
    released channel: ORA_DISK_1
    
    RMAN> recover database;
    
    Starting recover at 2020-06-19 15:56:21
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: SID=135 device type=DISK
    allocated channel: ORA_DISK_2
    channel ORA_DISK_2: SID=261 device type=DISK
    allocated channel: ORA_DISK_3
    channel ORA_DISK_3: SID=379 device type=DISK
    allocated channel: ORA_DISK_4
    channel ORA_DISK_4: SID=11 device type=DISK
    
    starting media recovery
    
    archived log for thread 1 with sequence 4 is already on disk as file /oracle/lu8db/oradata/lu8db/redo01.log
    archived log file name=/oracle/lu8db/oradata/lu8db/redo01.log thread=1 sequence=4
    media recovery complete, elapsed time: 00:00:03
    Finished recover at 2020-06-19 15:56:26
    RMAN> alter database open resetlogs;
    
    Statement processed
    
    RMAN> alter pluggable database all open;
    
    Statement processed
  • 相关阅读:
    ZT 安卓手机的安全性 prepare for Q
    ZT pthread_cleanup_push()/pthread_cleanup_pop()的详解
    <Lord don’t move that mountain>
    C++浅拷贝和深拷贝的区别
    001 Python简介 输入输出
    016 可等待计时器对象.6
    016 EventDemo 5
    016 事件内核对象4
    016 内核对象的Signal状态3
    016 句柄2
  • 原文地址:https://www.cnblogs.com/tingxin/p/13163538.html
Copyright © 2020-2023  润新知