数据库环境复杂,可能出问题的点
引自
-
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
阅读(997) | 评论(0) | 转发(0) |