My Oracle Support Banner

ORA-01110 ORA-01565 ORA-27037 after recreating the controlfile, with filename as MISSING000XX under $ORACLE_HOME/dbs (Doc ID 2983485.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 19.21.0.0.0 [Release 11.2 to 19]
Information in this document applies to any platform.

Symptoms

ORA-01110: data file 10: '/refresh/home/app/19.3.0.0/oracle/product/19.3.0.0/dbhome_6/dbs/MISSING00010'
ORA-01565: error in identifying file '/refresh/home/app/19.3.0.0/oracle/product/19.3.0.0/dbhome_6/dbs/MISSING00010'
ORA-27037: unable to obtain file status

SYS AS SYSDBA>select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/system01.dbf
/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/test01.dbf
/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/sysaux01.dbf
/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/undotbs01.dbf
/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/rman01.dbf
/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/users01.dbf
/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/test02_01.dbf
/refresh/home/app/19.3.0.0/oracle/oradata/ORCL19300/test02_02.dbf
/refresh/home/app/19.3.0.0/oracle/product/19.3.0.0/dbhome_6/dbs/MISSING00010

 

Changes

 Customer recreated the controlfile

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


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