Powered By

Free XML Skins for Blogger

Powered by Blogger

Sunday, February 8, 2009

SAP IDES System crtl Files are Deleted

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

rem RECOVER DATABASE USING BACKUP CONTROLFILE
rem ALTER DATABASE OPEN RESETLOGS;

*****************
1. Cahnge the (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 .

No comments:

Archives