ahf 使用看似简单，其实不易

数据库环境复杂，可能出问题的点

引自  

https://blog.dbi-services.com/you-do-use-the-oracle-trace-file-analyzer-dont-you/

因此设计出 tfactl 来收集信息，功能模块有很多


这里有个很不错的功能 oratop


但是收集信息时有些痛苦，常见以下说明
./tfactl diagcollect -srdc dbshutdown
看似简单，实际使用起来很玄幻

首先要创建一个文件
cat > /tmp/Backup_orcl.txt<  2021-04-10 10:00:00 File /tmp/a.dmp BACKUPDETAILS full
EOF

问题是：这个文件里面的内容和格式从哪里来的？

然后执行

[oracle@host bin]$ LANG=C
[oracle@host bin]$ ./tfactl diagcollect -srdc dbshutdown -database orcl -backupflag y -event_time "2021-04-16 08:46:21"
过程如下

Please provide the details such as the date, type of backup etc in a file named Backup_[sid].txt. Please input the full path of this txt file: [Required for this SRDC]: /tmp/Backup_orcl.txt
Can you reproduce the issue? [Required for this SRDC]: n
You can terminate the hanging shutdown operation and start the database in restricted mode.Please press Y after the database is restarted in restricted mode [Required for this SRDC]: y
Is the Shutdown hanging repeatedly on a particular process (mostly, background process)? [Required for this SRDC]: n
Scripts to be run by this srdc: srdc_dbunix srdc_shutdown.sql cp_trace_out cp_parameter pstack
Components included in this srdc: DATABASE NOCHMOS OS
Collecting data for local node(s).
Scanning files from Apr/16/2021 05:16:21 to Apr/16/2021 12:16:21

Collection Id : 20210419145637host

Detailed Logging at : /opt/oracle.ahf/data/repository/srdc_dbshutdown_collection_Mon_Apr_19_14_56_39_CST_2021_node_local/diagcollect_20210419145637_host.log
2021/04/19 14:56:49 CST : NOTE : Any file or directory name containing the string .com will be renamed to replace .com with dotcom
2021/04/19 14:56:49 CST : Collection Name : tfa_srdc_dbshutdown_Mon_Apr_19_14_56_39_CST_2021.zip
2021/04/19 14:56:50 CST : Getting list of files satisfying time range [04/16/2021 05:16:21 CST, 04/16/2021 12:16:21 CST]
2021/04/19 14:56:50 CST : Collecting additional diagnostic information...
2021/04/19 14:57:13 CST : Collecting ADR incident files...
2021/04/19 14:57:20 CST : Completed collection of additional diagnostic information...
2021/04/19 14:57:23 CST : Completed Local Collection
.--------------------------------------.
|          Collection Summary          |
+-----------+-----------+-------+------+
| Host      | Status    | Size  | Time |
+-----------+-----------+-------+------+
| host | Completed | 404kB |  34s |
'-----------+-----------+-------+------'

Logs are being collected to: /opt/oracle.ahf/data/repository/srdc_dbshutdown_collection_Mon_Apr_19_14_56_39_CST_2021_node_local
/opt/oracle.ahf/data/repository/srdc_dbshutdown_collection_Mon_Apr_19_14_56_39_CST_2021_node_local/host.tfa_srdc_dbshutdown_Mon_Apr_19_14_56_39_CST_2021.zip

如果不知道的话，可以看帮助 ./tfactl diagcollect -srdc dbshutdown -help