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