一次oracle 10.2.0.4當機事故的處理

環境

資料庫版本: 10.2.0.4

作業系統版本:LINUX 5.2

現象

資料庫例項當機，alert中發現有下面報錯，手動啟來資料庫後，過一會資料庫又掛了

ORA-07445: exception encountered: core dump [kghstack_err()+119] [SIGSEGV] [Address not mapped to object] [0xFFFFFF071E440ACC] [] []

ORA-00607: Internal error occurred while making a change to a data block

ORA-00602: internal programming exception

ORA-07445: exception encountered: core dump [kghstack_err()+119] [SIGSEGV] [Address not mapped to object] [0xFFFFFF071E440ACC] [] []

ORA-00607: Internal error occurred while making a change to a data block

ORA-00602: internal programming exception

ORA-07445: exception encountered: core dump [kghstack_err()+119] [SIGSEGV] [Address not mapped to object] [0xFFFFFF071E440ACC] [] []

ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []

Wed Dec  7 20:18:43 2011

Doing block recovery for file 89 block 593641

Doing block recovery for file 89 block 593641

Doing block recovery for file 89 block 593641

Doing block recovery for file 89 block 593641

Wed Dec  7 20:18:43 2011

Errors in file /opt/oracle/software/oracle/admin/o46g1/bdump/o46g1_p009_10994.trc:

ORA-10388: parallel query server interrupt (failure)

Doing block recovery for file 89 block 593641

ORA-00602: internal programming exception

ORA-07445: exception encountered: core dump [kghstack_err()+119] [SIGSEGV] [Address not mapped to object] [0xFFFFFF071E440ACC] [] []

ORA-00607: Internal error occurred while making a change to a data block

ORA-00602: internal programming exception

ORA-07445: exception encountered: core dump [kghstack_err()+119] [SIGSEGV] [Address not mapped to object] [0xFFFFFF071E440ACC] [] []

ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []

Wed Dec  7 20:18:43 2011

Doing block recovery for file 89 block 593641

Doing block recovery for file 89 block 593641

Doing block recovery for file 89 block 593641

Doing block recovery for file 89 block 593641

Wed Dec  7 20:18:43 2011

Errors in file /opt/oracle/software/oracle/admin/o46g1/bdump/o46g1_p009_10994.trc:

ORA-10388: parallel query server interrupt (failure)

Doing block recovery for file 89 block 593641

Doing block recovery for file 89 block 593641

Doing block recovery for file 89 block 593641

Doing block recovery for file 89 block 593641

解決方案

經分析為資料庫中存在壞塊，這個壞塊引起oracle BUG 8223165 -,這個bug會導致整個資料庫例項啟來之後又掛掉，目前oracle沒有提供這個bug的10.2.0.4的下載補丁，我們暫時把這個資料檔案offline掉，經確認這個使用者暫時不用，後續再進行修復

SQL> select name from v$datafile where file#=89;

NAME

--------------------------------------------------------------------------------------------------------------------------

/oradata/o46g1/aaaaa_tbs01.dbf

把資料檔案offline

SQL>  alter database datafile 89 offline drop;

Database altered.

開啟資料庫

SQL> alter database open;

Database altered.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/21605631/viewspace-712899/，如需轉載，請註明出處，否則將追究法律責任。