Hi John,

Try to find out from the Alert log and trace file what the problem is.You are lucky I hope this is just the Temporary datafile and does not hold any data.I had tried two options

First thing take a backup of the corrupted datafile

Option 1

I tried to restore from my latest backup which had not worked

Option 2

Perform the following steps

a) Start the database in mount mode

svrmgr> startup mount

b) Perform an offline drop of the data file that is the temp
Iam assuming there is no data in that data file if there is
any data in the data file do not perform the below steps
execute the following command

svrmgr>Alter database dbname
datafile 'h:\temp1' offline drop;

Replace dbname with the name of ur database and specifiy
the path of the datafile

c) Then open the database using the following
command

svrmgr>alter database open;

Regards