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
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 |