遇到ora-00206

Thu Jun 16 00:25:30 2011
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_ckpt_151720.trc:
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: '/oradata/orcl/control03.ctl'
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 78: Connection timed out
Additional information: 10
Additional information: 3
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: '/oradata/orcl/control02.ctl'
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 78: Connection timed out
Additional information: 10
Additional information: 3
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: '/oradata/orcl/control01.ctl'
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 78: Connection timed out
Additional information: 10
Additional information: 3
Thu Jun 16 00:25:30 2011
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_ckpt_151720.trc:
ORA-00221: error on write to control file
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: '/oradata/orcl/control03.ctl'
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 78: Connection timed out
Additional information: 10
Additional information: 3
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: '/oradata/orcl/control02.ctl'
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 78: Connection timed out
Additional information: 10
Additional information: 3
ORA-00206: error in writing (block 3, # blocks 1) of control file
ORA-00202: control file: '/oradata/orcl/control01.ctl'
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 78: Connection timed out
Additional information: 10
Additional information: 3
Thu Jun 16 00:25:30 2011
CKPT: terminating instance due to error 221
Termination issued to instance processes. Waiting for the processes to exit
Thu Jun 16 00:25:40 2011
Instance termination failed to kill one or more processes
Instance terminated by CKPT, pid = 151720
Thu Jun 16 07:13:59 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.

值得注意的是ora00206不代表控制文件就损坏了。

还的看hba ,光纤线,光纤交换机,存储的连接上。

事后查明,这是光纤线结构松动导致的 oracle 无法写控制文件。

[@more@]
请使用浏览器的分享功能分享到微信等