ITPub博客

首页 > 数据库 > Oracle > BUG: Minact-Scn Master-Status: Grec-Scn Messages In Trace File (ID 1361567.1)

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

翻译 Oracle 作者:monkeybron 时间:2016-01-15 11:12:06 0 删除 编辑
  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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2015-03-30

  • 博文量
    70
  • 访问量
    77121