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

Thread: REGARDING CONTROL FILE

  1. #1
    Join Date
    Sep 2000
    Posts
    305

    Question

    Can anybody tell me what are the steps
    If control is corrupt
    this is very urgent plz. help me

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Here are some of the threads that discusses on this issue. Always first try to recover from your backup. If that doesn't work, <b>as a last resolution only choose to rebuild the control file </b>.


    [url]http://www.dbasupport.com/forums/showthread.php?threadid=7833[/url]

    [url]http://www.dbasupport.com/forums/showthread.php?threadid=5619[/url]

    [url]http://www.dbasupport.com/forums/showthread.php?threadid=5130[/url]

    [url]http://www.dbasupport.com/forums/showthread.php?threadid=3109[/url]

    [url]http://www.dbasupport.com/forums/showthread.php?threadid=1532[/url]

    Good luck
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    Follow these steps:
    1. Shutdown the database(if its running)
    2. Mount the database
    3. run this command
    svrmgr>alter database backup controlfile to trace;
    This creates trace file in USER_DUMP_DEST.
    4. Edit the trace file and remove header information and
    rename this file to say create_control.sql
    5. Shutdown database
    6. @create_control.sql
    7. alter database open

    GOOD LUCK
    Agasimani
    OCP(10g/9i/8i/8)

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