database recovery question

[nyck]

One of my users last week attempted to clone a database and now when he does the below command its fails:-

SQL> truncate table local_server_id;
truncate table local_server_id
*
ERROR at line 1:
ORA-00376: file 8 cannot be read at this time
ORA-01111: name for data file 8 is unknown - rename to correct file
ORA-01110: data file 8: '/ora1/app/oracle/product/9.2.0.7/dbs/MISSING00008'

I have looked in oracle enterprise manager and that particular datafile is there but its offline. I have tried to bring it online but that just does nothing. Any suggestions on what I can do to get this working again?

 

[KenCunningham]

Are you sure that when the database was cloned, all file names were exactly correct as per the clone script?

I want to be good, is that not enough?

 

[nyck]

Yes, I think my user did not perform this process correctly. I will double check with him!

Other than that error message the database starts up with no errors which has too be a good thing. So how straight forward would it be to remove this second datafile from the tablespace?