Unable to open database - needs media recovery
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Unable to open database - needs media recovery

Hybrid View

  1. #1
    Join Date
    Sep 2004
    Posts
    54

    Unable to open database - needs media recovery

    Last week we had disk failure. Unfortunetly I have lost arch logs and trc files. When we were trying to start the database, we starting getting the following error:

    ORA-01113 file 8 needs media recovery.

    After reading arround we tried the followings:

    Startup nomount;
    recover database until cancel;
    [cancel]
    alter database open resetlogs;

    When we tried again, we started getting new error:

    ORA-01194: file 1 needs more recovery to be consistent;

    It is complaining onSYSTEM01.DBF file now. Please guide me how can open the database without latest logs and Tracefiles;

    Thanks in Advance.

    V.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    how about just RECOVER DATABASE?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Sep 2004
    Posts
    54
    Quote Originally Posted by marist89
    how about just RECOVER DATABASE?
    I have tried that same problem. Thanks

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Basically that error is telling you that all your files are not at a consistent point. Your system.dbf file needs to have more recovery applied (from redo or archived redo) in order to be consistent enough to open.

    What do you have for a backup?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Sep 2004
    Posts
    54
    Unfortuntely, we don't backup this server. It is one of our test server.

  6. #6
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    one hidden parameter can help this, remember do a backup once open. either full export/import.

    _ALLOW_RESETLOGS_CORRUPTION=TRUE

    DO IT ONLY YOU HAVE NO OTHER WAY TO RECOVER YOUR DATA.

    Pls be sure that it's not supported by Oracle and it may bring ur database to dangerous situation.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

  7. #7
    Join Date
    Sep 2004
    Posts
    54
    I have move a step further after finding some files from last months folder command. It don't have all the files but SYSTEM,CONTROL and REDOs.

    Now I am getting this error:

    ORA-0283: recovery session cancelled due to errors
    ORA-01112: database file 3 failed verification check
    ORA-01110: data file 3: g:\oradata\DWTEST\RBS01.dbf'
    ORA-01207: file is more recent then controlfile - old control file.

    Any ideas to move forward from here.

    Do you think, if try to take this rollback segment offline. will that going to work. Please advice.

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Quote Originally Posted by avion1
    Do you think, if try to take this rollback segment offline. will that going to work. Please advice.
    no.

    If it's a test database then just clone your production db, re-apply any changes and you're done.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  9. #9
    Join Date
    Sep 2004
    Posts
    54
    Thanks for the advice.

    But, I am trying to open database withot restoring from live. We are not bothered about loosing data. Cheers.
    Last edited by avion1; 08-02-2005 at 11:48 AM.

  10. #10
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Quote Originally Posted by avion1
    Thanks for the advice.
    We are not bothered about loosing data. Cheers.
    Then why not just create another database?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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