Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    1

    Question Unanswered: ORA-01113: file 8 needs media recovery

    in our oracle server there is 2 harddisk.second hard disk include dbf file and we copied these files to another(third) harddisk because sometimes we take harddisk error but we didnt backup database.and last, hard disk crashed ,now we use other hdd(third) instead of second hdd.but when i start service from command prompt i take an error like
    ORA-01113: file 8 needs media recovery
    ORA-01110: data file 8: 'E:\ORACLE\ORADATA\TESTDB\ABOD01.DBF'
    previous path and new path is same and file (ABOD01.DBF) on this path.
    i began to work oracle for two weeks,how can i solve this problem,

  2. #2
    Join Date
    May 2004
    Location
    Germany
    Posts
    25
    I hope you are working in archivelog mode.
    Connect to oracle as sysdba and enter:
    select log_mode from v$database;
    if you get ARCHIVELOG as result continue with the next line.
    alter database recover automatic database;
    if you are not in archivelogmode it could be a little bit more difficult and you may have loose some of your data.

Posting Permissions

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