Shulou(Shulou.com)06/01 Report--

That morning, a database found an ORA-600 error.

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.

We can locate whether there is a physical bad block based on the file# in the trc file that throws 600.

Kdsgrp1-1: *

Row 0x031f8070.6 continuation at

0x031f8070.6 file# 12 block# 2064496 slot 6 not found

Verify whether the block is really bad

SQL > select owner,segment_name,segment_type from dba_extents where file_id=12 and block_id=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

We see that there is no bad block when Marked Corrupt is 0, and it is determined that it is caused by a bad block in memory. If a bad block appears in memory and is not aging, you can refresh the data buffer to solve the problem.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.