Database Administration (MOSC)

MOSC Banner

Datafiles missing for database

edited Mar 3, 2015 10:06AM in Database Administration (MOSC) 4 commentsAnswered

We are on 11.2.0.2...

On querying DBA_DATA_FILE, the file shows an abnormal name as can be seen below -

SQL> select file_id, file_name from dba_data_files where tablespace_name = 'PTAMSG';

FILE_ID FILE_NAME

---------- ----------------------------------------

223 /u03/oradata/CPSFSSP5/ptamsg02.dbf

142 /u03/oradata/CPSFSSP5/ptamsg.dbf

235 /u02/app/oracle/product/11.2.0.2/cpsfssp

5/dbs/MISSING00235

See the file_ID 235 shows the filename as MISSING00235

Also, when checked the file's status, it shows as offline -

235 OFFLINE READ WRITE

Tried to bring it online, but got the error -

SQL> alter tablespace PTAMSG online;

alter tablespace PTAMSG online

*

ERROR at line 1:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center