내맘대로긍정이 알려주는
Oracle 23ai 신기능
무료 세미나 발표자료
OS환경 : Oracle Linux 7.6 (64bit)
DB 환경 : Oracle Database 19.10.0.0
방법 : 오라클 19c ahf(tfa) 설치 및 로그수집 가이드(SRDC)
TFA 란?
Oracle Support는 데이터 수집을 위해 TFA (Trace File Analyzer) 수집기를 사용하는 것이 좋음
TFA 수집기는 이벤트 시간을 기준으로 관련 정보 만 수집하므로 수집 된 데이터의 크기는 훨씬 작음
TFA Collector는 모든 CRS 로그 파일, ASM trace 파일, 데이터베이스 trace 파일, OSWatcher 출력값 및 CHM (Cluster Health Monitor) 출력값을 수집함
AHF 란?
AHF (Autonomous Health Framework)는 단순히 TFA, ORAchk 및 EXAchk, oswatcher, oratop 등
여러가지 도구들이 결합 된 설치 프로그램임
TFA, ORAchk 및 EXAchk는 이전과 동일하게 작동함
root 유저로 설치하는것을 권장하지만 oracle 유저로도 설치할 수 있음
oracle 유저로 ahf 설치 시 제약사항
ahf는 root가 아닌 사용자로 설치할 때 아래 기능을 사용할수 없음
진단 수집 자동화(Automate diagnostic collections)
원격 호스트에서 진단 수집(Collect diagnostics from remote hosts)
Oracle 홈 소유자가 읽을 수 없는 파일(예: /var/log/messages 또는 특정 Oracle Grid Infrastructure 로그 수집)
(Collect files that are not readable by the Oracle home owner, for example, /var/log/messages, or certain Oracle Grid Infrastructure logs)
19c 싱글db가 구성되어 있는 서버에 AHF를 root 유저로 설치하는 시나리오
*root 유저로 설치하기 위해선 ahf 설치 경로를 root 가 경로 전체에 owner인 경로 지정해줘야함
AHF 설치
먼저 Doc. 2291661.1 에서 해당 OS 용 파일 다운로드
AHF 미디어 업로드 및 root 유저로 해당 파일 압축 해제
1
2
3
4
5
6
7
8
9
10
11
|
# mkdir -p /home/oracle/media/ahf
파일 업로드
# cd /home/oracle/media/ahf
# ls
AHF-LINUX_v21.3.3.zip
# unzip AHF-LINUX_v21.3.3.zip
Archive: AHF-LINUX_v21.3.3.zip
inflating: README.txt
inflating: ahf_setup
extracting: ahf_setup.dat
inflating: oracle-tfa.pub
|
ahf용 경로 생성(root 소유)
1
|
# mkdir -p /ora_ahf
|
ahf 설치
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
|
# ./ahf_setup
AHF Installer for Platform Linux Architecture x86_64
AHF Installation Log : /tmp/ahf_install_211100_13363_2021_12_25-23_11_05.log
Starting Autonomous Health Framework (AHF) Installation
AHF Version: 21.3.3 Build Date: 202112130225
Default AHF Location : /opt/oracle.ahf <-- ahf 가 설치될 경로(ahf_loc 파라미터로 제어)
Do you want to install AHF at [/opt/oracle.ahf] ? [Y]|N : y <-- y 입력
AHF Location : /opt/oracle.ahf
AHF Data Directory stores diagnostic collections and metadata.
AHF Data Directory requires at least 5GB (Recommended 10GB) of free space.
Please Enter AHF Data Directory : /ora_ahf <-- ahf 로그가 쌓일 경로 입력
AHF Data Directory : /ora_ahf/oracle.ahf/data
Do you want to add AHF Notification Email IDs ? [Y]|N : n <-- n 입력
Extracting AHF to /opt/oracle.ahf
Configuring TFA Services
Discovering Nodes and Oracle Resources
Successfully generated certificates.
Starting TFA Services
Created symlink from /etc/systemd/system/multi-user.target.wants/oracle-tfa.service to /etc/systemd/system/oracle-tfa.service.
Created symlink from /etc/systemd/system/graphical.target.wants/oracle-tfa.service to /etc/systemd/system/oracle-tfa.service.
.--------------------------------------------------------------------------.
| Host | Status of TFA | PID | Port | Version | Build ID |
+------+---------------+-------+-------+------------+----------------------+
| oel7 | RUNNING | 14580 | 17211 | 21.3.3.0.0 | 21110020210423012809 |
'------+---------------+-------+-------+------------+----------------------'
Running TFA Inventory...
Adding default users to TFA Access list...
.-------------------------------------------------------.
| Summary of AHF Configuration |
+-----------------+-------------------------------------+
| Parameter | Value |
+-----------------+-------------------------------------+
| AHF Location | /opt/oracle.ahf |
| TFA Location | /opt/oracle.ahf/tfa |
| Orachk Location | /opt/oracle.ahf/orachk |
| Data Directory | /ora_ahf/oracle.ahf/data |
| Repository | /ora_ahf/oracle.ahf/data/repository |
| Diag Directory | /ora_ahf/oracle.ahf/data/oel7/diag |
'-----------------+-------------------------------------'
Starting orachk scheduler from AHF ...
AHF binaries are available in /opt/oracle.ahf/bin
AHF is successfully installed
Moving /tmp/ahf_install_211100_13363_2021_12_25-23_11_05.log to /ora_ahf/oracle.ahf/data/oel7/diag/ahf/
|
ahf 설치 완료
AHF 셋업 로그 마지막에 나와있는 경로로 가서 로그 확인
1
2
3
|
# cd /ora_ahf/oracle.ahf/data/oel7/diag/ahf/
# ls
ahfctl.log ahf_install_211100_13363_2021_12_25-23_11_05.log
|
AHF 로그와 설치 로그가 생성되어 있음
AHF로 로그 수집
tfactl 실행(diagcollect 기간 지정 (root 유저))
(운영환경에선 패스워드없는 ssh 가 막혀있는 경우가 대부분이기 때문에 rac 인경우 -node 노드명 입력해주는게 좋음)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
# tfactl diagcollect -from "Dec/24/2021 00:00:00" -to "Dec/25/2021 00:00:00" -node oel7
WARNING - AHF Software is older than 180 days. Please consider upgrading AHF to the latest version using ahfctl upgrade.
Collecting data for oel7 node(s).
Scanning files from Dec/24/2021 00:00:00 to Dec/25/2021 00:00:00
Collection Id : 20211225231607oel7
Detailed Logging at : /ora_ahf/oracle.ahf/data/repository/collection_Sat_Dec_25_23_16_08_KST_2021_node_all/diagcollect_20211225231607_oel7.log
2021/12/25 23:16:18 KST : NOTE : Any file or directory name containing the string .com will be renamed to replace .com with dotcom
2021/12/25 23:16:18 KST : Collection Name : tfa_Sat_Dec_25_23_16_08_KST_2021.zip
2021/12/25 23:16:18 KST : Collecting diagnostics from hosts : [oel7]
2021/12/25 23:16:18 KST : Collecting additional diagnostic information...
2021/12/25 23:16:18 KST : Getting list of files satisfying time range [12/24/2021 00:00:00 KST, 12/25/2021 00:00:00 KST]
2021/12/25 23:16:20 KST : Collecting ADR incident files...
2021/12/25 23:16:51 KST : Completed collection of additional diagnostic information...
2021/12/25 23:16:56 KST : Completed Local Collection
.---------------------------------.
| Collection Summary |
+------+-----------+-------+------+
| Host | Status | Size | Time |
+------+-----------+-------+------+
| oel7 | Completed | 9.4MB | 38s |
'------+-----------+-------+------'
Logs are being collected to: /ora_ahf/oracle.ahf/data/repository/collection_Sat_Dec_25_23_16_08_KST_2021_node_all
/ora_ahf/oracle.ahf/data/repository/collection_Sat_Dec_25_23_16_08_KST_2021_node_all/oel7.tfa_Sat_Dec_25_23_16_08_KST_2021.zip
You have new mail in /var/spool/mail/root
|
tfactl 실행(rac 환경에서 정보 수집시(각 노드)(oracle 유저))
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
$ tfactl diagcollect -srdc dbrac -node oel19db1
Enter the time of the incident [YYYY-MM-DD HH24:MI:SS,<RETURN>=ALL] : [문제 발생시점 시간 입력 또는 엔터]
Enter the Database Name, if the incident was NOT specific to a database (e.g. Node Reboot/Eviction) choose ALL [Required for this SRDC] : ORADB1
[모든 노드 수집 시 엔터, 나의경우 1번만 수집하기 위해 노드1번 SID 입력]
1. Aug/15/2021 07:46:46 : [oradb] Instance terminated by USER, pid = 28972
[문제가 발생했던 시점 리스트가 나옴, 여기서 나는 1을 선택, 문제가 없었다면 그냥 넘어감]
Please choose the event : 1-1 [1] 1
Selected value is : 1 ( Aug/15/2021 07:46:46 )
Scripts to be run by this srdc:
Components included in this srdc: OS CRS DATABASE CHMOS CHA ASM
Scanning files from Aug/15/2021 07:16:46 to Aug/15/2021 08:16:46
Collection Id : 20210815085853oel19db1
Detailed Logging at : /ORA19/app/oracle/ahf/oracle.ahf/data/repository/srdc_dbrac_collection_Sun_Aug_15_08_58_57_KST_2021_node_all/diagcollect_20210815085853_oel19db1.log
2021/08/15 08:59:05 KST : NOTE : Any file or directory name containing the string .com will be renamed to replace .com with dotcom
2021/08/15 08:59:05 KST : Collection Name : tfa_srdc_dbrac_Sun_Aug_15_08_58_57_KST_2021.zip
2021/08/15 08:59:05 KST : Scanning of files for Collection in progress...
2021/08/15 08:59:05 KST : Collecting additional diagnostic information...
2021/08/15 08:59:10 KST : Getting list of files satisfying time range [08/15/2021 07:16:46 KST, 08/15/2021 08:16:46 KST]
2021/08/15 08:59:27 KST : Collecting ADR incident files...
2021/08/15 09:00:13 KST : Completed collection of additional diagnostic information...
2021/08/15 09:00:17 KST : Completed Local Collection
.-------------------------------------.
| Collection Summary |
+----------+-----------+-------+------+
| Host | Status | Size | Time |
+----------+-----------+-------+------+
| oel19db1 | Completed | 1.5MB | 72s |
'----------+-----------+-------+------'
Logs are being collected to: /ORA19/app/oracle/ahf/oracle.ahf/data/repository/srdc_dbrac_collection_Sun_Aug_15_08_58_57_KST_2021_node_all
/ORA19/app/oracle/ahf/oracle.ahf/data/repository/srdc_dbrac_collection_Sun_Aug_15_08_58_57_KST_2021_node_all/oel19db1.tfa_srdc_dbrac_Sun_Aug_15_08_58_57_KST_2021.zip
|
tfactl 에 있는 SRDC은 Service Request Data Collection 이라는 뜻임
11번 째 줄에 srdc: OS CRS DATABASE CHMOS CHA ASM 라고 나와있음
장애가 발생한 시점을 기준으로 입력하면
해당시점 4시간 전의 데이터와 1시간 후의 데이터를 수집한다고함
나의 경우 장애 상황이 1번 있었기 때문에 해당 시간대 로그를 수집함
33, 34 번 째 줄에 생성된 로그들이 zip 형태로 묶여있음
zip 파일 확인
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
|
$ mkdir -p /home/oracle/imsi
$ cd /home/oracle/imsi
$ unzip /ORA19/app/oracle/ahf/oracle.ahf/data/repository/srdc_dbrac_collection_Sun_Aug_15_08_58_57_KST_2021_node_all/oel19db1.tfa_srdc_dbrac_Sun_Aug_15_08_58_57_KST_2021.zip
$ ls -al
total 60
drwxr-xr-x 3 oracle dba 4096 Aug 15 09:18 .
drwx------. 22 oracle oinstall 4096 Aug 15 09:18 ..
drwxr-xr-x 5 oracle dba 4096 Aug 15 09:18 oel19db1
-rw-r--r-- 1 oracle dba 9128 Aug 15 09:00 oel19db1.tfa_srdc_dbrac_Sun_Aug_15_08_58_57_KST_2021.zip.json
-rw-r--r-- 1 oracle dba 1364 Aug 15 09:00 oel19db1.tfa_srdc_dbrac_Sun_Aug_15_08_58_57_KST_2021.zip.txt
-rw-r--r-- 1 oracle dba 27408 Aug 15 09:00 oel19db1.zip_inventory.csv
-rw-r--r-- 1 oracle dba 26 Aug 15 08:59 TFA.txt
$ cd oel19db1
$ ls -al
total 2480
drwxr-xr-x 5 oracle dba 4096 Aug 15 09:18 .
drwxr-xr-x 3 oracle dba 4096 Aug 15 09:18 ..
-rw-r--r-- 1 oracle dba 23080 Aug 15 09:00 3915bf48-578c-40a3-a523-94d79951709b
-rw-r--r-- 1 oracle dba 2985 Aug 15 08:59 config.properties
drwxr-xr-x 5 oracle dba 43 Aug 15 09:18 diag
-rw-r--r-- 1 oracle dba 65 Aug 15 08:59 oel19db1_ACTIVEVERSION
-rw-r--r-- 1 oracle dba 200 Aug 15 08:59 oel19db1_afd_collection.err
-rw-r--r-- 1 oracle dba 2536 Aug 15 08:59 oel19db1_afd_collection.log
-rw-r--r-- 1 oracle dba 1473 Aug 15 08:59 oel19db1_afd_report
-rw-r--r-- 1 oracle dba 484 Aug 15 08:59 oel19db1_asm_collection.err
-rw-r--r-- 1 oracle dba 4537 Aug 15 08:59 oel19db1_asm_collection.log
-rw-r--r-- 1 oracle dba 27461 Aug 15 08:59 oel19db1_asm_collection.out
-rw-r--r-- 1 oracle dba 399 Aug 15 09:00 oel19db1_cha_collection.log
-rw-r--r-- 1 oracle dba 456 Aug 15 09:00 oel19db1_CHA_STATUS
-rw-r--r-- 1 oracle dba 184 Aug 15 08:59 oel19db1_CHECKCRS
-rw-r--r-- 1 oracle dba 559 Aug 15 08:59 oel19db1_cloudmetadata.log
-rw-r--r-- 1 oracle dba 28 Aug 15 08:59 oel19db1_cloudmetadata.out
-rw-r--r-- 1 oracle dba 1466 Aug 15 09:00 oel19db1_collection.err
-rw-r--r-- 1 oracle dba 11816 Aug 15 09:00 oel19db1_collection.log
-rw-r--r-- 1 oracle dba 113 Aug 15 08:59 oel19db1_CONFIGASM
-rw-r--r-- 1 oracle dba 76 Aug 15 08:59 oel19db1_CONFIGGNS
-rw-r--r-- 1 oracle dba 415 Aug 15 08:59 oel19db1_CONFIGSCAN
-rw-r--r-- 1 oracle dba 305 Aug 15 09:00 oel19db1_crs_collection.err
-rw-r--r-- 1 oracle dba 5438 Aug 15 09:00 oel19db1_crs_collection.log
-rw-r--r-- 1 oracle dba 88760 Aug 15 09:00 oel19db1_dmesg
-rw-r--r-- 1 oracle dba 228 Aug 15 08:59 oel19db1_DNSSERVERS
-rw-r--r-- 1 oracle dba 622 Aug 15 08:59 oel19db1_GETCSS
-rw-r--r-- 1 oracle dba 1938 Aug 15 08:59 oel19db1_gpnp_peer_profile.xml
-rw-r--r-- 1 oracle dba 1066 Aug 15 08:59 oel19db1_GPNPTOOL
-rw-r--r-- 1 oracle dba 84 Aug 15 09:00 oel19db1_INITTAB
-rw-r--r-- 1 oracle dba 57 Aug 15 08:59 oel19db1_IPMI
-rw-r--r-- 1 oracle dba 46559 Aug 15 08:59 oel19db1_LS
-rw-r--r-- 1 oracle dba 2142 Aug 15 09:00 oel19db1_LSMOD
-rw-r--r-- 1 oracle dba 741 Aug 15 09:00 oel19db1_NETSTAT
-rw-r--r-- 1 oracle dba 352 Aug 15 08:59 oel19db1_NODEAPPS
-rw-r--r-- 1 oracle dba 270 Aug 15 08:59 oel19db1_NSLOOKUP
-rw-r--r-- 1 oracle dba 1746 Aug 15 09:00 oel19db1_NSSWITCH_CONF
-rw-r--r-- 1 oracle dba 612 Aug 15 08:59 oel19db1_OCRBACKUP
-rw-r--r-- 1 oracle dba 17802 Aug 15 08:59 oel19db1_OCRDUMP
-rw-r--r-- 1 oracle dba 181 Aug 15 09:00 oel19db1_ocrloc
-rw-r--r-- 1 oracle dba 95 Aug 15 08:59 oel19db1_ohasdrun
-rw-r--r-- 1 oracle dba 51 Aug 15 08:59 oel19db1_OIFCFG
-rw-r--r-- 1 oracle dba 57847 Aug 15 08:59 oel19db1_OLRDUMP
-rw-r--r-- 1 oracle dba 101 Aug 15 09:00 oel19db1_olrloc
-rw-r--r-- 1 oracle dba 227 Aug 15 08:59 oel19db1_OLSNODES
-rw-r--r-- 1 oracle dba 857364 Aug 15 09:00 oel19db1_OPATCH_CRS
-rw-r--r-- 1 oracle dba 854271 Aug 15 08:59 oel19db1_OPATCH_DBHOMES
-rw-r--r-- 1 oracle dba 32 Aug 15 09:00 oel19db1_oracle-release
-rw-r--r-- 1 oracle dba 789 Aug 15 09:00 oel19db1_oratab
-rw-r--r-- 1 oracle dba 4227 Aug 15 09:00 oel19db1_os_collection.log
-rw-r--r-- 1 oracle dba 435 Aug 15 09:00 oel19db1_os-release
-rw-r--r-- 1 oracle dba 158254 Aug 15 09:00 oel19db1_os_report
-rw-r--r-- 1 oracle dba 94 Aug 15 08:59 oel19db1_PIDS
-rw-r--r-- 1 oracle dba 157 Aug 15 09:00 oel19db1_PING_INFO
-rw-r--r-- 1 oracle dba 19951 Aug 15 09:00 oel19db1_PROCDIRINFO
-rw-r--r-- 1 oracle dba 1382 Aug 15 08:59 oel19db1_PS
-rw-r--r-- 1 oracle dba 429 Aug 15 08:59 oel19db1_QUERYVOTE
-rw-r--r-- 1 oracle dba 52 Aug 15 09:00 oel19db1_redhat-release
-rw-r--r-- 1 oracle dba 49146 Aug 15 09:00 oel19db1_RPMQA
-rw-r--r-- 1 oracle dba 66 Aug 15 09:00 oel19db1_RUNLEVEL
-rw-r--r-- 1 oracle dba 62 Aug 15 08:59 oel19db1_SOFTWAREVERSION
-rw-r--r-- 1 oracle dba 612 Aug 15 09:00 oel19db1_SRCFG.json
-rw-r--r-- 1 oracle dba 330 Aug 15 09:00 oel19db1_SRCFG.log
-rw-r--r-- 1 oracle dba 116 Aug 15 08:59 oel19db1_STATRESCRS
-rw-r--r-- 1 oracle dba 116 Aug 15 08:59 oel19db1_STATRESCRSFULL
-rw-r--r-- 1 oracle dba 116 Aug 15 08:59 oel19db1_STATRESDEPENDENCY
-rw-r--r-- 1 oracle dba 25336 Aug 15 08:59 oel19db1_STATRESFULLOHAS
-rw-r--r-- 1 oracle dba 1482 Aug 15 08:59 oel19db1_STATRESOHAS
-rw-r--r-- 1 oracle dba 98 Aug 15 09:00 oel19db1_summary
-rw-r--r-- 1 oracle dba 6826 Aug 15 09:00 oel19db1_TOP_50_MEMORY
-rw-r--r-- 1 oracle dba 5289 Aug 15 09:00 oel19db1_VARTMPORACLE
drwxr-xr-x 3 oracle dba 17 Aug 15 09:18 ORA19
-rw-r--r-- 1 oracle dba 150 Aug 15 08:59 script_db_feature_usage.sql.sh
-rw-r--r-- 1 oracle dba 39 Aug 15 08:59 skipped_files.txt
-rw-r--r-- 1 oracle dba 1727 Aug 15 08:58 tfa_1628985459_srdc_dbracsrdc_user_log
-rw-r--r-- 1 oracle dba 7094 Aug 15 08:58 tfa_1628985459_srdc_dbracuserenv
-rw-r--r-- 1 oracle dba 3520 Aug 15 08:58 tfa_1628985459_srdc_dbrac.xml
drwxr-xr-x 3 oracle dba 17 Aug 15 09:18 var
|
여러가지 정보들이 있음
몇가지 파일 확인
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
$ cat oel19db1_CHECKCRS
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
$ cat oel19db1_summary
GI information
==============
Oracle Clusterware active version on the cluster is [19.0.0.0.0]
$ cat oel19db1_QUERYVOTE
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 2797194080b04f4abfc2e1836b188d03 (/dev/oracleasm/disks/OCR_VOTE1) [OCR_VOTE]
2. ONLINE f1ad9c6be7784f55bf31c31cca7e6cdb (/dev/oracleasm/disks/OCR_VOTE3) [OCR_VOTE]
3. ONLINE 4c5e10cd334b4facbfa34ad4f0c6912a (/dev/oracleasm/disks/OCR_VOTE2) [OCR_VOTE]
Located 3 voting disk(s).
$ cat oel19db1_OCRBACKUP
oel19db2 2020/03/10 08:38:27 +OCR_VOTE:/oel19db/OCRBACKUP/backup00.ocr.263.1034671097 2701864972
oel19db2 2020/03/06 06:19:05 +OCR_VOTE:/oel19db/OCRBACKUP/backup01.ocr.261.1034317133 724960844
oel19db2 2020/03/06 02:18:51 +OCR_VOTE:/oel19db/OCRBACKUP/backup02.ocr.258.1034302721 724960844
oel19db2 2020/03/10 08:38:27 +OCR_VOTE:/oel19db/OCRBACKUP/day.ocr.259.1034671109 2701864972
oel19db2 2020/03/06 02:18:51 +OCR_VOTE:/oel19db/OCRBACKUP/week.ocr.260.1034302733 724960844
PROT-25: Manual backups for the Oracle Cluster Registry are not available
|
파일 이름대로 체크, db 버전 정보, votedisk 조회, ocr 백업등의 로그들이 남아있음
장애 발생시 해당 로그들을 수집 후 떨어진 zip 파일을 SR 에 첨부파일로 올리면됨
참고1
ahfctl help
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
# ahfctl diagcollect -help
WARNING - AHF Software is older than 180 days. Please consider upgrading AHF to the latest version using ahfctl upgrade.
Collect logs from across nodes in cluster
Usage : /bin/tfactl diagcollect [ [component_name1] [component_name2] ... [component_nameN] | [-srdc <srdc_profile>] | [-defips]] [-sr <SR#>] [-node <all|local|n1,n2,..>] [-tag <tagname>] [-z <filename>] [-last <n><m|h|d>| -from <time> -to <time> | -for <time>] [-nocopy] [-notrim] [-silent] [-cores][-collectalldirs][-collectdir <dir1,dir2..>][-examples]
components:-ips|-database|-asm|-crsclient|-dbclient|-dbwlm|-tns|-rhp|-procinfo|-cvu|-afd|-crs|-cha|-wls|-emagenti|-emagent|-oms|-omsi|-ocm|-emplugins|-em|-acfs|-install|-cfgtools|-os|-ashhtml|-ashtext|-awrhtml|-awrtext|-sosreport|-qos|-ahf
-srdc Service Request Data Collection (SRDC).
-database Specify comma separated list of db unique names for collection
-defips Include in the default collection the IPS Packages for:
ASM, CRS and Databases
-sr Enter SR number to which the collection will be uploaded
-node Specify comma separated list of host names for collection
-tag <tagname> The files will be collected into tagname directory inside
repository
-z <zipname> The collection zip file will be given this name within the
TFA collection repository
-last <n><m|h|d> Files from last 'n' [m]inutes, 'n' [d]ays or 'n' [h]ours
-since Same as -last. Kept for backward compatibility.
-from "Mon/dd/yyyy hh:mm:ss" From <time>
or "yyyy-mm-dd hh:mm:ss"
or "yyyy-mm-ddThh:mm:ss"
or "yyyy-mm-dd"
-to "Mon/dd/yyyy hh:mm:ss" To <time>
or "yyyy-mm-dd hh:mm:ss"
or "yyyy-mm-ddThh:mm:ss"
or "yyyy-mm-dd"
-for "Mon/dd/yyyy" For <date>.
or "yyyy-mm-dd"
-nocopy Does not copy back the zip files to initiating node from all nodes
-notrim Does not trim the files collected
-silent This option is used to submit the diagcollection as a background
process
-cores Collect Core files when it would normally not have been
collected
-collectalldirs Collect all files from a directory marked "Collect All"
flag to true
-collectdir Specify comma separated list of directories and collection will
include all files from these irrespective of type and time constraints
in addition to components specified
-examples Show diagcollect usage examples
For detailed help on each component use:
/bin/tfactl diagcollect [component_name1] [component_name2] ... [component_nameN] -help
|
참조 : 2291661.1
https://positivemh.tistory.com/607
https://positivemh.tistory.com/748
https://positivemh.tistory.com/791
'ORACLE > Admin' 카테고리의 다른 글
오라클 19c 장애시 로그수집 가이드(수동) (0) | 2021.10.12 |
---|---|
오라클 11g R2 윈도우환경에서 장애시 로그수집 가이드(SRDC) (0) | 2021.08.16 |
오라클 19c Cluster(grid) 프로세스 시작 순서도 (0) | 2021.08.05 |
오라클 19c 리스너 로그 월별 자동 백업 (0) | 2021.07.19 |
오라클 19c 유저 이름 변경 방법 (0) | 2021.07.14 |