|
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 .
SAP Basis Tips by : Arif
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
Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.sap-img.com
All the site contents are Copyright © www.sap-img.com
and the content authors. All rights reserved.
All product names are trademarks of their respective
companies. The site www.sap-img.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.sap-img.com or the content authors.
|