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

Thread: corrupted control file

  1. #1
    Join Date
    Dec 2000
    Posts
    18
    how do I recover form a corrupted control file,

    I only have one control file, was not able to create a duplicate copy.

    how do I recover.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you have to recreate one.
    do you have a backup of it?
    if not you will have to do all these manually

    shutdown the database
    startup nomount
    create controlfile blah blah (check documentation for this part)
    alter database open

  3. #3
    Join Date
    Jun 2000
    Location
    Chennai/India
    Posts
    90
    Remember to have additional control files when u create a new one this time.
    A Winner never Quits, A Quitter never Wins
    Ganesh .R

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