BUG: Minact-Scn Master-Status: Grec-Scn Messages In Trace File (ID 1361567.1)-CSDN博客

1* select * from DBA_REGISTRY_HISTORY
SQL> /

ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS
------------------------------ ---------- ---------- ---------- ---------- ------------------------------ ------------------------------
24-AUG-13 12.03.45.119862 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
17-JUL-15 10.26.54.368083 AM APPLY SERVER 11.2.0.4 6 PSU PSU 11.2.0.4.6

[oracle@xxxx trace]$ tail -f xxx_mmon_2612.trc

*** 2016-01-15 10:32:12.955
minact-scn master-status: grec-scn:0x092c.427b33d5 gmin-scn:0x092c.427b33d5 gcalc-scn:0x092c.427b33d5
minact-scn master-status: grec-scn:0x092c.42858cf9 gmin-scn:0x092c.42858cf9 gcalc-scn:0x092c.42858cf9

*** 2016-01-15 10:42:16.374
minact-scn master-status: grec-scn:0x092c.4289e77c gmin-scn:0x092c.4289e77c gcalc-scn:0x092c.4289e77c

*** 2016-01-15 10:47:19.598
minact-scn master-status: grec-scn:0x092c.42931eda gmin-scn:0x092c.42931eda gcalc-scn:0x092c.42931eda
minact-scn master-status: grec-scn:0x092c.429ee42a gmin-scn:0x092c.429ee42a gcalc-scn:0x092c.429ee42a

*** 2016-01-15 10:57:26.092
minact-scn master-status: grec-scn:0x092c.42a87eda gmin-scn:0x092c.42a87eda gcalc-scn:0x092c.42a87eda

###########################################################################################
Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.
PLEASE DO NOT USE THIS SOLUTION ON AN EXADATA MACHINE because it impacts specific mechanisms.
下面解决方法不要用在exadata上，因为会降低他的某些机器特性。

Bug 11891463

The issue is similar with BUG 11891463 - MINACT-SCN MASTER-STATUS MESSAGES WRITTEN TO MMON TRACE FILE

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.
######################################################################
此bug 在mos 中没搜索到相关补丁。

   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.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30182853/viewspace-1976954/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30182853/viewspace-1976954/