Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003

    Exclamation Unanswered: Need help with media recovery on database

    I have received the following error on my database:

    ORA-01113: file 7 needs media recovery
    ORA-01110: data file 7: 'D:\ORACLE\ORADATA\CMTEST\.ORA'

    I've had the same error before but it was a TEMP01.dbf file and I was able to recreate that file. I have searched for solutions on how to recover the .ORA file but found nothing. Can someone please help me with a solution??

  2. #2
    Join Date
    Jan 2004
    You have a datafile called .ora?
    Oh well.

    login as sysdba

    startup mount;

    alter database recover datafile 'D:\ORACLE\ORADATA\CMTEST\.ORA';
    Last edited by SkyWriter; 12-08-05 at 17:29. Reason: Typo

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts