How to delete Missing archive log file I’d needed to stop archive log mode for some reason.

When I tried to change the mode message told me to some file have been missing.

Alter database noarchivelog;

ORA-01111: name for data file 5 is unknown - rename to correct file

ORA-01110: data file 5: 'C:\APP\JAC484\PRODUCT\11.2.0\DBHOME_1\DATABASE\MISSING00005'


SQL&gt; select FILE#,ERROR from v$recover_file where FILE#=5;

FILE# ERROR

---------- ------------------------------------------------

 5 FILE MISSING


SQL&gt; select file_id ,file_name from dba_data_files where file_id in (select FILE
    # from v$recover_file where ERROR like 'FILE MISSING' and FILE# = 5);

FILE_ID

----------

FILE_NAME

--------------------------------------------------------------------------------

5

C:\APP\JAC484\PRODUCT\11.2.0\DBHOME_1\DATABASE\MISSING00005


I’d like to recover or delete above MISSING00005 file.

However, there isn’t any physical file.

Does anyone know how to operate?

I've already delete archivelog all; from RMAN.
Il looks like you (or someone else) deleted the file n°5 BEFORE you were putting DB in noarchivelog.
You have to restore this file from a previous backup and recover it to the time you stopped the DB for your operation.