Trace File Analyzer (TFA)
First of all, please make sure that you have installed the latest AHF. Next, let's see how we collect diagnostics for Oracle Support Service Request Data Collection (SRDC).
tfactl status
We have to make sure that TFA is running in order to collect logs.
[grid@primary01 grid]$ tfactl status
.------------------------------------------------------------------------------------------------------.
| Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status |
+-----------+---------------+----------+------+-------------+-----------------------+------------------+
| primary01 | RUNNING | 37683464 | 5000 | 23.10.0.0.0 | 231000020231031182123 | COMPLETE |
| primary02 | RUNNING | 8847802 | 5000 | 23.10.0.0.0 | 231000020231031182123 | COMPLETE |
'-----------+---------------+----------+------+-------------+-----------------------+------------------'
Specific Time
We collect logs for some service request about the RAC database. Incident time is specified after the command is issued.
[grid@primary01 grid]$ tfactl diagcollect -srdc dbrac
Enter the time of the incident [YYYY-MM-DD HH24:MI:SS,<RETURN>=ALL] : 2023-12-09 17:04:17
Enter the Database Name, if the incident was NOT specific to a database (e.g. Node Reboot/Eviction) choose ALL [Required for this SRDC] :
Components included in this collection: OS CRS DATABASE CHMOS CHA ASM
Preparing to execute support diagnostic scripts.
Collecting data for all nodes
TFA is using system timezone for collection, All times shown in CST.
Scanning files from 2023-12-09 16:34:17 CST to 2023-12-09 17:34:17 CST
Collection Id : 20231210165556primary01
Detailed Logging at : /u01/app/grid/oracle.ahf/data/repository/srdc_dbrac_collection_Sun_Dec_10_16_56_01_CST_2023_node_all/diagcollect_20231210165556_primary01.log
Waiting up to 60 seconds for collection to start
2023/12/10 16:56:11 CST : NOTE : Any file or directory name containing the string .com will be renamed to replace .com with dotcom
2023/12/10 16:56:11 CST : Collection Name : tfa_srdc_dbrac_Sun_Dec_10_16_55_59_CST_2023.zip
2023/12/10 16:56:12 CST : Collecting diagnostics from hosts : [primary01, primary02]
2023/12/10 16:56:13 CST : Getting list of files satisfying time range [12/09/2023 16:34:17, 12/09/2023 17:34:17]
2023/12/10 16:56:13 CST : Collecting Additional Diagnostic Information...
2023/12/10 16:56:24 CST : Executing IPS Incident Package Collection(s)...
2023/12/10 16:56:24 CST : Executing Collection for ASM with timeout of 1800 seconds...
2023/12/10 16:57:15 CST : Executing Collection for AFD with timeout of 1860 seconds...
2023/12/10 16:57:16 CST : Executing Collection for CRS with timeout of 1920 seconds...
2023/12/10 16:57:30 CST : Collecting ADR incident files...
2023/12/10 16:58:47 CST : Executing Collection for OS with timeout of 1980 seconds...
2023/12/10 16:58:58 CST : Completed Collection of Additional Diagnostic Information...
2023/12/10 16:59:05 CST : Completed Local Collection
2023/12/10 16:59:05 CST : Not Redacting this Collection ...
2023/12/10 16:59:05 CST : Remote Collection in Progress...
2023/12/10 17:09:06 CST : Remote collection is still running...
2023/12/10 17:19:06 CST : Remote collection is still running...
2023/12/10 17:29:06 CST : Remote collection is still running...
2023/12/10 17:39:00 CST : Collection completed on host: primary02
2023/12/10 17:39:00 CST : Collection completed on host: primary01
2023/12/10 17:39:00 CST : Completed collection of zip files.
.-------------------------------------.
| Collection Summary |
+-----------+-----------+------+------+
| Host | Status | Size | Time |
+-----------+-----------+------+------+
| primary02 | Completed | 26MB | 118s |
| primary01 | Completed | 33MB | 173s |
'-----------+-----------+------+------'
Logs are being collected to: /u01/app/grid/oracle.ahf/data/repository/srdc_dbrac_collection_Sun_Dec_10_16_56_01_CST_2023_node_all
/u01/app/grid/oracle.ahf/data/repository/srdc_dbrac_collection_Sun_Dec_10_16_56_01_CST_2023_node_all/primary01.tfa_srdc_dbrac_Sun_Dec_10_16_55_59_CST_2023.zip
/u01/app/grid/oracle.ahf/data/repository/srdc_dbrac_collection_Sun_Dec_10_16_56_01_CST_2023_node_all/primary02.tfa_srdc_dbrac_Sun_Dec_10_16_55_59_CST_2023.zip
It collects 2 hours span, it's between 1 hour before and after the incident.
Time Interval
We can also collect logs for a time interval by specifying -from and -to.
[grid@primary01 grid]$ tfactl diagcollect -srdc dbrac -from "2023-12-10 00:00:00" -to "2023-12-12 00:00:00"
Enter the Database Name, if the incident was NOT specific to a database (e.g. Node Reboot/Eviction) choose ALL [Required for this SRDC] :
Components included in this collection: OS CRS DATABASE CHMOS CHA ASM
Preparing to execute support diagnostic scripts.
Collecting data for all nodes
TFA is using system timezone for collection, All times shown in CST.
Scanning files from 2023-12-10 00:00:00 CST to 2023-12-12 00:00:00 CST
Collection Id : 20231217110230primary01
Detailed Logging at : /u01/app/grid/oracle.ahf/data/repository/srdc_dbrac_collection_Sun_Dec_17_11_02_34_CST_2023_node_all/diagcollect_20231217110230_primary01.log
Waiting up to 60 seconds for collection to start
2023/12/17 11:02:45 CST : NOTE : Any file or directory name containing the string .com will be renamed to replace .com with dotcom
2023/12/17 11:02:45 CST : Collection Name : tfa_srdc_dbrac_Sun_Dec_17_11_02_32_CST_2023.zip
2023/12/17 11:02:46 CST : Collecting diagnostics from hosts : [primary01, primary02]
2023/12/17 11:02:53 CST : Getting list of files satisfying time range [12/10/2023 00:00:00, 12/12/2023 00:00:00]
2023/12/17 11:02:53 CST : Collecting Additional Diagnostic Information...
2023/12/17 11:03:04 CST : Executing IPS Incident Package Collection(s)...
2023/12/17 11:03:04 CST : Executing Collection for ASM with timeout of 1800 seconds...
2023/12/17 11:03:55 CST : Executing Collection for AFD with timeout of 1860 seconds...
2023/12/17 11:03:56 CST : Executing Collection for CRS with timeout of 1920 seconds...
2023/12/17 11:04:41 CST : Collecting ADR incident files...
2023/12/17 11:05:29 CST : Executing Collection for OS with timeout of 1980 seconds...
2023/12/17 11:05:40 CST : Completed Collection of Additional Diagnostic Information...
2023/12/17 11:05:49 CST : Completed Local Collection
2023/12/17 11:05:50 CST : Not Redacting this Collection ...
2023/12/17 11:05:50 CST : Remote Collection in Progress...
2023/12/17 11:05:50 CST : Collection completed on host: primary02
2023/12/17 11:05:50 CST : Collection completed on host: primary01
2023/12/17 11:05:50 CST : Completed collection of zip files.
.--------------------------------------.
| Collection Summary |
+-----------+-----------+-------+------+
| Host | Status | Size | Time |
+-----------+-----------+-------+------+
| primary02 | Completed | 239MB | 131s |
| primary01 | Completed | 241MB | 183s |
'-----------+-----------+-------+------'
Logs are being collected to: /u01/app/grid/oracle.ahf/data/repository/srdc_dbrac_collection_Sun_Dec_17_11_02_34_CST_2023_node_all
/u01/app/grid/oracle.ahf/data/repository/srdc_dbrac_collection_Sun_Dec_17_11_02_34_CST_2023_node_all/primary01.tfa_srdc_dbrac_Sun_Dec_17_11_02_32_CST_2023.zip
/u01/app/grid/oracle.ahf/data/repository/srdc_dbrac_collection_Sun_Dec_17_11_02_34_CST_2023_node_all/primary02.tfa_srdc_dbrac_Sun_Dec_17_11_02_32_CST_2023.zip
The files mentioned at the last 2 lines are the final result that you have to upload them to MOS.