ORA-600 kdsgrp1錯誤解決案例

當日早上某數據庫發現ORA-600錯誤
Thu Feb 14 09:00:32 2019
Errors in file /u01/app/oracle/diag/rdbms/xxxxdb/xxxxdb/trace/xxxxdb_ora_90063.trc (incident=880729):
ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/xxxxdb/xxxxdb/incident/incdir_880729/xxxxdb_ora_90063_i880729.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.

我們可以根據拋出600的trc文件中的file#來定位是否存在有物理的壞塊。

• kdsgrp1-1: *****
  row 0x031f8070.6 continuation at
  0x031f8070.6 file# 12 block# 2064496 slot 6 not found

驗證是否真的壞塊

SQL> select owner,segment_name,segment_type from dba_extents where file_id=12 and block_id<=2064496 and (block_id+blocks)>=2064496;

OWNER SEGMENT_NAME SEGMENT_TYPE

xxx T_TE_xxxx_POS_1_0000 TABLE

SQL> select count(*) from xxxx.T_TE_xxxx_POS_1_0000;

COUNT(*)

7171851

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

NAME

/u01/app/oracle/oradata/xxxx/ssptrad_data04.dbf

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@tradbstydb ~]$ dbv file='/u01/app/oracle/oradata/xxxx/ss_data04.dbf' blocksize=8192

DBVERIFY: Release 11.2.0.4.0 - Production on Thu Feb 14 09:19:54 2019

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

DBVERIFY - Verification starting : FILE = /u01/app/oracle/oradata/tradbstdy/ssptrad_data04.dbf

DBVERIFY - Verification complete

Total Pages Examined : 3932160
Total Pages Processed (Data) : 3923409
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 252
Total Pages Failing (Index): 0
Total Pages Processed (Other): 5626
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 2873
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Total Pages Encrypted : 0
Highest block SCN : 416263170 (0.416263170)
[oracle@tradbstydb ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Feb 14 09:25:08 2019

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database: XXXDB (DBID=111111111111)

RMAN> backup as copy datafile 12;

Starting backup at 14-FEB-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=3145 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00012 name=/u01/app/oracle/oradata/XXX/ss_data04.dbf
output file name=/u01/app/oracle/product/11.2/db_1/dbs/data_D-TRADB_I-2790025021_TS-SSPTRAD_DATA_FNO-12_1atprm3v tag=TAG20190214T092518 RECID=15 STAMP=1000200392
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:15
Finished backup at 14-FEB-19

我們看見Marked Corrupt為0沒有壞塊，判定是內存中出現壞塊導致，如果內存中出現了壞塊，沒有被老化，可以刷新data buffer來解決。