minact-scn master-status
error message in Trace file " minact-scn master-status "
In On Oracle Version
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
In my case file location
/****us/oracle/Diag/diag/rdbms/aptdb/aptdb/trace
-rw-r-----. 1 oracle oinstall 125969 Jan 3 09:40 aptdb_mmon_2433.trc <<<<< trace file in
-bash-4.1$ tail -100 aptdb_mmon_2433.trc
*** 2012-01-03 09:30:01.182
minact-scn master-status: grec-scn:0x0000.0029e860 gmin-scn:0x0000.0029e860 gcalc-scn:0x0000.0029e860
minact-scn master-status: grec-scn:0x0000.0029e912 gmin-scn:0x0000.0029e912 gcalc-scn:0x0000.0029e912
*** 2012-01-03 09:40:07.680
minact-scn master-status: grec-scn:0x0000.0029e9b3 gmin-scn:0x0000.0029e9b3 gcalc-scn:0x0000.0029e9b3
*** 2012-01-03 09:45:08.186
minact-scn master-status: grec-scn:0x0000.0029ea76 gmin-scn:0x0000.0029ea76 gcalc-scn:0x0000.0029ea76
metalink note ID...
Minact-Scn Master-Status: Grec-Scn Messages In Trace File [ID 1361567.1]
Cause
Bug 11891463
The issue is similar with BUG 11891463 - MINACT-SCN MASTER-STATUS MESSAGES WRITTEN TO MMON TRACE FILE
solution ...
-----------
SQL> alter system set "_enable_minscn_cr"=false scope=spfile; ----- restart the database ..
System altered.
or
"_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.
Search This Blog
Total Pageviews
Tuesday, 3 January 2012
Subscribe to:
Post Comments (Atom)
Oracle DBA
anuj blog Archive
- ► 2011 (362)
No comments:
Post a Comment