ORA-600 [3020] During Standby Recovery after Datafile Resize to Smaller Size On Primary (Doc ID 1446482.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 23-Sep-2013***

Symptoms

Resized Primary Database datafile.

Physical Standby errors out with the following errors:

Mon Apr 02 15:18:10 2012
Errors in file /u01/oracle/diag/rdbms/testdbc/testDBC1/trace/testDBC1_mrp0_18471.trc (incident=2012368):
ORA-00600: internal error code, arguments: [3020], [6], [299879], [299879], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 6, block# 299879, file offset is 2456608768 bytes)
ORA-10564: tablespace test_DAT
ORA-01110: data file 6: '+DG_test_DATA1/testdbc/datafile/test_dat.dbf'
ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 750899
Incident details in: /u01/oracle/diag/rdbms/testdbc/testDBC1/incident/incdir_2012368/testDBC1_mrp0_18471_i2012368.trc

Changes

Datafile was resized to smaller size in the Primary Database

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms