Linux AS 5.3 , Oracle 10.2.0.4 64bit , production : 3 nodes RAC , Standby : Single instance .
我们发现Standby 机器上 bdump 下面有很多 trc 文件 ,大小一样 ,内容如下:
mxrac-sty03$cat mxdell1_p010_13079.trc
/u01/product/admin/mxdell/bdump/mxdell1_p010_13079.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engine
and Real Application Testing options
ORACLE_HOME = /u01/product/oracle
System name: Linux
Node name: mxrac-sty03
Release: 2.6.18-128.el5
Version: #1 SMP Wed Dec 17 11:41:38 EST 2008
Machine: x86_64
Instance name: mxdell1
Redo thread mounted by this instance: 1
Oracle process number: 29
Unix process pid: 13079, image: oracle@mxrac-sty03 (P010)
*** 2010-03-05 13:36:43.222
*** SERVICE NAME
) 2010-03-05 13:36:43.221
*** SESSION ID
1087.65) 2010-03-05 13:36:43.221
KCBR: Number of read descriptors = 1024
KCBR: Media recovery blocks read (ASYNC) = 35711
KCBR: Redo cache copies/changes = 730564/730564
KCBR: Influx buffers flushed = 231 times
KCBR: Reads = 10229 reap (10008 no-op, 0 one), 824 all
这是大量trc 文件的状况 , 虽然我们有设置crontab job 去定期删除它们,不过为什么pmon 要生成这么多的trc呢 ?
mxrac-sty03$ls
alert_mxdell1.log mxdell1_p003_26239.trc mxdell1_p007_22633.trc mxdell1_p011_16476.trc
alert_mxdell1.log.1 mxdell1_p003_28256.trc mxdell1_p007_23752.trc mxdell1_p011_17879.trc
alert_mxdell1.log.2 mxdell1_p003_30075.trc mxdell1_p007_2448.trc mxdell1_p011_19861.trc
alert_mxdell1.log.3 mxdell1_p003_31962.trc mxdell1_p007_24988.trc mxdell1_p011_21732.trc
alert_mxdell1.log.4 mxdell1_p003_4417.trc mxdell1_p007_26247.trc mxdell1_p011_22641.trc
alert_mxdell1.log.5 mxdell1_p003_6346.trc mxdell1_p007_28264.trc mxdell1_p011_23760.trc
mxdell1_p000_11122.trc mxdell1_p003_7860.trc mxdell1_p007_30083.trc mxdell1_p011_2456.trc
mxdell1_p000_11515.trc mxdell1_p003_7979.trc mxdell1_p007_31970.trc mxdell1_p011_24996.trc
mxdell1_p000_13059.trc mxdell1_p003_8444.trc mxdell1_p007_4425.trc mxdell1_p011_26255.trc
mxdell1_p000_13339.trc mxdell1_p003_9438.trc mxdell1_p007_6354.trc mxdell1_p011_28272.trc
mxdell1_p000_15300.trc mxdell1_p004_1007.trc mxdell1_p007_7868.trc mxdell1_p011_30091.trc
mxdell1_p000_16454.trc mxdell1_p004_11130.trc mxdell1_p007_7987.trc mxdell1_p011_31978.trc
mxdell1_p000_17857.trc mxdell1_p004_11523.trc mxdell1_p007_8452.trc mxdell1_p011_4433.trc
mxdell1_p000_19839.trc mxdell1_p004_13067.trc mxdell1_p007_9446.trc mxdell1_p011_6362.trc
mxdell1_p000_21710.trc mxdell1_p004_13347.trc mxdell1_p008_1015.trc mxdell1_p011_7876.trc
mxdell1_p000_22619.trc mxdell1_p004_15308.trc mxdell1_p008_11138.trc mxdell1_p011_7995.trc
mxdell1_p000_23738.trc mxdell1_p004_16462.trc mxdell1_p008_11531.trc mxdell1_p011_8460.trc
mxdell1_p000_2434.trc mxdell1_p004_17865.trc mxdell1_p008_13075.trc mxdell1_p011_9454.trc
mxdell1_p000_24974.trc mxdell1_p004_19847.trc mxdell1_p008_13355.trc mxdell1_p012_1023.trc
mxdell1_p000_26233.trc mxdell1_p004_21718.trc mxdell1_p008_15316.trc mxdell1_p012_11146.trc
mxdell1_p000_28250.trc mxdell1_p004_22627.trc mxdell1_p008_16470.trc mxdell1_p012_11539.trc
mxdell1_p000_30069.trc mxdell1_p004_23746.trc mxdell1_p008_17873.trc mxdell1_p012_13083.trc
mxdell1_p000_31956.trc mxdell1_p004_2442.trc mxdell1_p008_19855.trc mxdell1_p012_13363.trc
mxdell1_p000_4411.trc mxdell1_p004_24982.trc mxdell1_p008_21726.trc mxdell1_p012_15324.trc
mxdell1_p000_6340.trc mxdell1_p004_26241.trc mxdell1_p008_22635.trc mxdell1_p012_16478.trc
mxdell1_p000_7854.trc mxdell1_p004_28258.trc mxdell1_p008_23754.trc mxdell1_p012_17881.trc
mxdell1_p000_7973.trc mxdell1_p004_30077.trc mxdell1_p008_2450.trc mxdell1_p012_19863.trc
mxdell1_p000_8438.trc mxdell1_p004_31964.trc mxdell1_p008_24990.trc mxdell1_p012_21734.trc
mxdell1_p000_9432.trc mxdell1_p004_4419.trc mxdell1_p008_26249.trc mxdell1_p012_22643.trc
mxdell1_p000_999.trc mxdell1_p004_6348.trc mxdell1_p008_28266.trc mxdell1_p012_23762.trc
mxdell1_p001_1001.trc mxdell1_p004_7862.trc mxdell1_p008_30085.trc mxdell1_p012_2458.trc
mxdell1_p001_11124.trc mxdell1_p004_7981.trc mxdell1_p008_31972.trc mxdell1_p012_24998.trc
mxdell1_p001_11517.trc mxdell1_p004_8446.trc mxdell1_p008_4427.trc mxdell1_p012_26257.trc
mxdell1_p001_13061.trc mxdell1_p004_9440.trc mxdell1_p008_6356.trc mxdell1_p012_28274.trc
mxdell1_p001_13341.trc mxdell1_p005_1009.trc mxdell1_p008_7870.trc mxdell1_p012_30093.trc
mxdell1_p001_15302.trc mxdell1_p005_11132.trc mxdell1_p008_7989.trc mxdell1_p012_31980.trc
mxdell1_p001_16456.trc mxdell1_p005_11525.trc mxdell1_p008_8454.trc mxdell1_p012_4435.trc
mxdell1_p001_17859.trc mxdell1_p005_13069.trc mxdell1_p008_9448.trc mxdell1_p012_6364.trc
mxdell1_p001_19841.trc mxdell1_p005_13349.trc mxdell1_p009_1017.trc mxdell1_p012_7878.trc
mxdell1_p001_21712.trc mxdell1_p005_15310.trc mxdell1_p009_11140.trc mxdell1_p012_7997.trc
mxdell1_p001_22621.trc mxdell1_p005_16464.trc mxdell1_p009_11533.trc mxdell1_p012_8462.trc
mxdell1_p001_23740.trc mxdell1_p005_17867.trc mxdell1_p009_13077.trc mxdell1_p012_9456.trc
mxdell1_p001_2436.trc mxdell1_p005_19849.trc mxdell1_p009_13357.trc mxdell1_p013_1025.trc
mxdell1_p001_24976.trc mxdell1_p005_21720.trc mxdell1_p009_15318.trc mxdell1_p013_11148.trc
mxdell1_p001_26235.trc mxdell1_p005_22629.trc mxdell1_p009_16472.trc mxdell1_p013_11541.trc
mxdell1_p001_28252.trc mxdell1_p005_23748.trc mxdell1_p009_17875.trc mxdell1_p013_13085.trc
mxdell1_p001_30071.trc mxdell1_p005_2444.trc mxdell1_p009_19857.trc mxdell1_p013_13365.trc
mxdell1_p001_31958.trc mxdell1_p005_24984.trc mxdell1_p009_21728.trc mxdell1_p013_15326.trc
mxdell1_p001_4413.trc mxdell1_p005_26243.trc mxdell1_p009_22637.trc mxdell1_p013_16480.trc
mxdell1_p001_6342.trc mxdell1_p005_28260.trc mxdell1_p009_23756.trc mxdell1_p013_17883.trc
.....
我们发现Standby 机器上 bdump 下面有很多 trc 文件 ,大小一样 ,内容如下:
mxrac-sty03$cat mxdell1_p010_13079.trc
/u01/product/admin/mxdell/bdump/mxdell1_p010_13079.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engine
and Real Application Testing options
ORACLE_HOME = /u01/product/oracle
System name: Linux
Node name: mxrac-sty03
Release: 2.6.18-128.el5
Version: #1 SMP Wed Dec 17 11:41:38 EST 2008
Machine: x86_64
Instance name: mxdell1
Redo thread mounted by this instance: 1
Oracle process number: 29
Unix process pid: 13079, image: oracle@mxrac-sty03 (P010)
*** 2010-03-05 13:36:43.222
*** SERVICE NAME
![2.gif](https://i-blog.csdnimg.cn/blog_migrate/dbdd49eaed45d068acbf50849cc4df61.png)
*** SESSION ID
![2.gif](https://i-blog.csdnimg.cn/blog_migrate/dbdd49eaed45d068acbf50849cc4df61.png)
KCBR: Number of read descriptors = 1024
KCBR: Media recovery blocks read (ASYNC) = 35711
KCBR: Redo cache copies/changes = 730564/730564
KCBR: Influx buffers flushed = 231 times
KCBR: Reads = 10229 reap (10008 no-op, 0 one), 824 all
这是大量trc 文件的状况 , 虽然我们有设置crontab job 去定期删除它们,不过为什么pmon 要生成这么多的trc呢 ?
mxrac-sty03$ls
alert_mxdell1.log mxdell1_p003_26239.trc mxdell1_p007_22633.trc mxdell1_p011_16476.trc
alert_mxdell1.log.1 mxdell1_p003_28256.trc mxdell1_p007_23752.trc mxdell1_p011_17879.trc
alert_mxdell1.log.2 mxdell1_p003_30075.trc mxdell1_p007_2448.trc mxdell1_p011_19861.trc
alert_mxdell1.log.3 mxdell1_p003_31962.trc mxdell1_p007_24988.trc mxdell1_p011_21732.trc
alert_mxdell1.log.4 mxdell1_p003_4417.trc mxdell1_p007_26247.trc mxdell1_p011_22641.trc
alert_mxdell1.log.5 mxdell1_p003_6346.trc mxdell1_p007_28264.trc mxdell1_p011_23760.trc
mxdell1_p000_11122.trc mxdell1_p003_7860.trc mxdell1_p007_30083.trc mxdell1_p011_2456.trc
mxdell1_p000_11515.trc mxdell1_p003_7979.trc mxdell1_p007_31970.trc mxdell1_p011_24996.trc
mxdell1_p000_13059.trc mxdell1_p003_8444.trc mxdell1_p007_4425.trc mxdell1_p011_26255.trc
mxdell1_p000_13339.trc mxdell1_p003_9438.trc mxdell1_p007_6354.trc mxdell1_p011_28272.trc
mxdell1_p000_15300.trc mxdell1_p004_1007.trc mxdell1_p007_7868.trc mxdell1_p011_30091.trc
mxdell1_p000_16454.trc mxdell1_p004_11130.trc mxdell1_p007_7987.trc mxdell1_p011_31978.trc
mxdell1_p000_17857.trc mxdell1_p004_11523.trc mxdell1_p007_8452.trc mxdell1_p011_4433.trc
mxdell1_p000_19839.trc mxdell1_p004_13067.trc mxdell1_p007_9446.trc mxdell1_p011_6362.trc
mxdell1_p000_21710.trc mxdell1_p004_13347.trc mxdell1_p008_1015.trc mxdell1_p011_7876.trc
mxdell1_p000_22619.trc mxdell1_p004_15308.trc mxdell1_p008_11138.trc mxdell1_p011_7995.trc
mxdell1_p000_23738.trc mxdell1_p004_16462.trc mxdell1_p008_11531.trc mxdell1_p011_8460.trc
mxdell1_p000_2434.trc mxdell1_p004_17865.trc mxdell1_p008_13075.trc mxdell1_p011_9454.trc
mxdell1_p000_24974.trc mxdell1_p004_19847.trc mxdell1_p008_13355.trc mxdell1_p012_1023.trc
mxdell1_p000_26233.trc mxdell1_p004_21718.trc mxdell1_p008_15316.trc mxdell1_p012_11146.trc
mxdell1_p000_28250.trc mxdell1_p004_22627.trc mxdell1_p008_16470.trc mxdell1_p012_11539.trc
mxdell1_p000_30069.trc mxdell1_p004_23746.trc mxdell1_p008_17873.trc mxdell1_p012_13083.trc
mxdell1_p000_31956.trc mxdell1_p004_2442.trc mxdell1_p008_19855.trc mxdell1_p012_13363.trc
mxdell1_p000_4411.trc mxdell1_p004_24982.trc mxdell1_p008_21726.trc mxdell1_p012_15324.trc
mxdell1_p000_6340.trc mxdell1_p004_26241.trc mxdell1_p008_22635.trc mxdell1_p012_16478.trc
mxdell1_p000_7854.trc mxdell1_p004_28258.trc mxdell1_p008_23754.trc mxdell1_p012_17881.trc
mxdell1_p000_7973.trc mxdell1_p004_30077.trc mxdell1_p008_2450.trc mxdell1_p012_19863.trc
mxdell1_p000_8438.trc mxdell1_p004_31964.trc mxdell1_p008_24990.trc mxdell1_p012_21734.trc
mxdell1_p000_9432.trc mxdell1_p004_4419.trc mxdell1_p008_26249.trc mxdell1_p012_22643.trc
mxdell1_p000_999.trc mxdell1_p004_6348.trc mxdell1_p008_28266.trc mxdell1_p012_23762.trc
mxdell1_p001_1001.trc mxdell1_p004_7862.trc mxdell1_p008_30085.trc mxdell1_p012_2458.trc
mxdell1_p001_11124.trc mxdell1_p004_7981.trc mxdell1_p008_31972.trc mxdell1_p012_24998.trc
mxdell1_p001_11517.trc mxdell1_p004_8446.trc mxdell1_p008_4427.trc mxdell1_p012_26257.trc
mxdell1_p001_13061.trc mxdell1_p004_9440.trc mxdell1_p008_6356.trc mxdell1_p012_28274.trc
mxdell1_p001_13341.trc mxdell1_p005_1009.trc mxdell1_p008_7870.trc mxdell1_p012_30093.trc
mxdell1_p001_15302.trc mxdell1_p005_11132.trc mxdell1_p008_7989.trc mxdell1_p012_31980.trc
mxdell1_p001_16456.trc mxdell1_p005_11525.trc mxdell1_p008_8454.trc mxdell1_p012_4435.trc
mxdell1_p001_17859.trc mxdell1_p005_13069.trc mxdell1_p008_9448.trc mxdell1_p012_6364.trc
mxdell1_p001_19841.trc mxdell1_p005_13349.trc mxdell1_p009_1017.trc mxdell1_p012_7878.trc
mxdell1_p001_21712.trc mxdell1_p005_15310.trc mxdell1_p009_11140.trc mxdell1_p012_7997.trc
mxdell1_p001_22621.trc mxdell1_p005_16464.trc mxdell1_p009_11533.trc mxdell1_p012_8462.trc
mxdell1_p001_23740.trc mxdell1_p005_17867.trc mxdell1_p009_13077.trc mxdell1_p012_9456.trc
mxdell1_p001_2436.trc mxdell1_p005_19849.trc mxdell1_p009_13357.trc mxdell1_p013_1025.trc
mxdell1_p001_24976.trc mxdell1_p005_21720.trc mxdell1_p009_15318.trc mxdell1_p013_11148.trc
mxdell1_p001_26235.trc mxdell1_p005_22629.trc mxdell1_p009_16472.trc mxdell1_p013_11541.trc
mxdell1_p001_28252.trc mxdell1_p005_23748.trc mxdell1_p009_17875.trc mxdell1_p013_13085.trc
mxdell1_p001_30071.trc mxdell1_p005_2444.trc mxdell1_p009_19857.trc mxdell1_p013_13365.trc
mxdell1_p001_31958.trc mxdell1_p005_24984.trc mxdell1_p009_21728.trc mxdell1_p013_15326.trc
mxdell1_p001_4413.trc mxdell1_p005_26243.trc mxdell1_p009_22637.trc mxdell1_p013_16480.trc
mxdell1_p001_6342.trc mxdell1_p005_28260.trc mxdell1_p009_23756.trc mxdell1_p013_17883.trc
.....
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-628943/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/35489/viewspace-628943/