Re: missing datafile

Shuang Li wrote:

> Hi,
> While trying to put "USERS" tablespace back online, I received the
> following error messages:
>
> ORA-01157: cannot identify data file 8 - file not found
> ORA-01110: data file 8: '/u01/oradata/csee/users04.dbf'
>
> I then check if /u01/oradata/csee/users04.dbf exists or not by looking
>
> into the directory /u01/oradata/csee/ and can't find file
> 'users04.dbf'
> either. It is greatly appreciated if anyone kindly suggests how to fix
>
> this problem.

If the data in the USERS tablespace is not of earth-shattering importance and you don't want to go back to the backup, then you can simply force and offline of this tablespace and drop it. However, be warned that you will lose everything in this tablespace (which is probably not the best option).

If you are in ARCHIVELOG mode, then you should recover from your most recent backup and restore all applicable archive logs. If you are not in ARCHIVELOG mode, then your only recourse (aside from what is mentioned above) is to do a full restore of the database.

--
====================================================================
Byron Pearce                         mailto:bpearce_at_csac.com
Systems Consultant                   http://www.csac.com
Computer Systems Authority (CSA)     Dallas, Texas

"It's hard to be a ninja when you wear a beeper."