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

Thread: Without Controlfile!!

  1. #1
    Join Date
    Mar 2001
    Posts
    6
    Is it possible to start the instance if the Controlfile is Lost or got corrupted...

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    No, but if you have mirrored copy you can.
    If you dont have any then you could recrete the controlfile and start the database

  3. #3
    Join Date
    Mar 2001
    Posts
    6
    I think there is one possibility of mounting the instance for creating the controlfile.. i.e. by changing the value of INIT Parameter.

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    mam,

    I am curious to know, if you could recollect or point to the source where it has been mentioned.
    Reddy,Sam

  5. #5
    Join Date
    Jan 2001
    Posts
    71
    If not all control lost, instance can still be started, but cannot use database.

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I dont see very clear your point wreno, you can always start an instance without a control file since the instance is started in nomount state and control file is read in mount state (instance is started before control file comes into play), actually to create or recreate a control file you first start an instance to do it

  7. #7
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    I think you can make a

    alter database backup controlfile to trace

    if the database is not mounted, you then resolve the problem by recreating your control file ...

  8. #8
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    If the database is not mounted then the database has no idea what is the content of the controlfile and thus you can't isue BACKUP CONTROLFILE TO TRACE!

    What happens (regarding init, control, log and data files) during each startup phase:

    1. NOMOUNT: Instance reads the init.ora (this file also specifies where the instance should look for the control files)

    2. MOUNT: Instance opens and locks the controlfiles, specified in the init.ora (controlfile includes all informations regarding redolog and database files)

    3. OPEN: Instance reads and locks all redologs and database files and makes the database available for users.

    So you must be at lest in the MOUNT mode to get the information contained in controlfile.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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