Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2004
    Posts
    13

    Unanswered: Trouble Oracle DB Down / Need Assistance

    Hello,

    When I try to start our database I am getting the following errors.

    ORA-01172: recovery of thread 1 stuck at block 22880 of file 28
    ORA-01151: use media recovery to recover block, restore backup if needed

    Questions

    1) Are there any way to resolve these errors?

    2) If not, we have dmp.Z exports that are backed up daily. What is the best way to restore these?

    Note, I am an Oracle Newbie, but a quick learn.

    Thanks for your help in advance.

    cbarone@dca.net

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    No Operating System (OS) or version mentioned.
    No version of Oracle DB included.
    No hint as to whether DB is in archive mode or not.

    Clueless newbie in charge of recovering from this situation.
    >1) Are there any way to resolve these errors?
    It depends on unanswered details listed above.

    >2) If not, we have dmp.Z exports that are backed up daily.
    >What is the best way to restore these?

    export is NOT designed to be used DB backup & restore.
    It depend upon what type of export created the *dmp.Z files.

    You best bet & easiest "solution" is to restore the whole
    system from cold OS backups.

  3. #3
    Join Date
    Jan 2004
    Posts
    13
    No Operating System (OS) or version mentioned.

    Solaris 2.6

    No version of Oracle DB included.
    Oracle 8i

    No hint as to whether DB is in archive mode or not.
    Not in archive mode, this means I am screwed right?

    Clueless newbie in charge of recovering from this situation.
    I was thrown into this mess, not by choice.

  4. #4
    Join Date
    Jan 2004
    Posts
    37
    restore from coldbackup
    insert the dat in the dat drive and give the command
    tar xv8
    this may take ample time (depending on the size of your database)
    now check up if the database starts....

  5. #5
    Join Date
    Jul 2003
    Posts
    2,296
    are you at least using RMAN and cold backups?

    or, are you just exporting with no cold backup at all?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  6. #6
    Join Date
    Jan 2004
    Posts
    13
    are you at least using RMAN and cold backups?

    I dont think so.

    or, are you just exporting with no cold backup at all?

    Think we are exporting with no cold backups at all.

  7. #7
    Join Date
    Jul 2003
    Posts
    2,296
    well, it is tough to recover a database without a backup.
    if that is the case you could try mounting the db and issuing a recover database command.

    other than that, you could import your data into any existing oracle environment while you try to recover the downed environment.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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