IDES.無法正常啟動,後判斷為ORACLE資料檔案被破壞

Goller.CN SAP Education	贊助商連結
www.goller.cn

衷心感謝 "六橫"兄!

由於一次停電,導致整個作業系統異常關閉,造成事故.此後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 ,正常!