Re: missing datafile

First of all I would like to know whether the database is running in ARCHIVAL or NOARCHIVAL mode.

If the database is running in NO ARCHIVAL mode, then you can adopt 2 strategies.

1. Restore the complete DB from backup and manually roll-forward
2. If you think that users tablespace is not required, then you can drop that tabespace and start the database

If the database is running or archival mode, you can restore all the files and automatically roll forward with the help of archived files.

Regards

N.Prabhakar

Shuang Li <sli1_at_cs.umbc.edu> wrote in article <33DAC4C6.41A4_at_cs.umbc.edu>...
> 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.
>
Received on Thu Jul 31 1997 - 00:00:00 CDT