oracle minact-scn,oracle_Minact-Scn Master-Status: Grec-Scn Messages In Trace File

Applies to:

Oracle

Server - Enterprise Edition - Version 11.2.0.2 and

later

Information in this document applies to any

platform.

Symptoms

Oracle 11g Enterprise Edition Release 11.2.0.2.0

MMON dumping .trc files continuously "minact-scn master-status:

grec-scn:0x0000.00000000 gmin-scn:0x0000.00000000

gcalc-scn:0x0000.00000000"

trace file snip:

*** 2011-05-17 02:13:33.645

minact-scn master-status: grec-scn:0x0016.5c8729e2

gmin-scn:0x0016.5c8729e2 gcalc-scn:0x0016.5c8729e2

*** 2011-05-17 02:18:35.478

minact-scn master-status: grec-scn:0x0016.5c872a3a

gmin-scn:0x0016.5c872a3a gcalc-scn:0x0016.5c872a3a

minact-scn master-status: grec-scn:0x0016.5c872b2b

gmin-scn:0x0016.5c872b2b gcalc-scn:0x0016.5c872b2b

*** 2011-05-17 02:28:40.258

minact-scn master-status: grec-scn:0x0016.5c872be8

gmin-scn:0x0016.5c872be8 gcalc-scn:0x0016.5c872be8

*** 2011-05-17 02:33:40.682

minact-scn master-status: grec-scn:0x0016.5c872d4d

gmin-scn:0x0016.5c872d4d gcalc-scn:0x0016.5c872d4d

minact-scn master-status: grec-scn:0x0016.5c872e13

gmin-scn:0x0016.5c872e13 gcalc-scn:0x0016.5c872e13

Changes

Upgrade to 11G

Cause

Bug 11891463

The issue is similar with BUG 11891463 - MINACT-SCN MASTER-STATUS

MESSAGES WRITTEN TO MMON TRACE FILE

Solution

First Solution Is -

follow the below mentioned instructions to set

the parameter _enable_minscn_cr correctly.

1) >

show parameter pfile

check whether your database using the spfile

2) Use the following command to set the "_enable_minscn_cr"

parameter.

alter system set "_enable_minscn_cr"=false scope=spfile;

enable/disable minscn

optimization for CR

3) Restart the database.

4) Check the issue is resolved or not-

In some cases it gets resolved and in some cases

you have to apply the second solution .

Second Solution - you can set in

init.ora

"_smu_debug_mode=134217728"

After setting above parameter the message will not be generated butThis will disable min active

SCN optimization feature.

"min active scn" introduced in 11g which is supposed to enhance

delayed block cleanout operations. Note : - Disabling min active

scnoptimization feature will not have any impact on

database.