学步园

衷心感谢 "六横"兄!

由于一次停电,导致整个操作系统异常关闭,造成事故.此后SAP IDES无法正常启动.当手工启动R3系统后,系统consol发现disp+work.exe进程启动一分钟后自动停止,最终导致SAP R3 IDES系统无法使用.经排查发现故障原因由oracle数据文件被破坏造成.

 排查过程:
1. R3 IDES 系统无法正常启动;
2. R3 IDES 系统启动后,通过MMC发现disp+work.exe进程启动后不足一分钟自动停止;

3. 通过services.msc和"net start"确认ORACLE服务正常;
4. 手工停止数据库.. ...从这里开始发现问题了;

Microsoft Windows [版本 5.2.3790]
(C) 版权所有 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, 2002, Oracle Corporation.  All rights reserved.

SQL> conn /as sysdba
Connected.
SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.

启动数据库:

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

轮流替换三个位置的控制文件

通过替换"Z:/ORACLE/R3D/SAPDATA1/CNTRL/"目录下的CNTRLR3D.DBF控制文件时，启动后提示：

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'

修复数据库

SQL> recover database;
Media recovery complete.
SQL> alter database open;
Database altered.

启动 SAP R3 IDES ,正常!