now I have 2 copies of control files on same disk,suppose I add one in init.ora,then does that automatically gets created during db start or I will be placing a copy in the new location and then restart db.
all your suggestions helped alot,and regarding mts ,can anybody say is it recommended not to use mts after oracle 7.3 and if so why???
i tried to give the create controfile option in svrmgrl. but it says oracle not connected. i tried connecting as internal, sys as sysdba, etc. but the same problem persists. documentation says i need OSDBA granted, but how do i do it ?
yes i did try with all three control files. but none of them works. all three of them are of same size. does it mean all three are corrupt ? i tried recreating but that is the problem. when i connect to svrmgrl and say create control file, it gives me an error saying oracle not connected. what do i do ?
tried that. works fine. great. now i am trying to create the control file. my old control files didnt work. i tried. besied, being of the same size, they are also last modified at the same time. what does that mean ? anyway, will write back as soon as i create the control file. thanks a lot.
may use NT comp command to compare control files: they should be the same.
how it happened control files get lost? Are you sure now that your HW/OS is OK? I saw a case how control files where lost because of disk controler problem. Then HW problem had to be fixed first before proceeding.
itīs not lost, corruption of blocks.
Of course control files have same modified time, they are mirrored copies. Mirror means clone, if you look yourself at the mirror you see another you.... hope this helps