needs more recovery to be consistent - Page 3
DBAsupport.com Forums - Powered by vBulletin
Page 3 of 3 FirstFirst 123
Results 21 to 26 of 26

Thread: needs more recovery to be consistent

  1. #21
    Join Date
    Apr 2001
    Posts
    126
    I get this error when i tried from sqlplus.

    Enter user-name: sys as sysdba
    Enter password:
    ERROR:
    ORA-01033: ORACLE initialization or shutdown in progress



    **** Logged in as internal and tried and recd the error:..*****

    ALTER DATABASE OPEN RESETLOGS
    *
    ERROR at line 1:
    ORA-01507: database not mounted

  2. #22
    Join Date
    Apr 2001
    Posts
    126
    i open the database and now it is pointing to
    ORA-01113: file 1 needs media recovery
    ORA-01110: datafile1 d:\...\system.dbf

  3. #23
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    i dont know what to say here....

    Raise a TAR.

    if you have a backup then restore it. if not then you can say goodbye to your database.

    I hope this is not your prod db
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  4. #24
    Join Date
    Apr 2001
    Posts
    126
    Thanks for the support. this is not prod DB. i am re-creating the DB.

    I guess .This is one of the nice example for the disaster happended due to not enabling archive log, right? or having cold backup.

  5. #25
    Join Date
    Apr 2002
    Location
    France
    Posts
    118
    Originally posted by fordikon
    this is not prod DB. i am re-creating the DB..
    you've just killed me!

    If there is no solution, it is because there is no problem - Shadok -

  6. #26
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    This thread has really got me curious..can anybody tell me how do i reproduce his situation at my home ...i would like to know the steps in how we can reproduce this problem

    regards
    Hrishy

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