当日早上某数据库发现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来解决。