Recovery without Backup (Moderater Plz)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Recovery without Backup (Moderater Plz)

  1. #1
    Join Date
    Aug 2001
    Posts
    134

    Thumbs down

    I am using Oracle 8.1.7 on win2000 AS, My database need media recovery,
    But i haven't any backup.
    I m in trouble bcoz the data is very important and i wanna recovery in urgent.
    Database Errors are
    ********************
    ORA-01172 - Recovery of thread 1 stuck set at block 191919 of file 22.
    ORA-01151 - Use media recovery to recover block, Restore backup if needed.

    Please help me
    Write command step by step
    Thanx

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well you said it, you dont have backup. How can you recover something without backup may I ask?

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by Jani
    But i haven't any backup.
    I m in trouble bcoz the data is very important and i wanna recovery in urgent.
    These statements are contradictory. How can the data be important if you don't back it up?


    Write command step by step
    1. Go home
    2. update resume
    3. post resume on monster.com, hotjobs.com, dbajobs.com, justoraclejobs.com, etc.
    4. cross fingers
    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."

  4. #4
    Join Date
    Feb 2002
    Posts
    59
    Is the db still up and running?

    If yes, can you do an exp? Then, create a new db and imp the data into it.

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    I have fixed minor corruption in a database where the required information was in the logfiles. You can try to do a manual database recovery and point to the log files when it asks for the rollback. If you have enough rollback in the log files you might be ok. Your database might not be as bad off as you think. Before you do a lot of experimenting a backup might be a good idea. Are you in archivelog mode? I guess after this experience you will be looking at daily exports and daily full backups as well as archivelog mode. You might also need to issue a recover statement against the affected datafile.

    Good Luck.

  6. #6
    Join Date
    Aug 2001
    Posts
    134

    Arrow 1. Go home

    Thats Great.

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