0

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> 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\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.

3
  • Strange message. Are you in Mount State? Commented May 23, 2017 at 16:15
  • Hi, any news on your issue ? Commented Jun 1, 2017 at 16:35
  • Nothing has been changed. Also, I can mount and I can even open without any error messages. Commented Jun 5, 2017 at 6:45

1 Answer 1

0

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.

6
  • Sorry, I didn’t backup this file. I can’t recover by this way. Commented Jun 5, 2017 at 7:11
  • Ouch ! Try follow this Commented Jun 6, 2017 at 17:45
  • 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. Commented Jun 6, 2017 at 17:50
  • I didn't do your way.However I have been to able to change 'archivelog' mode to `noarchivelog' mode as I wanted. Commented Jul 10, 2017 at 7:58
  • Could you please describe what you've done ? For passing by people's enlightment. Commented Jul 26, 2017 at 13:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.