Oracle Database Discussions

Hi,

I got an error in my alert.log, due to a corrupt datafile.

Last month, I faced a database crash but I could recover the whole database issuing a recover database untill cancel and since them, the database is ok.

Now, I´m facing and error every day in my alert.log, according error below:

Thu Oct 7 16:00:44 2010
Errors in file /u01/app/oracle/admin/ESEC/bdump/esec_j001_21791.trc:
ORA-12012: error on auto execute of job 8898
ORA-00376: file ORA-00376: file 302 cannot be read at this time
ORA-01110: data file 302: '/u04/oradata/sent_auditd_3.dbf'
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 34
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 76
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 1368
ORA-06512: at "SYS.DBMS_STATS", line 19278
cannot be read at this time

Since this recover, I´m not able to recover this specific datafile. I tried to put it offline for drop and goes successfully but I´m still facing the error message.

So, I copied this datafile to another partition and renamed it and the datafile in another partition is working fine but due this reference, I´m facing the error.

Is it possible to remove this reference from database, due to avoid this error, once this datafile '/u04/oradata/sent_auditd_3.dbf' doesn´t exist anymore?

SQL> SELECT * FROM V$VERSION;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production


Thanks in advance.