Bug 11891463 : MINACT-SCN MASTER-STATUS MESSAGES WRITTEN TO MMON TRACE FILE

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 but This 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 scn optimization feature will not have any impact on database.

 

 

SubComponent: Transaction Management Local
  ==========================================
  DETAILED PROBLEM DESCRIPTION
  ============================
  In Oracle Database 11.2.0.2 the following messages are constantly written to
  MMON trace file and MMON trace file growing in size.
  
  MMON trace file:
  minact-scn master-status: grec-scn:0x0000.0202d4ac gmin-scn:0x0000.0202d4ac
  gcalc-scn:0x0000.0202d4ac
  minact-scn master-status: grec-scn:0x0000.0202d5a2 gmin-scn:0x0000.0202d5a2
  gcalc-scn:0x0000.0202d5a2
  
  We do not see any error/message in alert log.
  
  DIAGNOSTIC ANALYSIS
  ===================
  MMON trace file:
  minact-scn master-status: grec-scn:0x0000.0202d4ac gmin-scn:0x0000.0202d4ac
  gcalc-scn:0x0000.0202d4ac
  minact-scn master-status: grec-scn:0x0000.0202d5a2 gmin-scn:0x0000.0202d5a2
  gcalc-scn:0x0000.0202d5a2
  
  WORKAROUND?
  ===========
  Yes
  
  WORKAROUND INFORMATION
  ======================
  _enable_minscn_cr=FALSE
  
  Not acceptable as we need to know the purpose and why message is being
  written to trace file. Preferable avoid the message.
  
  TECHNICAL IMPACT
  ================
  The customer does not understand the purpose of these messages and besides
  the file is growing in size over time.
  
  RELATED ISSUES (bugs, forums, RFAs)
  ===================================
  11676265: MINACT-SCN ERRORS IN ALERT AND TRACE FILES GENERATED BY MMON is to
  set