My Oracle Support Banner

DB fails due to ORA-63999 ORA-01114 and ORA-27061 but no corruption found (Doc ID 1557694.1)

Last updated on AUGUST 31, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample schema(s),
Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual environments, actual persons, living or dead,
is purely coincidental and not intended in any manner.

For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:

Directory - Mount Point = /vol/oemdbaud01_archive/archive,vol/oemdbaud01_data/databases,/vol/oemdbaud01_oracle/oracle,
/archive,/databases and /usr/local/oracle

 

 

Database crashed and failed to start up due to these errors. The database is on a NAS. The Unix team did not find any issues with the NAS.

Mon Apr 29 18:50:48 2013
KCF: read, write or open error, block=0x1b70 online=1
  file=3 '/databases/<oracle_sid>/undotbs01.dbf'
  error=27061 txt: 'Linux-x86_64 Error: 5: Input/output error
Additional information: -1
Additional information: 131072'
Errors in file /<path>/diag/rdbms/<db_name>/<oracle_sid>/trace/<oracle_sid>_dbw0_<pid>.trc
ORA-63999: data file suffered media failure
ORA-01114: IO error writing block to file 3 (block # 7024)
ORA-01110: data file 3: '/databases/<oracle_sid>/undotbs01.dbf'
ORA-27061: waiting for async I/Os failed
Linux-x86_64 Error: 5: Input/output error
Additional information: -1
Additional information: 131072
DBW0 (ospid: 5508): terminating the instance due to error 63999


Additional Information:
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
filesystemio_options string setall
disk_asynch_io boolean TRUE

Changes

 The Unix system administrator performed some changes at the operating system level

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.