How to delete Missing archive log file

Question

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\PRODUCT11円.2.0\DBHOME_1\DATABASE\MISSING00005'
SQL> select FILE#,ERROR from v$recover_file where FILE#=5;
FILE# ERROR
---------- ------------------------------------------------
 5 FILE MISSING
SQL> 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\PRODUCT11円.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.

• Renato Afonso: Strange message. Are you in Mount State?
• Guillaume R.: Hi, any news on your issue ?
• user1345414: Nothing has been changed. Also, I can mount and I can even open without any error messages.

Answer 1

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.

• user1345414: Sorry, I didn’t backup this file. I can’t recover by this way.
• Guillaume R.: Ouch ! Try follow this
• Guillaume R.: And maybe restore an older backup on another machine, extract via datapump the missing data, but if the missing file is member of a multifile tablespace, I don't think you would be able to restore.
• user1345414: I didn't do your way.However I have been to able to change 'archivelog' mode to `noarchivelog' mode as I wanted.
• Guillaume R.: Could you please describe what you've done ? For passing by people's enlightment.