Friday, January 26, 2007

Datafiles named 'MISSING'

If you come across a datafile that has been named 'MISSING' with a five digit extension, this means that you have a datafile that the Data Dictionary knows about but which is not in your control file.
Example:

SVRMGR> select file_name from dba_data_file where tablespace_name ='TEST01';
FILE_NAME
-----------------------------------------
/database/804/vcrobins/data/test1.dbf
/oracle/8.0.5/dbs/MISSING00009

This can happen if you recreate your control file and you leave out or remove the datafile.

This can be fixed by either recreating your control file and adding the datafile with the correct name (if you know what it was before) or dropping and recreating your tablespace. (Make sure you have an export of all of the objectsin the tablespace before dropping it.)

SVRMGR> select file_name from dba_data_files where tablespace_name ='TEST01';
FILE_NAME
-----------------------------------------
/database/804/vcrobins/data/test2.dbf
/database/804/vcrobins/data/test1.dbf

No comments: