恢复控制文件错误,数据库不能打开
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