Oracle Trace File Analyzer （TFA）使用方法二

最新推荐文章于 2023-02-12 22:41:03 发布

moscot_wu

最新推荐文章于 2023-02-12 22:41:03 发布

阅读量3.3k

点赞数 1

分类专栏： oracle 知识分享

本文链接：https://blog.csdn.net/moscot_wu/article/details/64904346

版权

本文详述了Oracle Trace File Analyzer (TFA) 的使用，包括如何使用diagcollect收集不同场景的日志，如全节点、特定实例、告警日志等，以及如何用analyze命令分析错误信息和日志，对数据库实例进行故障排查。

摘要由CSDN通过智能技术生成

第一章主要介绍了TFA的基本安装和一些问题解决，接下来我们主要看看TFA的使用方法

一、收集日志信息diagcollect

该命令可以用来收集，该命令语法结构如下

tfactl diagcollect [-all | [component_name1] [component_name2] ... [component_nameN]]  [-node all|local|n1,n2,..] [-tag description] [-z filename] [-since nh|d| -from time -to time | -for time] [-nocopy] [-notrim] [-silent] [-nocores] [-collectalldirs] [-collectdir dir1,dir2..] [-examples] [-node [node1,node2,nodeN] components:-ips|-database|-asm|-crsclient|-dbclient|-dbwlm|-tns|-rhp|-procinfo|-afd|-crs|-wls|-emagent|-oms|-ocm|-emplugins|-em|-acfs|-install|-cfgtools|-os|-ips|-ashhtml|-ashtext|-awrhtml|-awrtext

看起来很复杂，很长，这些参数的具体含义可以上官网查询 diagcollect参数解释，以下是常用的格式

1、收集所有节点的所有trace日志

tfactl> diagcollect -all                                                        

Collecting data for the last 12 hours for this component ...
Collecting data for all nodes
Creating ips package in master node ...
Trying ADR basepath /u01/app/oracle
Trying to use ADR homepath diag/rdbms/orcl/orcl ...
Submitting request to generate package for ADR homepath /u01/app/oracle/diag/rdbms/orcl/orcl
Trying to use ADR homepath diag/rdbms/prod1/PROD1 ...
Submitting request to generate package for ADR homepath /u01/app/oracle/diag/rdbms/prod1/PROD1
Master package completed for ADR homepath /u01/app/oracle/diag/rdbms/orcl/orcl
Created package 9 based on time range 2017-03-21 20:26:00.000000 +08:00 to 2017-03-22 08:26:00.000000 +08:00, correlation level basic
Master package completed for ADR homepath /u01/app/oracle/diag/rdbms/prod1/PROD1
Created package 9 based on time range 2017-03-21 20:26:00.000000 +08:00 to 2017-03-22 08:26:00.000000 +08:00, correlation level basic


Collection Id : 2017032208265012cr2

Detailed Logging at : /u01/app/oracle/tfa/repository/collection_Wed_Mar_22_08_26_50_CST_2017_node_all/diagcollect_20170322082650_12cr2.log
2017/03/22 08:27:06 CST : Collection Name : tfa_Wed_Mar_22_08_26_50_CST_2017.zip
2017/03/22 08:27:06 CST : Collecting diagnostics from hosts : [12cr2]
2017/03/22 08:27:06 CST : Scanning of files for Collection in progress...
2017/03/22 08:27:06 CST : Collecting additional diagnostic information...
2017/03/22 08:27:11 CST : Getting list of files satisfying time range [03/21/2017 20:27:06 CST, 03/22/2017 08:27:11 CST]
2017/03/22 08:27:12 CST : Collecting ADR incident files...
2017/03/22 08:27:28 CST : Completed collection of additional diagnostic information...
2017/03/22 08:27:32 CST : Completed Local Collection
.----------------------------------.
|        Collection Summary        |
+-------+-----------+-------+------+
| Host  | Status    | Size  | Time |
+-------+-----------+-------+------+
| 12cr2 | Completed | 244kB |  26s |
'-------+-----------+-------+------'

Logs are being collected to: /u01/app/oracle/tfa/repository/collection_Wed_Mar_22_08_26_50_CST_2017_node_all
/u01/app/oracle/tfa/repository/collection_Wed_Mar_22_08_26_50_CST_2017_node_all/12cr2.tfa_Wed_Mar_22_08_26_50_CST_2017.zip