Media recovery
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Media recovery

  1. #1
    Join Date
    Nov 2003
    Posts
    89

    Media recovery

    I did full backup of my database last night and started the database succesfully . For maintainence we had to restart the unix machine. When restarting the machine there were two disks which got corrupted. We replaced the disks and restored those datafiles on to disk.

    I started the database and got needs media recovery. So I shutdown the database and started in mount and gave the command recover. It did say media recover done. Then I I started database by , alter database open.

    I was going through some of the media recovery forums and I found that I have to give recover database until cancel and apply archive logs.

    After by database full back up was done there was no transactions done. Kindly let me know if my procedure is correct.

    Thanks

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    Re: Media recovery

    Originally posted by srt

    I was going through some of the media recovery forums and I found that I have to give recover database until cancel and apply archive logs.

    That would be for incomplete media recovery. You had a complete recovery. You did exactly what you should have.
    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