Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

21

积分

0

好友

5

主题
1#
发表于 2014-4-6 19:52:10 | 查看: 1957| 回复: 0
操作系统SUSE Linux Enterprise Server 10 (x86_64)   数据库版本: 11.1.0.7.0 ,安装了Patch  13923474
问题是节点1产生大量监听日志,短短两天日志量100G
oracle@kfivr1:~/app/diag/tnslsnr/kfivr1/listener/alert> lsnrctl status

LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 06-APR-2014 19:45:22

Copyright (c) 1991, 2008, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.1.0.7.0 - Production
Start Date                06-APR-2014 19:31:07
Uptime                    0 days 0 hr. 14 min. 17 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/app/product/db11g/network/admin/listener.ora
Listener Log File         /oracle/app/diag/tnslsnr/kfivr1/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=kfivr1)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "kfivr" has 1 instance(s).
  Instance "kfivr1", status READY, has 1 handler(s) for this service...
Service "kfivrXDB" has 1 instance(s).
  Instance "kfivr1", status READY, has 1 handler(s) for this service...
Service "kfivr_XPT" has 1 instance(s).

oracle@kfivr1:~/app/diag/tnslsnr/kfivr1/listener/alert> ll
total 483255
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:34 log_10.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:34 log_11.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:34 log_12.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:35 log_13.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:35 log_14.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:35 log_15.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:36 log_16.xml
-rw-r----- 1 oracle oinstall 10485859 2014-04-06 19:36 log_17.xml
-rw-r----- 1 oracle oinstall 10485762 2014-04-06 19:36 log_18.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:37 log_19.xml
-rw-r----- 1 oracle oinstall 10485837 2014-04-06 19:31 log_1.xml
-rw-r----- 1 oracle oinstall 10485832 2014-04-06 19:37 log_20.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:37 log_21.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:38 log_22.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:38 log_23.xml
-rw-r----- 1 oracle oinstall 10485846 2014-04-06 19:38 log_24.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:39 log_25.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:39 log_26.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:39 log_27.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:40 log_28.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:40 log_29.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:31 log_2.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:40 log_30.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:41 log_31.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:41 log_32.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:41 log_33.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:42 log_34.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:42 log_35.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:42 log_36.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:43 log_37.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:43 log_38.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:44 log_39.xml
-rw-r----- 1 oracle oinstall 10485873 2014-04-06 19:32 log_3.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:44 log_40.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:44 log_41.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:45 log_42.xml
-rw-r----- 1 oracle oinstall 10485762 2014-04-06 19:45 log_43.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:45 log_44.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:46 log_45.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:46 log_46.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:46 log_47.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:32 log_4.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:32 log_5.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:33 log_6.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:33 log_7.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:33 log_8.xml
-rw-r----- 1 oracle oinstall 10485872 2014-04-06 19:33 log_9.xml
-rw-r----- 1 oracle oinstall  1343552 2014-04-06 19:46 log.xml

log.xml 内容如下:
oracle@kfivr1:~/app/diag/tnslsnr/kfivr1/listener/alert> tail -50 log.xml
host_addr='136.160.25.19'>
<txt>06-APR-2014 19:47:31 * service_update * kfivr1 * 0
</txt>
</msg>
<msg time='2014-04-06T19:47:31.071+08:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='kfivr1'
host_addr='136.160.25.19'>
<txt>06-APR-2014 19:47:31 * service_update * kfivr1 * 0
</txt>
</msg>
<msg time='2014-04-06T19:47:31.071+08:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='kfivr1'
host_addr='136.160.25.19'>
<txt>06-APR-2014 19:47:31 * service_update * kfivr1 * 0
</txt>
</msg>
<msg time='2014-04-06T19:47:31.072+08:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='kfivr1'
host_addr='136.160.25.19'>
<txt>06-APR-2014 19:47:31 * service_update * kfivr1 * 0
</txt>
</msg>
<msg time='2014-04-06T19:47:31.072+08:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='kfivr1'
host_addr='136.160.25.19'>
<txt>06-APR-2014 19:47:31 * service_update * kfivr1 * 0
</txt>
</msg>
<msg time='2014-04-06T19:47:31.072+08:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='kfivr1'
host_addr='136.160.25.19'>
<txt>06-APR-2014 19:47:31 * service_update * kfivr1 * 0
</txt>
</msg>


oracle@kfivr1:~/app/diag/tnslsnr/kfivr1/listener/trace> tail -50 listener.log
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0
06-APR-2014 19:48:27 * service_update * kfivr1 * 0

oracle@kfivr1:~/app/diag/tnslsnr/kfivr1/listener/trace> hostname
kfivr1
oracle@kfivr1:~/app/diag/tnslsnr/kfivr1/listener/trace> cat /etc/hosts
127.0.0.1       localhost
10.0.0.1        kfivr1.KF
10.0.1.2        kfivr1.KF
136.160.25.19   kfivr1
169.254.55.155  kfivr1_priv
136.160.25.18   kfivr1_vip
136.160.25.17   kfivr2
169.254.55.156  kfivr2_priv
136.160.25.16   kfivr2_vip   
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-21 05:58 , Processed in 0.044679 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569