DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: What are the steps to recover the control file from a total lose?

  1. #1
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925

    Question

    I'm wondering how do one recover/recreate the controll file from a total lose?

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  2. #2
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    One way is to take it from backup provided nothing changed since the backup.

    Or, create it by specifying the correct paths of all the logfiles, datafiles.

    It should work.
    Thanks
    Kishore Kumar

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Do you have controlfile thats backed up to trace/some other location by any chance. I request my dba team to make a habbit of it whenever they do some maintenance/backups work. It helps a lot...

    Its lot easier, if you do have.

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