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

Mighty elephant

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production

Red Hat Enterprise Linux Server release 5.3 (Tikanga) 64bit

After the execution of the main database changed the file from 4G to 2G

ALTER DATABASE DATAFILE'/ data/orcl/undotbs04.dbf' RESIZE 2000m

In Standby DB

SELECT OPEN_MODE FROM V$database

READ ONLY WITH APPLY was identified as READ ONLY.

Standby alert.log

Wed Mar 25 13:24:25 2015

Errors in file / u01/product/diag/rdbms/orcldg/orcl/trace/orcl_mrp0_7554.trc (incident=592209):

ORA-00600: internal error code, arguments: [3020], [6], [2343], [25168167], [], ORA-10567: Redo is inconsistent with data block (file# 6, block# 2343, file offset is 38387712 bytes)

ORA-10564: tablespace UNDOTBS1

ORA-01110: data file 6:'/ data/orcl/undotbs03.dbf'

ORA-10560: block type 'KTU UNDO BLOCK'

Incident details in: / u01/product/diag/rdbms/orcldg/orcl/incident/incdir_592209/orcl_mrp0_7554_i592209.trc

Recovery Slave PR05 previously exited with exception 600

Wed Mar 25 13:24:26 2015

MRP0: Background Media Recovery terminated with error 448

Errors in file / u01/product/diag/rdbms/orcldg/orcl/trace/orcl_pr00_7689.trc:

ORA-00448: normal completion of background process

Managed Standby Recovery not using Real Time Apply

Recovery interrupted!

Trace dumping is performing id= [cdmp _ 20150325132426]

Recovered data files to a consistent state at change 8924400385

Errors in file / u01/product/diag/rdbms/orcldg/orcl/trace/orcl_pr00_7689.trc:

ORA-00448: normal completion of background process

Errors in file / u01/product/diag/rdbms/orcldg/orcl/trace/orcl_mrp0_7554.trc:

ORA-00600: internal error code, arguments: [3020], [6], [2343], [25168167], []

ORA-10567: Redo is inconsistent with data block (file# 6, block# 2343, file offset is 38387712 bytes)

ORA-10564: tablespace UNDOTBS1

ORA-01110: data file 6:'/ data/orcl/undotbs03.dbf'

ORA-10560: block type 'KTU UNDO BLOCK'

MRP0: Background Media Recovery process shutdown (orcl)

Wed Mar 25 13:24:28 2015

Sweep [inc] [592249]: completed

Sweep [inc] [592209]: completed

Sweep [inc2] [592249]: completed

Sweep [inc2] [592209]: completed

Manual execution of alter database recover managed standby database using current logfile disconnect reporting compliance. On the question of reopening standby

Handle:

Main database alter tablespace UNDOTBS1 begin backup

Main database Scp / data/orcl/undotbs03.dbf-> backup database

Main database alter tablespace UNDOTBS1 end backup

Main database alter database create standby controlfile as'/ data/standby.ctl'

Main database Scp / data/standby.ctl-> backup database

Database startup

ALTER DATABASE ADD STANDBY LOGFILE GROUP 15 ('/ data/orcl/standbylog15.log') size 50m

……

Alter database recover managed standby database using current logfile disconnect

Restore OK

Bug 11689702 ORA-600 [3020] during recovery after datafile RESIZE (to smaller size)

This note gives a brief overview of bug 11689702.

The content was last updated on: 28-JUN-2013

Click here for details of each of the sections below.

Affects:

Product (Component)

Oracle Server (Rdbms)

Range of versions believed to be affected

Versions > = 11.2 but BELOW 12.1

Versions confirmed as being affected

11.2.0.211.2.0.1

Platforms affected

Generic (all / most platforms affected)

Fixed:

This issue is fixed in

12.1.0.1 (Base Release) 11.2.0.3 (Server Patch Set) 11.2.0.2.5 Database Patch Set Update11.2.0.2.5 Grid Infrastructure Patch Set Update (GI PSU) 11.2.0.2 Bundle Patch 13 for Exadata Database11.2.0.2 Patch 14 on Windows Platforms

Symptoms:

Related To:

Internal Error May Occur (ORA-600) ORA-600 [3020] RecoveryPhysical Standby Database / DataguardRESIZE

Description

Media recovery (either at a standby or standard media recovery)

May get stuck and stop due to an ORA-600 [3020] following a datafile

Resize operation (to resize a datafile smaller) on the primary.

Rediscovery Notes:

Look for all the following:

-Media recovery fails with ORA-600 [3020], [], []

-Any attempt to restart media recovery fails with exactly the

Same error (most likely this is a primary/standby congifuration

And the media recovery is failing with ORA-600 [3020] on the

Standby)

-look at the alert log for the time period covering the media

Recovery session, and search for the ORA-600 [3020] message

Then:

1. See which log seq# was being applied at the time of the

ORA-600 [3020], and then look at

2. See which filename it was reported for:

ORA-1110: data file:''

Then look at the alert log messages that were generated while

That log seq# was current and originally being written to

There should be a resize operation for that datafile:

"alter database datafile''resize"

The resize should be resizing the datafile smaller, but it

Will only be possible to confirm this if there are other

Resize operations for the same file earlier in the alert log

To prove the datafile initially had a larger size just prior

To this resize.

-the main ORA-600 [3020] tracefile (not the incident tracefile)

Should have the following contents:

-

KCOX_FUTURE: CHANGE IN FUTURE OF BLOCK

And

RECOVERY STUCK AT BLOCK OF FILE

And

CHANGE...

(this is a dump of the individual redo change vector which

Recovery got stuck on and could not apply)

And

ORA-01110: data file:''

ORA-10560: block type...

And

Buffer tsn:...

(this is a dump of the cache header stored at the front of

The block, which the redo change could not be applied to)

And

DUMP REDO

(a dump of the recent redo, filtered for the file#/block#)

END OF DUMP REDO

And

ORA-00600: [3020], []

ORA-10567: Redo is inconsistent with data block (file#...

ORA-10564: tablespace

ORA-01110: data file:''

ORA-10560: block type...

-

Examine the redo dump, and find the redo record containing the

Change vector (for file#/block#) which recovery got stuck on-

It should appear near the end of the redo dump, then go backwards

From that redo record, to find the immediately previous change to

File#/block#, and note the scn of that redo record, then at that

Same scn there should be a datafile resize marker redo record

Which shinks the file (ie old size is greater than new size).

Eg:

REDO RECORD-Thread:1 RBA: 0x000004.00001394.0198 LEN: 0x0128 VLD: 0x01

SCN: 0x0000.00072bbd SUBSCN: 43 02/28/2011 11:49:14

CHANGE # 2 TYP:0 CLS:1 AFN:4 DBA:0x0100000c OBJ:64299 SCN:0x0000.00072bbd

SEQ:42 OP:11.3 ENC:0 RBL:0

...

REDO RECORD-Thread:1 RBA: 0x000004.00001395.00d0 LEN: 0x0044 VLD: 0x01

SCN: 0x0000.00072bbd SUBSCN: 43 02/28/2011 11:49:14

CHANGE # 1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:17.4 ENC:0

Datafile resize marker-file: 4 old size: 12800 new size: 12672

...

REDO RECORD-Thread:1 RBA: 0x000004.00001396.0010 LEN: 0x0150 VLD: 0x05

SCN: 0x0000.00072bbf SUBSCN: 1 02/28/2011 11:49:14

Getting a Fix

Use one of the "Fixed" versions listed above

(for Patch Sets / bundles use the latest version available as

Contents are cumulative-the "Fixed" version listed above is

The first version where the fix is included)

Or

Click here for suggestions on how to get a fix for this issue

HOOKS INCLUDE:FIXHELP OERI:3020 "SQL:RESIZE" LIKELYAFFECTS XAFFECTS_11.2.0.1 XAFFECTS_V11020001 AFFECTS=11.2.0.1 XAFFECTS_11.2.0.2 XAFFECTS_V11020002 AFFECTS=11.2.0.2 XPRODID_5 PRODUCT_ID=5 PRODID-5 RDBMS XCOMP_RDBMS COMPONENT=RDBMS TAG_OERI TAG_RECOVERY TAG_STANDBY OERI RECOVERY STANDBY FIXED_11.2.0.2.5 FIXED_11.2.0.2.BP13 FIXED_11.2.0.2.GIPSU05 FIXED_11.2.0.3 FIXED _ 12.1.0.1 FIXED_WIN:B202P14

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions about this bug please consult Oracle Support.

References

Bug:11689702 (This link will only work for PUBLISHED bugs)

Note:245840.1 Information on the sections in this article

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.