oracle 11gの制御ファイルがなくなったのでデータベースが起動することはきません
1.エラーメッセージ：
[oracle@centos ~]$ sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Sat Jan 25 09:31:04 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 661209088 bytes
Fixed Size 1338560 bytes
Variable Size 494928704 bytes
Database Buffers 159383552 bytes
Redo Buffers 5558272 bytes
ORA-00205: error in identifying control file, check alert log for more info
SQL>
2.解決方法：
[oracle@centos ~]$ ll app/oracle/oradata/orcl/control011.ctl //二つの制御ファイルを確認する
-rw-r—– 1 oracle oinstall 9748480 Jan 25 09:30 app/oracle/oradata/orcl/control011.ctl
[oracle@centos ~]$
[oracle@centos ~]$ ll app/oracle/flash_recovery_area/orcl/control02.ctl
-rw-r—–. 1 oracle oinstall 9748480 Jan 25 09:30 app/oracle/flash_recovery_area/orcl/control02.ctl
[oracle@centos ~]$ vim app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora //配置ファイルを開く、制御ファイル名を確認
*.control_files=’/home/oracle/app/oracle/oradata/orcl/control01.ctl’,’/home/oracle/app/oracle/flash_recovery_area/orcl/control02.ctl’ //制御ファイル名を修正
3.テスト：
[oracle@centos ~]$ sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Sat Jan 25 09:42:31 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>