control file missing !
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: control file missing !

  1. #1
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316

    control file missing !

    What happens if 1 of the 3 control files is deleted ?

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    nothing...
    remove the missing controlfile entry from the init parameter file :-)
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Jan 2003
    Location
    india(bangalore )
    Posts
    14
    hello khussain

    AS u know control files . where every thing lies . in case if your control file as been deleted . think that your database as gone . but in case if your more than one control files . it is very good . if try to second ctr files . your have many optional . to get the data from the control files
    abdulkhadeer

  4. #4
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316
    This is my understanding, just wanted to confirm it:

    if 1 of the 3 control files is deleted (or the disk that it is on, and its mirror goes bad) while the database is running, the database will not even write any errors to the alert log until shutdown time ?

    At that time, will I have to abort the instance, fix the init.ora or copy the control file, and restart the database ?

  5. #5
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    You should not need to abort the instance, however you will need to either 'fix' the init.ora or get a new copy of the control file before you can restart the instance.

    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!

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