Server crash, database and RMAN recovery catalogs lost
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Server crash, database and RMAN recovery catalogs lost

  1. #1
    Join Date
    Sep 2001
    Posts
    10
    I found myself in an interesting delima today. My server crashed and I lost all databases, including my recovery catalogs. I have tape backups but am not sure how to get RMAN to work with a specific backup set. Is this a situation where I need to work with Oracle Worldwide Support?

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Absolutely!
    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
    Dec 1999
    Location
    Cincinnati, Ohio USA
    Posts
    99
    One thing that you should do in the future is to move your catalog to a server that does not contain data for the database you will may need to recover. This is highly recommended.
    Doug

  4. #4
    Join Date
    Oct 2000
    Posts
    467
    If you know the db_key of your last incarnation..you can retrieve the information from the tapes.
    Just install the rman catalogue, recreate your db and register it. Then change the incarnation to the old one and restore your backups. I think this should work.
    Pls do correct me if i'm wrong.


    Cheers,
    Vinit

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