OS환경 : Oracle Linux 6.8 (64bit)
DB 환경 : Oracle Database 11.2.0.4
방법 : 오라클 11g R2 diag collection 로그수집 가이드
DB에 문제가 발생했을때 로그를 수집해서 SR에 업로드 해야함
그 방법을 설명함
AHF(TFA) 파일을 다운받아 서버에 올려서 로그수집하기 어려운 경우(https://positivemh.tistory.com/607)
$GRID_HOME에 있는 diagcollection.sh 파일을 이용해 로그를 수집할 수 있음
RAC인 경우 양쪽노드에서 각각 수집해줘야함
로그 저장용 임시 폴더 생성
1 2 3 4 | # mkdir -p log # cd log # pwd /root/log |
해당 폴더에서 로그수집쉘(diagcollection.sh) 실행
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | # /oracle/grid/product/11.2.0/grid/bin/diagcollection.sh Production Copyright 2004, 2010, Oracle. All rights reserved Cluster Ready Services (CRS) diagnostic collection tool The following CRS diagnostic archives will be created in the local directory. crsData_orcl01_20200724_2359.tar.gz -> logs,traces and cores from CRS home. Note: core files will be packaged only with the --core option. ocrData_orcl01_20200724_2359.tar.gz -> ocrdump, ocrcheck etc coreData_orcl01_20200724_2359.tar.gz -> contents of CRS core files in text format osData_orcl01_20200724_2359.tar.gz -> logs from Operating System lsInventory_orcl01_20200724_2359 ->Opatch lsinventory details Collecting crs data Collecting OCR data Collecting information from core files No corefiles found Collecting lsinventory details Collecting OS logs Collecting sysconfig data |
수집된 로그 파일 확인
1 2 3 4 5 6 7 8 9 | # ls -al total 14104 drwxr-xr-x 2 root root 4096 Jul 24 23:59 . dr-xr-x---. 18 root root 4096 Jul 24 23:58 .. -rw-r--r-- 1 root root 13954636 Jul 24 23:59 crsData_orcl01_20200724_2359.tar.gz -rw-r--r-- 1 root root 1080 Jul 24 23:59 lsInventory_orcl01_20200724_2359 -rw-r--r-- 1 root root 25188 Jul 24 23:59 ocrData_orcl01_20200724_2359.tar.gz -rw-r--r-- 1 root root 419913 Jul 24 23:59 osData_orcl01_20200724_2359.tar.gz -rw-r--r-- 1 root root 24375 Jul 24 23:59 sysconfig_orcl01_20200724_2359.txt |
각각 파일 확인
lsInventory_orcl01 파일
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 | # cat lsInventory_orcl01_20200724_2359 Oracle Interim Patch Installer version 11.2.0.3.4 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /oracle/grid/product/11.2.0/grid Central Inventory : /oracle/app/oraInventory from : /oracle/grid/product/11.2.0/grid/oraInst.loc OPatch version : 11.2.0.3.4 OUI version : 11.2.0.4.0 Log file location : /oracle/grid/product/11.2.0/grid/cfgtoollogs/opatch/opatch2020-07-24_23-59-20PM_1.log Lsinventory Output file location : /oracle/grid/product/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2020-07-24_23-59-20PM.txt -------------------------------------------------------------------------------- Installed Top-level Products (1): Oracle Grid Infrastructure 11g 11.2.0.4.0 There are 1 products installed in this Oracle Home. There are no Interim patches installed in this Oracle Home. Rac system comprising of multiple nodes Local node = orcl01 Remote node = orcl02 -------------------------------------------------------------------------------- OPatch succeeded. |
GRID_HOME에 대한 lsinventory 내역을 수집함
sysconfig_orcl01 파일 확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 | # cat sysconfig_orcl01_20200724_2359.txt /bin/uname -a (결과 생략) ============================================= /bin/cat /proc/cpuinfo (결과 생략) ============================================= /bin/cat /proc/meminfo (결과 생략) ============================================= /sbin/ifconfig -a (결과 생략) ============================================= /sbin/fdisk -l (결과 생략) ============================================= /bin/mount (결과 생략) ============================================= /bin/cat /proc/slabinfo (결과 생략) |
os 정보, cpu, 메모리, 네트워크, 디스크 등에 대한 정보를 수집함
osData_orcl01 파일 확인
압축 해제
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | # tar -xvf osData_orcl01_20200724_2359.tar.gz var/log/messages var/log/messages-20200628 var/log/messages-20200705 var/log/messages-20200712 var/log/messages-20200719 # cd var/log # ls -al total 6324 drwxr-xr-x 2 root root 122 Jul 25 00:13 . drwxr-xr-x 3 root root 17 Jul 25 00:13 .. -rw------- 1 root root 340041 Jul 24 23:59 messages -rw------- 1 root root 946717 Jun 28 03:28 messages-20200628 -rw------- 1 root root 1726779 Jul 5 03:45 messages-20200705 -rw------- 1 root root 1722062 Jul 12 03:34 messages-20200712 -rw------- 1 root root 1728200 Jul 19 03:27 messages-20200719 |
OS에 있는 /var/log/message* 파일들을 수집함
1 2 3 4 5 6 | # ls -al /var/log/me* -rw------- 1 root root 340580 Jul 25 00:10 /var/log/messages -rw------- 1 root root 946717 Jun 28 03:28 /var/log/messages-20200628 -rw------- 1 root root 1726779 Jul 5 03:45 /var/log/messages-20200705 -rw------- 1 root root 1722062 Jul 12 03:34 /var/log/messages-20200712 -rw------- 1 root root 1728200 Jul 19 03:27 /var/log/messages-20200719 |
ocrData_orcl01 파일 확인
압축 해제
1 2 3 4 5 | # tar -xvf ocrData_orcl01_20200724_2359.tar.gz orcl01_OCRDUMP orcl01_OLRDUMP orcl01_OCRCHECK orcl01_OCRBACKUP |
orcl01_OLRDUMP, orcl01_OCRDUMP 파일 확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | # head orcl01_OLRDUMP 07/24/2020 23:59:15 /oracle/grid/product/11.2.0/grid/bin/ocrdump.bin -local orcl01_OLRDUMP [SYSTEM] UNDEF : SECURITY : {USER_PERMISSION : PROCR_ALL_ACCESS, GROUP_PERMISSION : PROCR_READ, OTHER_PERMISSION : PROCR_READ, USER_NAME : root, GROUP_NAME : root} [SYSTEM.crs] UNDEF : SECURITY : {USER_PERMISSION : PROCR_ALL_ACCESS, GROUP_PERMISSION : PROCR_READ, OTHER_PERMISSION : PROCR_READ, USER_NAME : root, GROUP_NAME : root} # head orcl01_OCRDUMP 07/24/2020 23:59:14 /oracle/grid/product/11.2.0/grid/bin/ocrdump.bin orcl01_OCRDUMP [SYSTEM] UNDEF : SECURITY : {USER_PERMISSION : PROCR_ALL_ACCESS, GROUP_PERMISSION : PROCR_READ, OTHER_PERMISSION : PROCR_READ, USER_NAME : root, GROUP_NAME : root} [SYSTEM.version] UB4 (10) : 5 SECURITY : {USER_PERMISSION : PROCR_ALL_ACCESS, GROUP_PERMISSION : PROCR_READ, OTHER_PERMISSION : PROCR_READ, USER_NAME : root, GROUP_NAME : root} |
OCR, OLR(Oracle Local Registry)에 대한 DUMP를 수집함
orcl01_OCRBACKUP, orcl01_OCRCHECK 파일 확인
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 orcl01_OCRBACKUP orcl01 2020/07/24 22:58:18 /oracle/grid/product/11.2.0/grid/cdata/orcl-cluster/backup00.ocr orcl01 2020/07/24 18:58:17 /oracle/grid/product/11.2.0/grid/cdata/orcl-cluster/backup01.ocr orcl01 2020/07/24 14:58:17 /oracle/grid/product/11.2.0/grid/cdata/orcl-cluster/backup02.ocr orcl01 2020/07/23 02:58:15 /oracle/grid/product/11.2.0/grid/cdata/orcl-cluster/day.ocr orcl01 2020/07/20 02:58:11 /oracle/grid/product/11.2.0/grid/cdata/orcl-cluster/week.ocr PROT-25: Manual backups for the Oracle Cluster Registry are not available # cat orcl01_OCRCHECK Status of Oracle Cluster Registry is as follows : Version : 3 Total space (kbytes) : 262120 Used space (kbytes) : 2952 Available space (kbytes) : 259168 ID : 1797319969 Device/File Name : +OCR_VOTE Device/File integrity check succeeded Device/File not configured Device/File not configured Device/File not configured Device/File not configured Cluster registry integrity check succeeded Logical corruption check succeeded |
ocrconfig -showbackup 정보와 ocrcheck 정보를 저장하고 있음
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 | # ocrconfig -showbackup orcl01 2020/07/24 22:58:18 /oracle/grid/product/11.2.0/grid/cdata/orcl-cluster/backup00.ocr orcl01 2020/07/24 18:58:17 /oracle/grid/product/11.2.0/grid/cdata/orcl-cluster/backup01.ocr orcl01 2020/07/24 14:58:17 /oracle/grid/product/11.2.0/grid/cdata/orcl-cluster/backup02.ocr orcl01 2020/07/23 02:58:15 /oracle/grid/product/11.2.0/grid/cdata/orcl-cluster/day.ocr orcl01 2020/07/20 02:58:11 /oracle/grid/product/11.2.0/grid/cdata/orcl-cluster/week.ocr PROT-25: Manual backups for the Oracle Cluster Registry are not available # ocrcheck Status of Oracle Cluster Registry is as follows : Version : 3 Total space (kbytes) : 262120 Used space (kbytes) : 2952 Available space (kbytes) : 259168 ID : 1797319969 Device/File Name : +OCR_VOTE Device/File integrity check succeeded Device/File not configured Device/File not configured Device/File not configured Device/File not configured Cluster registry integrity check succeeded Logical corruption check succeeded |
crsData_orcl01 파일확인
압축 해제
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 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 | # tar -xvf crsData_orcl01_20200724_2359.tar.gz install/make.log install/root_orcl01_2020-07-19_22-36-41.log log/orcl01/alertorcl01.log <- grid alert log log/orcl01/crsd/crsdOUT.log log/orcl01/crsd/crsd.log log/orcl01/ctssd/ctssdOUT.log log/orcl01/ctssd/octssd.l02 log/orcl01/ctssd/octssd.l01 log/orcl01/ctssd/octssd.log log/orcl01/evmd/evmdOUT.log log/orcl01/evmd/evmd.log log/orcl01/cssd/cssdOUT.log log/orcl01/cssd/ocssd.log log/orcl01/mdnsd/mdnsdOUT.log log/orcl01/mdnsd/mdnsd.log log/orcl01/gpnpd/gpnpdOUT.log log/orcl01/gpnpd/gpnpd.log log/orcl01/gpnpd/orcl01.pid log/orcl01/gipcd/gipcdOUT.log log/orcl01/gipcd/gipcd.l10 log/orcl01/gipcd/gipcd.l09 log/orcl01/gipcd/gipcd.l08 log/orcl01/gipcd/gipcd.l07 log/orcl01/gipcd/gipcd.l06 log/orcl01/gipcd/gipcd.l05 log/orcl01/gipcd/gipcd.l04 log/orcl01/gipcd/gipcd.l03 log/orcl01/gipcd/gipcd.l02 log/orcl01/gipcd/gipcd.l01 log/orcl01/gipcd/gipcd.log log/orcl01/cvu/cvulog/cvu20200724224430.log log/orcl01/cvu/cvutrc/cvutrace.log.0 log/orcl01/cvu/cvutrc/cvuhelper.log.0 log/orcl01/cvu/cvutrc/cvutrace.log.1 log/orcl01/ohasd/ohasdOUT.log log/orcl01/ohasd/ohasd.l02 log/orcl01/ohasd/ohasd.l01 log/orcl01/ohasd/ohasd.log log/orcl01/agent/crsd/oraagent_oracle/oraagent_oracle.pid log/orcl01/agent/crsd/oraagent_oracle/oraagent_oracle.l01 log/orcl01/agent/crsd/oraagent_oracle/oraagent_oracle.log log/orcl01/agent/crsd/orarootagent_root/orarootagent_root.log log/orcl01/agent/crsd/orarootagent_root/orarootagent_root.pid log/orcl01/agent/crsd/scriptagent_oracle/scriptagent_oracleOUT.log log/orcl01/agent/crsd/scriptagent_oracle/scriptagent_oracle.log log/orcl01/agent/ohasd/oraagent_oracle/oraagent_oracle.log log/orcl01/agent/ohasd/oraagent_oracle/oraagent_oracle.pid log/orcl01/agent/ohasd/oraagent_oracle/oraagent_oracleOUT.log log/orcl01/agent/ohasd/oracssdmonitor_root/oracssdmonitor_root.log log/orcl01/agent/ohasd/oracssdagent_root/oracssdagent_root.log log/orcl01/agent/ohasd/orarootagent_root/orarootagent_root.pid log/orcl01/agent/ohasd/orarootagent_root/orarootagent_rootOUT.log log/orcl01/agent/ohasd/orarootagent_root/orarootagent_root.l01 log/orcl01/agent/ohasd/orarootagent_root/orarootagent_root.log log/orcl01/client/olsnodes.log log/orcl01/client/oifcfg.log log/orcl01/client/ocrconfig_19764.log log/orcl01/client/clscfg.log log/orcl01/client/gpnptool_20212.log log/orcl01/client/gpnptool_20218.log log/orcl01/client/crsctl_root.log log/orcl01/client/crswrapexece.log log/orcl01/client/gpnp_20994.log log/orcl01/client/ocrcheck_21149.log log/orcl01/client/ocrconfig_21162.log log/orcl01/client/clscfg1.log log/orcl01/client/gpnptool_21648.log log/orcl01/client/css.log log/orcl01/client/clsc.log log/orcl01/client/css1.log log/orcl01/client/clsc1.log log/orcl01/client/crsctl_oracle.log log/orcl01/client/ocr_22667_7.log log/orcl01/client/clsc2.log log/orcl01/client/ocrconfig_23192.log log/orcl01/client/clsc3.log log/orcl01/client/ocrcheck_26330.log log/orcl01/client/ocrcheck_26992.log log/orcl01/client/clsc4.log log/orcl01/client/ocrdump_30718.log log/orcl01/client/ocrdump_30721.log log/orcl01/client/ocrcheck_30725.log log/orcl01/client/ocrconfig_30738.log log/orcl01/crfmond/crfmondOUT.log log/orcl01/crfmond/crfmond.log log/orcl01/crflogd/crflogdOUT.log log/orcl01/crflogd/crflogd.log cfgtoollogs/oracle.assistants.asm_2020-07-19_10-54-33-PM.log cfgtoollogs/oracle.crs_2020-07-19_10-54-33-PM.log cfgtoollogs/oracle.assistants.netca.client_2020-07-19_10-54-33-PM.log cfgtoollogs/OuiConfigVariables_2020-07-19_10-54-33-PM.log cfgtoollogs/CfmLogger_2020-07-19_10-54-33-PM.log cfgtoollogs/configToolAllCommands cfgtoollogs/configToolAllCommands.bak cfgtoollogs/configToolFailedCommands cfgtoollogs/configToolFailedCommands.bak cfgtoollogs/cfgfw/CfmLogger_2020-07-19_10-34-19-PM.log cfgtoollogs/cfgfw/oracle.crs_2020-07-19_10-34-19-PM.log cfgtoollogs/cfgfw/oracle.assistants.netca.client_2020-07-19_10-34-19-PM.log cfgtoollogs/cfgfw/OuiConfigVariables_2020-07-19_10-34-19-PM.log cfgtoollogs/cfgfw/oracle.assistants.asm_2020-07-19_10-34-20-PM.log cfgtoollogs/cfgfw/CfmLogger_2020-07-19_10-54-32-PM.log cfgtoollogs/cfgfw/oracle.crs_2020-07-19_10-54-33-PM.log cfgtoollogs/cfgfw/oracle.assistants.netca.client_2020-07-19_10-54-33-PM.log cfgtoollogs/cfgfw/OuiConfigVariables_2020-07-19_10-54-33-PM.log cfgtoollogs/cfgfw/oracle.assistants.asm_2020-07-19_10-54-33-PM.log cfgtoollogs/crsconfig/rootcrs_orcl01.log cfgtoollogs/crsconfig/srvmcfg0.log cfgtoollogs/crsconfig/srvmcfg1.log cfgtoollogs/crsconfig/srvmcfg2.log cfgtoollogs/crsconfig/srvmcfg3.log cfgtoollogs/crsconfig/srvmcfg4.log cfgtoollogs/crsconfig/srvmcfg5.log cfgtoollogs/crsconfig/srvmcfg6.log cfgtoollogs/crsconfig/srvmcfg7.log cfgtoollogs/crsconfig/srvmcfg8.log cfgtoollogs/oui/UpdateNodeList2020-07-19_10-54-33PM.log cfgtoollogs/oui/oraInstall2020-07-19_10-54-33PM.out cfgtoollogs/oui/oraInstall2020-07-19_10-54-33PM.err cfgtoollogs/oui/oraInstall2020-07-19_10-54-33PM.err.orcl02 cfgtoollogs/oui/oraInstall2020-07-19_10-54-33PM.out.orcl02 cfgtoollogs/oui/UpdateNodeList2020-07-19_10-54-33PM.log.orcl02 cfgtoollogs/oui/installActions2020-07-19_10-12-09PM.log cfgtoollogs/oui/time2020-07-19_10-12-09PM.log cfgtoollogs/oui/oraInstall2020-07-19_10-12-09PM.out cfgtoollogs/oui/oraInstall2020-07-19_10-12-09PM.err cfgtoollogs/oui/silentInstall2020-07-19_10-12-09PM.log cfgtoollogs/oui/oraInstall2020-07-19_10-12-09PM.err.orcl02 cfgtoollogs/oui/oraInstall2020-07-19_10-12-09PM.out.orcl02 cfgtoollogs/oui/AttachHome2020-07-19_10-12-09PM.log.orcl02 cfgtoollogs/opatch/opatch_history.txt cfgtoollogs/opatch/opatch2020-07-24_23-42-10PM_1.log cfgtoollogs/opatch/lsinv/lsinventory2020-07-24_23-42-10PM.txt oc4j/j2ee/home/log/oc4j_stdout_err.log oc4j/j2ee/home/log/oc4j_2020_07_19_22_44_04.out oc4j/j2ee/home/log/oc4j_2020_07_19_22_44_04.err oc4j/j2ee/home/log/server.log oc4j/j2ee/home/log/system-application.log oc4j/j2ee/home/log/global-application.log oc4j/j2ee/home/log/dbwlm.log oc4j/j2ee/home/log/rmi.log oc4j/j2ee/home/log/jms.log oc4j/j2ee/home/log/oc4j_shutter_stdout_err.log oc4j/j2ee/home/log/oc4j/log.xml oc4j/j2ee/home/log/wsmgmt/auditing/log.xml oc4j/j2ee/home/log/wsmgmt/logging/log.xml oc4j/j2ee/home/log/dbwlm/auditing/log.xml oc4j/j2ee/home/log/dbwlm/logging/log.xml |
crs 로그들이 저장되어 있음
diagcollection.sh 쉘로는 grid관련 로그(grid alert log 등)들만 수집이됨
db alert log나 ASM alert log는 수집되지 않음
해당 로그는 수동으로 수집해줘야함
1 2 3 4 5 6 7 | $ cd /oracle/app/oracle/diag/asm/+asm/+ASM1/trace $ ls -al al* -rw-r----- 1 oracle dba 30903 Jul 25 00:18 alert_+ASM1.log $ cd /oracle/app/oracle/diag/rdbms/orcl/ORCL01/trace/ $ ls -al al* -rw-r----- 1 oracle dba 38733 Jul 24 22:00 alert_ORCL1.log |
추가로 OPatch 상세 정보도 수집
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 | $ $ORACLE_HOME/OPatch/opatch lsinventory -detail Oracle Interim Patch Installer version 11.2.0.3.4 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /oracle/app/oracle/product/11.2.0/db_1 Central Inventory : /oracle/app/oraInventory from : /oracle/app/oracle/product/11.2.0/db_1/oraInst.loc OPatch version : 11.2.0.3.4 OUI version : 11.2.0.4.0 Log file location : /oracle/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2020-07-25_00-48-08AM_1.log Lsinventory Output file location : /oracle/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2020-07-25_00-48-08AM.txt -------------------------------------------------------------------------------- Installed Top-level Products (1): Oracle Database 11g 11.2.0.4.0 There are 1 products installed in this Oracle Home. Installed Products (136): Agent Required Support Files 10.2.0.4.5 Assistant Common Files 11.2.0.4.0 Bali Share 1.1.18.0.0 Buildtools Common Files 11.2.0.4.0 Character Set Migration Utility 11.2.0.4.0 Cluster Verification Utility Common Files 11.2.0.4.0 Database Configuration and Upgrade Assistants 11.2.0.4.0 Database SQL Scripts 11.2.0.4.0 ..(생략) $ $GRID_HOME/OPatch/opatch lsinventory -detail Oracle Interim Patch Installer version 11.2.0.3.4 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /oracle/app/oracle/product/11.2.0/db_1 Central Inventory : /oracle/app/oraInventory from : /oracle/app/oracle/product/11.2.0/db_1/oraInst.loc OPatch version : 11.2.0.3.4 OUI version : 11.2.0.4.0 Log file location : /oracle/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2020-07-25_00-48-45AM_1.log Lsinventory Output file location : /oracle/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2020-07-25_00-48-45AM.txt -------------------------------------------------------------------------------- Installed Top-level Products (1): Oracle Database 11g 11.2.0.4.0 There are 1 products installed in this Oracle Home. Installed Products (136): Agent Required Support Files 10.2.0.4.5 Assistant Common Files 11.2.0.4.0 Bali Share 1.1.18.0.0 Buildtools Common Files 11.2.0.4.0 Character Set Migration Utility 11.2.0.4.0 Cluster Verification Utility Common Files 11.2.0.4.0 Database Configuration and Upgrade Assistants 11.2.0.4.0 ..(생략) |
참조 : https://positivemh.tistory.com/607
https://positivemh.tistory.com/483
https://positivemh.tistory.com/301
https://positivemh.tistory.com/544
'ORACLE > Admin' 카테고리의 다른 글
오라클 일반 테이블과 blob 테이블 생성, 데이터 삭제 후 datapump 테스트 (0) | 2020.08.01 |
---|---|
오라클 11g 새로운 Job (0) | 2020.07.27 |
Windows Server 2016 서버 정상종료 시 oracle shutdown 프로세스 (0) | 2020.07.15 |
오라클 11g R2 컴포넌트 설명 (0) | 2020.07.15 |
오라클 bdump 경로에 생기는 sbtio.log 파일 (0) | 2020.07.10 |