-
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
-
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
-
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.