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

Thread: Controlfile

  1. #1
    Join Date
    Apr 2002
    Posts
    135
    hai,

    I am not sure.I have three controlfiles .
    Initially will there be 3 controlfiles or what???


    Actually my problem is somehow i lost my second controlfile.
    i managed to mount the DB by changing the initfile.
    but will there be a problem.
    or otherwise how to create the second file

    deepa
    Good Judgement comes from Experience.
    Experience comes from Bad Judgement

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    You only actually need 1 control file but typically you have at least 2 (basically because of the problem you have just had). To recreat the corrupt control file simply shut the database down and replace it with one of the other mirrors.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    The reason that 3 copies of the controlfile are used is because it is such an important file. Withou it, you can't start your database.

    You can actually start your instance/db with 1 controlfile, but it is recommended that you keep at leaset 3 copies on seperate disks.

    To recreate your second controlfile :

    shutdown database.
    Use OS commands to copy controlfile to another destination.
    edit your init.ora with paths to all controlfiles(including the one you just created)
    restart database.

    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

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