Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00221: Error On Write To Control File

1063598Feb 4 2014 — edited Feb 4 2014

Experts,

Recently I was unable to connect to em12c console and after looking at the status of oms, I came to know that my database instance has crashed.

OMS status

./emctl status oms

Oracle Enterprise Manager Cloud Control 12c Release 2

Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.

WebTier is Up

Oracle Management Server is not functioning because of the following reason:

Failed to connect to repository database. OMS will be automatically restarted once it identifies that database and listener are up.

I logged in and verified the alert log which had below I/O errors on the controlfile. I'm afraid to say that my control files are not multiplexed and I do not have a valid backup of controlfile.

alert_log

Errors in file /u01/app/oracle/diag/rdbms/trcoem/TRCOEM/trace/TRCOEM_lgwr_25655.trc:

ORA-00345: redo log write error block 39818 count 15

ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/TRCOEM/redo01.log'

ORA-27072: File I/O error

Linux-x86_64 Error: 5: Input/output error

Additional information: 4

Additional information: 39818

Additional information: -1

Tue Jan 28 11:34:57 2014

Errors in file /u01/app/oracle/diag/rdbms/trcoem/TRCOEM/trace/TRCOEM_ckpt_25659.trc:

ORA-00206: error in writing (block 3, # blocks 1) of control file

ORA-00202: control file: '/u01/app/oracle/oradata/TRCOEM/control01.ctl'

ORA-27072: File I/O error

Linux-x86_64 Error: 5: Input/output error

Additional information: 4

Additional information: 3

Additional information: -1

Errors in file /u01/app/oracle/diag/rdbms/trcoem/TRCOEM/trace/TRCOEM_ckpt_25659.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: '/u01/app/oracle/oradata/TRCOEM/control01.ctl'

ORA-27072: File I/O error

Linux-x86_64 Error: 5: Input/output error

Additional information: 4

Additional information: 3

Additional information: -1

Tue Jan 28 11:34:57 2014

CKPT (ospid: 25659): terminating the instance due to error 221

Please assist me what should be the workaround to fix this error. Is this just a I/O error on the controlfile, or do I have a disk failure?

/var/log/messages http://www.filedropper.com/messages

OS Version: RHEL 5 (64 bit)

Database Version: 11.2.0.3 (64 bit)

Thanks

This post has been answered by 1063598 on Feb 4 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2014
Added on Feb 4 2014
2 comments
11,185 views