ORA-01111: Name For Data File Is Unknown

Posted by big on Oct 28, 2021; 5:48am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ORA-01111-Name-For-Data-File-Is-Unknown-tp10375.html

Hi,
I have this error:
select count(*) from AUDSYS.UNIFIED_AUDIT_TRAIL
                            *
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: $ORACLE_HOME/dbs/MISSING00008

ls $ORACLE_HOME/dbs/MISSING00008

$ORACLE_HOME/dbs/MISSING00008 not found

Also I queried database:
select * from v$recover_file where error like '%FILE%';

     FILE# ONLINE  ONLINE_ ERROR         CHANGE# TIME          CON_ID
---------- ------- ------- ---------- ---------- --------- ----------
         8 OFFLINE OFFLINE FILE                0                    0
                           MISSING

SQL> select name from v$datafile where name like '%UNNAMED%';

no rows selected

What is the solution? We are not in RAC. Usually the proposed soultions are for RAC.

Thanks.