urgent - database can't open due to ORA-01113: file needs media recovery!!!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: urgent - database can't open due to ORA-01113: file needs media recovery!!!

  1. #1
    Join Date
    Apr 2001
    Posts
    124

    urgent - database can't open due to ORA-01113: file needs media recovery!!!

    Hi,

    Today I tried to restart my database, I got the following error when issuing startup command:

    Code:
    SQL> startup
    ORACLE instance started.
    
    Total System Global Area 2820219832 bytes
    Fixed Size                   455608 bytes
    Variable Size             671088640 bytes
    Database Buffers         2147483648 bytes
    Redo Buffers                1191936 bytes
    Database mounted.
    ORA-01113: file 10 needs media recovery
    ORA-01110: data file 10: 'D:\ORACLE\ORADATA\DB01.DBF'
    
    
    SQL> RECOVER DATAFILE  'D:\ORACLE\ORADATA\DB01.DBF';
    ORA-00279: change 2250966028 generated at 09/24/2007 17:28:20 needed for thread
    1
    ORA-00289: suggestion :
    D:\ORACLE\ORADATA\ARCHIVE\DBT001S44739.ARC
    ORA-00280: change 2250966028 for thread 1 is in sequence #144739
    
    
    Specify log: {=suggested | filename | AUTO | CANCEL}
    
    ORA-00308: cannot open archived log
    'D:\ORACLE\ORADATA\ARCHIVE\DBT001S44739.ARC'
    ORA-27041: unable to open file
    OSD-04002: unable to open file
    O/S-Error: (OS 2) The system cannot find the file specified.
    Unfortunately I don't have the old archive log files. Please help!!!

  2. #2
    Join Date
    Dec 2007
    Posts
    55
    You need to restore all datafiles and perform an incomplete recover(CANCEL based).

  3. #3
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    check whether D:\ORACLE\ORADATA\ARCHIVE\DBT001S44739.ARC file is there or not. If not there copy that file to that location and start recovery.
    http://www.perf-engg.com
    A performance engineering forum

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Quote Originally Posted by malay_biswal
    check whether D:\ORACLE\ORADATA\ARCHIVE\DBT001S44739.ARC file is there or not. If not there copy that file to that location and start recovery.
    did you miss the part where he said he didnt have the archive logs

Posting Permissions

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



Click Here to Expand Forum to Full Width