Controlfile

[sona]

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

[jovery]

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

[Sureshy]

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.