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
原文地址:https://www.cnblogs.com/tingxin/p/13163538.html