IDES System crtl Files are Deleted

In my ides system my crtl files are deleted which are there in the oracle directory deleted? They are necessary for the database to open.

In such case when I am running the MMC it shows msg server and dispatcher + work connected and working ,
but when I try to connect thrugh Sapgui , it does not connect and says a msg to reconnect y/n . and the sap dispather + work turns off.

If you are sure that only the CTRL (Oracle Database control file) has been deleted then  It is possible to recreate then using the trace file (the trace file can be generate if your database is still UP: (If database is not UP the adjust the attached file as per your system)

IMPORTENT : The following command can only be applied if you have Oracle as your DataBase .

at SQL prompt
connect / as sysdba;
alter database backup controlfile to trace resetlogs;

alter system switch logfile;
repeat above command ,once per redolog group(4 time is your case)

It will create a file at %SAPTRACE%\usertrace\ directory which contain a script for automatic change of the control file. It will be used to recover the database rename it to recovery.sql ; delete its contents before the CREATE CONTROL FILE command ;

shutdown the database and then do the following (either normal or immediate)

connect / as sysdba;
@ recovery.sql;
It may ask you the archive name which still didnt created
Try to give it the online redo log path and name (one from one group ) Once DataBase will be recovered and openedthen try to start the SAP System ,if still the SAP system didnt UP ,as Markus said send your latest log file from "work" folder to group.

RECOVERY.SQL
***********************
CREATE CONTROLFILE REUSE DATABASE "ARF" RESETLOGS ARCHIVELOG MAXLOGFILES 255 MAXLOGMEMBERS 3 MAXDATAFILES 254 MAXINSTANCES 50 MAXLOGHISTORY 1134 Logfile Group 1 ('D:\Oracle\ARF\logA\ORIGLOGA.LOG','D:\Oracle\ARF\logB\mirrloga.log')
size 50M,
Group 2 ('D:\Oracle\ARF\logA\origlogb.log','D:\Oracle\ARF\logB\mirrlogb.log')
size 50M
datafile
'D:\Oracle\ARF\sapdata1\roll_1\ROLL.DATA1' , 'D:\Oracle\ARF\sapdata1\system_1\SYSTEM.DATA1' , 'D:\Oracle\ARF\sapdata1\temp_1\TEMP.DATA1' , 'D:\Oracle\ARF\sapdata2\es46dd_1\ES46DD.DATA1' , 'D:\Oracle\ARF\sapdata3\btabd_1\BTABD.DATA1' , 'D:\Oracle\ARF\sapdata3\btabd_2\BTABD.DATA2' , 'D:\Oracle\ARF\sapdata3\ddicd_1\DDICD.DATA1' , 'D:\Oracle\ARF\sapdata3\ddici_1\DDICI.DATA1' , 'D:\Oracle\ARF\sapdata3\el46dd_1\EL46DD.DATA1' , 'D:\Oracle\ARF\sapdata3\sourcei_1\SOURCEI.DATA1' , 'D:\Oracle\ARF\sapdata4\clud_1\CLUD.DATA1' , 'D:\Oracle\ARF\sapdata4\clui_1\CLUI.DATA1' , 'D:\Oracle\ARF\sapdata4\dimd_1\DIMD.DATA1' , 'D:\Oracle\ARF\sapdata4\dimi_1\DIMI.DATA1' , 'D:\Oracle\ARF\sapdata4\docud_1\DOCUD.DATA1' , 'D:\Oracle\ARF\sapdata4\el46di_1\EL46DI.DATA1' , 'D:\Oracle\ARF\sapdata4\factd_1\FACTD.DATA1' , 'D:\Oracle\ARF\sapdata4\facti_1\FACTI.DATA1' , 'D:\Oracle\ARF\sapdata4\loadd_1\LOADD.DATA1' , 'D:\Oracle\ARF\sapdata4\loadi_1\LOADI.DATA1' , 'D:\Oracle\ARF\sapdata4\odsd_1\ODSD.DATA1' , 'D:\Oracle\ARF\sapdata4\odsi_1\ODSI.DATA1' , 'D:\Oracle\ARF\sapdata4\pooli_1\POOLI.DATA1' , 'D:\Oracle\ARF\sapdata4\protd_1\PROTD.DATA1' , 'D:\Oracle\ARF\sapdata4\user1d_1\USER1D.DATA1' , 'D:\Oracle\ARF\sapdata4\user1i_1\USER1I.DATA1' , 'D:\Oracle\ARF\sapdata5\btabi_1\BTABI.DATA1' , 'D:\Oracle\ARF\sapdata5\docui_1\DOCUI.DATA1' , 'D:\Oracle\ARF\sapdata5\es46di_1\ES46DI.DATA1' , 'D:\Oracle\ARF\sapdata5\proti_1\PROTI.DATA1' , 'D:\Oracle\ARF\sapdata5\sourced_1\SOURCED.DATA1' , 'D:\Oracle\ARF\sapdata6\poold_1\POOLD.DATA1' , 'D:\Oracle\ARF\sapdata6\stabi_1\STABI.DATA1'
CHARACTER SET WE8DEC;
rem RECOVER DATABASE USING BACKUP CONTROLFILE
rem ALTER DATABASE OPEN RESETLOGS;
 

*****************
1. Cahnge the <SID> (Currently ARF SAP 4.6C oracle 9.20)
2. Change the path of online redo log or adjust as per your SAP system 
3. Adjust the path & name of DATAFILES 
4. the last two command are remarked so run then individually once your control file have been created.

Fast Links:
How To Restrict Transport Access
Restrict The Transport Access In Production

Get help regarding your Basis problems
Do you have a SAP Basis Question?

SAP Books
SAP Certification, Functional, Basis Administration and ABAP Programming Reference Books

SAP Basis Tips
SAP BC Tips and Basis Components Discussion Forum

Administration In SAP - Sapgui, Unix, SAP ITS, Router, Client Copy and IDES 

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG. 
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk. 
 The content on this site may not be reproduced or redistributed without the express written permission of 
www.erpgreat.com or the content authors.