ORA-00600 Internal Error Code, arguments [3020], [9]

The Problem

We are running Windows Server 2003, Sp2 on both the primary  and standby DB servers, using Oracle 11.2.0.2. We are using a data guard  physical standby DB, also.

We have a large tablespace due to a migration that we had completed as a one-off to load the data into the new database. I attempted to  shrink some of the datafiles to make them more manageable and not use up unnecessary space. After making the changes I checked that the physical standby database had been updated properly and found some errors in the alert log:

ORA-00600: internal error code, arguments: [3020], [9],  [490111], [38238847], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 9,  block# 490111, file offset is 4014989312 bytes)
ORA-10564: tablespace CDC_PUBLISHER_X1M
ORA-01110: data file 9: ‘D:\ORADATA\CTS\CDC_PUBLISHER_X1M02.DBF’
ORA-10561: block type ‘TRANSACTION MANAGED DATA BLOCK’, data  object# 1367456
Incident details in: D:\diag\rdbms\dg\incident\incdir_66377\db_pr02_4048_i66377.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging  details.
Slave exiting with ORA-600 exception

The Cause

Oracle support say that this is a bug which is fixed in  11.2.0.2 patchset 14 (which was not out for Windows at the time of writing).

The Solution

The first thing to do would be to apply the patch which  fixes the issue. Failing that, or perhaps in addition to that if it’s required,  you can take the following steps to resolve the issue:

1. On the standby database stop apply

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

2. Shutdown the standby database

SHUTDOWN IMMEDIATE;

3. Shutdown the primary database

SHUTDOWN IMMEDIATE;

4. Copy the affected files from the primary to the standby database

Copy File1 File2

5. Restart the primary DB

STARTUP

6. Start the standby DB and restart apply services

STARTUP MOUNT ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT  FROM SESSION;

Hopefully this has helped to resolve your issue, but you may also be facing a very similar ORA-00600 error. Well, I think it is the same one but under slightly different conditions which has the same ORA-00600, arguments: [3020] error code.

Like it, share it...

Category: ORA 600