isitdevops.com/databases

Trace File Analyzer Collector (TFA)

is a diagnostic collection utility to simplify diagnostic data collection on Oracle Clusterware/Grid Infrastructure, RAC and Single Instance Database systems.

TFA is similar to the diagcollection utility packaged with Oracle Clusterware in that it collects and packages diagnostic data – however – TFA is MUCH more powerful than diagcollection with its ability to centralize and automate the collection of diagnostic information.

TFA provides the following key benefits:

• +

  Increase Productivity

• +

  Reduce Diagnostic Data Upload Package Size

• +

  Reduce SR Resolution Times

• +

  Single Source and Interface for Diagnostic Tools

TFA Collector Features:

• Simplifies diagnostic data collections
• A single command performs clusterwide diagnostic collection for ALL components
• Diagnostic files “trimmed” around the incident time
• Collected diagnostics are consolidated on a single node
• Increased efficiency of admin staff
• Includes and Integrates the following tools that were previously packaged as the “RAC and DB Support Tools Bundle” (MOS Version Only):
  • ORAchk to promote proactive mainteance
  • OSWatcher, Procwatcher, SQLT, ORAtop and DARDA to ensure such data is available for reactive types of issues

[grid]$ tfactl diagcollect -all -since 6h

Collecting data for all components using above parameters…

 

Collecting data for all nodes

Collection Id : 20160727092122DBN

 

Repository Location in DBN : /u01/app/grid/tfa/repository

 

Collection monitor will wait up to 30 seconds for collections to start

 

2016/07/27 09:21:25 UTC : Collection Name : tfa_Wed_Jul_27_09_21_22_UTC_2016.zip

2016/07/27 09:21:25 UTC : Sending diagcollect request to host : HOSTN

2016/07/27 09:21:25 UTC : Scanning of files for Collection in progress…

2016/07/27 09:21:25 UTC : Collecting extra files…

2016/07/27 09:22:18 UTC : Completed collection of extra files…

2016/07/27 09:22:25 UTC : Getting list of files satisfying time range [07/27/2016 03:21:25 UTC, 07/27/2016 09:22:25 UTC]

2016/07/27 09:22:25 UTC : Starting Thread to identify stored files to collect

2016/07/27 09:22:25 UTC : Getting List of Files to Collect

2016/07/27 09:22:26 UTC : Trimming file : HOST/crs/HOST/crs/trace/crsd_oraagent_grid.trc with original file size : 10MB

:

2016/07/27 09:22:29 UTC : Trimming file : HOST/asm/+asm/+ASM2/trace/+ASM2_lms0_10658.trc with original file size : 1.7MB

 

2016/07/27 09:22:29 UTC : HOST: Zipped 100 Files so Far

:

2016/07/27 09:22:29 UTC : HOST: Zipped 1000 Files so Far

 

:

2016/07/27 09:22:44 UTC : Collecting ADR incident files…

 

2016/07/27 09:22:49 UTC : Completed Zipping of all files

2016/07/27 09:22:49 UTC : Cleaning up temporary files

2016/07/27 09:22:49 UTC : Finished Cleaning up temporary files

2016/07/27 09:22:49 UTC : Finalizing the Collection Zip File

2016/07/27 09:22:49 UTC : Finished Finalizing the Collection Zip File

2016/07/27 09:22:49 UTC : Total Number of Files checked : 45905

2016/07/27 09:22:49 UTC : Total Size of all Files Checked : 18GB

2016/07/27 09:22:49 UTC : Number of files containing required range : 1172

2016/07/27 09:22:49 UTC : Total Size of Files containing required range : 4.4GB

2016/07/27 09:22:49 UTC : Number of files trimmed : 30

2016/07/27 09:22:49 UTC : Total Size of data prior to zip : 506MB

2016/07/27 09:22:49 UTC : Saved 4.1GB by trimming files

2016/07/27 09:22:49 UTC : Zip file size : 33MB

2016/07/27 09:22:49 UTC : Total time taken : 84s

2016/07/27 09:22:49 UTC : Remote Collection in Progress…

2016/07/27 09:22:49 UTC : lhrdb01:Completed Collection

2016/07/27 09:22:49 UTC : Completed collection of zip files.

Logs are being collected to: /u01/app/grid/tfa/repository/collection_…