회사에서 서비스 지연이 있어서 oracle support에 물어보니까 TFA랑 AWR를 뽑아서 달라고 한다. AWR은 들어봤어도 TFA는 처음 들어본다. Oracle SR 입장에서도 이거 정보 달라 저거 정보 달라 하면 귀찮으니까 한방에 필요한 정보들을 모아서 받기 위해서 만든게 TFA라는 툴이라고 한다.
요즘은 ORA-00600 같은 에러들은 애초에 SR에 등록할때 TFA로 수집된 로그 정보도 함께 등록하라고 되어있다.
TFA(trace file analyzer)란 oracle support에서 데이터를 수집하기
TFA 수집기는 이벤트 시간을 기준으로 관련 정보만 수집하므로 수집된 데이터의 크기가 훨씬 작다. TFA collector는 모든 CRS 로그 파일, ASM trace 파일, 데이터베이스 trace 파일, OSWatcher 출력값 및 CHM(cluster health monitor) 출력값을 수집한다.
TFA를 뽑아내는 명령어는 다음과 같다.
$TFA_HOME/bin/tfactl diagcollect -srdc dbracperf오라클 support 에서 서비스 지연이 있다고 SR을 올렸을 때 요청한 내용을 공유한다.
Please follow below steps and upload the logs.
Auto Collection Using TFA
-------------------------------
1) As the RDBMS/DB homeowner, run the TFA collection using the following single command (This requires TFA version 21.1.0 and above):
$TFA_HOME/bin/tfactl diagcollect -srdc dbracperf
The above command will prompt below details:
Enter the Database Name [Required for this SRDC] :
Do you have a performance issue now [Y|y|N|n] [Y]:
How many hours ago did the issue appear? [<RETURN>=1h] :
Enter start time when the performance was good [YYYY-MM-DD HH24:MI:SS] :
Enter stop time when the performance was good [YYYY-MM-DD HH24:MI:SS] :
2) Incase, if the TFA is not installed or the installed TFA version is lower than 21.1.0:
Download and install the latest version of TFA using the AHF installer: Download AHF from below document
Autonomous Health Framework (AHF) - Including TFA and ORAchk/EXAchk ( Doc ID 2550798.1 )
(a) Note: To check whether it is installed or not, run Run grep TFA_HOME = /etc/init.d/init.tfa
(b) Note: To check the current version, run tfactl version -all
(c) Note: To check the status of TFA, run tfactl print status
3) In case, If the above SRDC "dbracperf" command fails, then ONLY run the below two (a) , (b) & (c) SRDC commands and upload them along with global AWR reports.
(a) As the RDBMS/DB homeowner, run the TFA collection using the following single command
$TFA_HOME/bin/tfactl diagcollect -srdc dbperf
(b) As the Grid Infrastructure (ASM) homeowner, run the TFA collection using the following single command:
$TFA_HOME/bin/tfactl diagcollect -srdc dbasm
(c) Generate and upload global AWR report - Run on any one of the node for each databases that you have performance issues
SQL> @?/rdbms/admin/awrgrpt.sql
4) If you have the TFA Version below 22.3 then please download racdiag.sql script from below document, this script is to be run via sqlplus, as sys user, during a session or system level hang in a RAC environment and upload the output file.
Script to Collect RAC Diagnostic Information (racdiag.sql) ( Doc ID 135714.1 )
Note:
1.The output from the above srdc command will provide the location of the TFA collection for each and every node.
2.Do not rename or repackage the TFA collection.
3.Before uploading the tfa logs please verify it is covering the incident date and time.
4.Also verify whether OSwatcher logs (covering the incident timeframe) have been captured in the tfa logs, if not collect it separately and upload it.
5.Please upload the tfa collected using the above suggested tfa command or srdc as this is for specific issues.
(If this information has already been provided please ignore this action request).
This SR will go through some automatic checks to:
- verify that the required data has been attached to the SR
Thanks,
Oracle Support
한량 DBA