查看控制文件位置

SQL> select * from v$controlfile;

STATUS     NAME                                        IS_ BLOCK_SIZE FILE_SIZE_BLKS
------- ------------------------------------------------------------ --- ---------- --------------
     /data/oracle/oradata/jactest/control01.ctl               NO       16384            594
     /data/oracle/flash_recovery_area/jactest/control02.ctl          NO       16384            594

删除其中一个控制文件

[oracle@JacTest01 jactest]$ rm control02.ctl

数据库日志报出如下错误信息：

Errors in file /data/oracle/diag/rdbms/jactest/jactest/trace/jactest_m000_15102.trc:
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/data/oracle/flash_recovery_area/jactest/control02.ctl'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

恢复方法(需要停机)

关闭数据库

SQL> shutdown immediate
Database closed.
ORA-03113: end-of-file on communication channel
Process ID: 15514
Session ID: 13 Serial number: 9216

拷贝完整的控制文件替代损坏控制文件

cp /data/oracle/oradata/jactest/control01.ctl /data/oracle/flash_recovery_area/jactest/control02.ctl

重新启动数据库

SQL> startup
ORACLE instance started.

Total System Global Area 1286066176 bytes
Fixed Size              2213016 bytes
Variable Size          1006635880 bytes
Database Buffers     268435456 bytes
Redo Buffers              8781824 bytes
Database mounted.
Database opened.

ITPub博客

某个控制文件损坏的恢复案例

最新文章