ORA-00205: error in identifying control file, check alert log for more info

mengzhaoliang發表於2009-08-10

 

1、啟動出錯
SQL> startup
ORACLE instance started.

Total System Global Area 3774873600 bytes
Fixed Size                  2025400 bytes
Variable Size             570427464 bytes
Database Buffers         3187671040 bytes
Redo Buffers               14749696 bytes
ORA-00205: error in identifying control file, check alert log for more info

2、alert_SID.log

Mon Aug 10 09:57:19 2009
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=1015820
Mon Aug 10 09:57:19 2009
starting up 1 shared server(s) ...
Mon Aug 10 09:57:19 2009
ALTER DATABASE   MOUNT
Mon Aug 10 09:57:22 2009
ORA-00202: control file: '/oracle/oradata/undo/cntrl/control03.ctl'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
Mon Aug 10 09:57:22 2009
ORA-205 signalled during: ALTER DATABASE   MOUNT...

原來oracle的資料檔案放在HP的EVA儲存中,HP儲存沒有掛載到系統中,把AIX系統的中後臺儲存掛載到系統中再啟動則行。

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/12778571/viewspace-611715/,如需轉載,請註明出處,否則將追究法律責任。

相關文章