Ides. cannot be started normally, and the Oracle data file is damaged.

Goller. cn sap Education	Sponsor Link
Www.goller.cn

Thank you!

Due to a power failure, the entire operating system is shut down abnormally, resulting in an accident. after sap idesdoes not start normally. After manually starting r3system, the system consolfinds that the disp?work.exe process stops automatically one minute after being started, and the SAP R3 IDES system becomes unavailable. after troubleshooting, it is found that the cause of the fault is caused by the destruction of the Oracle data file.

Troubleshooting process:
1. The R3 IDES system cannot be started normally;
2. After the R3 IDES system is started, mmcfinds that the dispworker work.exe process stops automatically less than one minute after it starts;

3. confirm that the Oracle service is normal through services. MSC and "Net start;
4. manually stop the database... the problem is found from here;

Microsoft Windows [version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:/Documents and Settings/Administrator>Sqlplus/nolog

SQL * Plus: Release 9.2.0.2.0-production on Sat Sep 15 22:32:26 2007

Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.

SQL>Conn/As sysdba
Connected.
SQL> shutdown immediate
ORA-01109: Database not open

Database dismounted.
Oracle instance shut down.

Start the database:

SQL>Startup
Oracle instance started.

Total system global area 454630212 bytes
Fixed size 453444 bytes
Variable Size 251658240 bytes
Database buffers 201326592 bytes
Redo buffers 1191936 bytes
Database mounted.
ORA-01122: database file 1 failed verification check
ORA-01110: Data File 1: 'z:/Oracle/r3d/sapdata1/system_1/system. data1'
ORA-01207: file is more recent than controlfile-old controlfile

SQL>Select sequence #, status, first_change # from V $ log;
Sequence # status first_change #
---------------------------------------
1185 inactive 4399043
1186 active 4399309
1187 active 4399835
1188 current 4400731

SQL>Select name, checkpoint_change # from V $ database;
Name checkpoint_change #
---------------------------
R3d 4399835

SQL>Select * from V $ controlfile;
Status
-------
Name
--------------------------------------------------
Z:/Oracle/r3d/origloga/cntrl/cntrlr3d. DBF
Z:/Oracle/r3d/saparch/cntrl/cntrlr3d. DBF
Z:/Oracle/r3d/sapdata1/cntrl/cntrlr3d. DBF

Replace control files in three locations in turn

When you replace the cntrlr3d. DBF control file in the "z:/Oracle/r3d/sapdata1/cntrl/" directory, the following message is displayed:

SQL>Startup
Oracle instance started.

Total system global area 454630212 bytes
Fixed size 453444 bytes
Variable Size 251658240 bytes
Database buffers 201326592 bytes
Redo buffers 1191936 bytes
Database mounted.
ORA-01113: file 3 needs media recovery
ORA-01110: data file 3: 'z:/Oracle/r3d/sapdata1/r3d_2/r3d. data2'

Restore database

SQL>Recover database;
Media recovery complete.
SQL>Alter database open;
Database altered.

Start sap R3 ides. Normal!