Oracle 11g \ubd80\ud130 Alert.log \uc640 trace file \uc740 \uc0c8\ub85c\uc6b4 \ud615\uc2dd\uc73c\ub85c \uc0dd\uc131\uc774 \ub418\uba70, \uc774\ub294 ADR (Automatic Diagnotic Repository) \uc5d0 \uc0dd\uc131\uc774 \ub41c\ub2e4.<\/p>\n
\ubcf8 \ubb38\uc11c\uc5d0\uc11c\ub294 Database \uc5d0 \uc2ec\uac01\ud55c \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud55c \uacbd\uc6b0, ADRCI \uba85\ub839\uc5b4\ub97c \uc774\uc6a9\ud558\uc5ec \uc5d0\ub7ec\ub97c \ud655\uc778\ud558\uace0 \uad00\ub828\ub41c alert.log \ubc0f trace file \uc744 \uc624\ub77c\ud074 \uace0\uac1d\uc9c0\uc6d0\uc13c\ud130\ub85c \uc804\uc1a1\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574\uc11c \uc124\uba85\ud55c\ub2e4.<\/p>\n
IPS \uc0ac\uc6a9\ubc95<\/p>\n
ORACLE 11g \ub294 problem (Database \uc5d0\uc11c \ubc1c\uc0dd\ud55c \uc5d0\ub7ec\ucf54\ub4dc)\uacfc incident (\uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud55c \uae30\ub85d)\uc5d0 \uad00\ub828\ub41c trace file \ub4e4\uc744 \uc790\ub3d9\uc73c\ub85c \uc218\uc9d1\ud574\uc8fc\ub294 \uae30\ub2a5\uc744 \uc81c\uacf5\ud55c\ub2e4.<\/p>\n
\uc774 \uae30\ub2a5\uc744 IPS (Incident Packaging Service) \ub77c\uace0 \ud558\uba70, \uc778\ud130\ud398\uc774\uc2a4\ub85c GUI \ud658\uacbd\uacfc ADRCI command \ub97c \uc81c\uacf5\ud55c\ub2e4.
\nDatabase \uc5d0 \ubc1c\uc0dd\ud55c \ubaa8\ub4e0 \uc2ec\uac01\ud55c \uc5d0\ub7ec\ub4e4\uc740 \uac01\uac01\uc758 incident \ub97c \uc0dd\uc131\ud55c\ub2e4.<\/p>\n
IPS \ub97c \ud1b5\ud574\uc11c \uc0dd\uc131\ub41c \uc555\ucd95 \ud30c\uc77c\uc740 \uc5d0\ub7ec\uc5d0 \ub300\ud55c alert.log file, \ubaa8\ub4e0 trace file \uacfc \uc9c4\ub2e8 \uc815\ubcf4\ub97c \ud3ec\ud568\ud558\uace0 \uc788\uae30 \ub54c\ubb38\uc5d0, \ud574\ub2f9 error \uc5d0 \ub300\ud55c \uc815\ubcf4\uc218\uc9d1\uc744 \uac04\ud3b8\ud788 \uc218\ud589\ud560 \uc218 \uc788\ub2e4.<\/p>\n
Database \uc758 \uc5d0\ub7ec \ud655\uc778 \ubc0f \uad00\ub828 file\uc744 \uc624\ub77c\ud074 \uace0\uac1d\uc9c0\uc6d0\uc13c\ud130\ub85c \uc804\uc1a1\ud558\ub294 \ubc29\ubc95 :<\/strong><\/p>\n 1. Database \uc5d0\uc11c \ubc1c\uc0dd\ud55c \uc2ec\uac01\ud55c \uc5d0\ub7ec \ubc1c\uc0dd 2. ADR\uacfc Alert.log \uc5d0\uc11c \uc5d0\ub7ec\ub97c \ud655\uc778\ud55c\ub2e4. 3. \ubd84\uc11d\uc774 \ud544\uc694\ud55c \uc5d0\ub7ec\uc758 \ubc1c\uc0dd \uae30\ub85d\uc744 \ud655\uc778\ud55c\ub2e4. 4. IPS (incident packaging service) \ub97c \uc218\ud589\ud558\uc5ec alert.log , trace file \ubc0f diag \uc815\ubcf4\uc5d0 \ub300\ud55c \uc555\ucd95 \ud30c\uc77c \uc0dd\uc131. (My Oracle Support \uc811\uc18d \ud544\uc694)<\/p>\n \ucc38\uace0\uc790\ub8cc : DOC ID: 738732.1 ADR Different Methods to Create IPS Package<\/p>\n","protected":false},"excerpt":{"rendered":" Oracle 11g \ubd80\ud130 Alert.log \uc640 trace file \uc740 \uc0c8\ub85c\uc6b4 \ud615\uc2dd\uc73c\ub85c \uc0dd\uc131\uc774 \ub418\uba70, \uc774\ub294 ADR (Automatic Diagnotic Repository) \uc5d0 \uc0dd\uc131\uc774 \ub41c\ub2e4. \ubcf8 \ubb38\uc11c\uc5d0\uc11c\ub294 Database \uc5d0 \uc2ec\uac01\ud55c \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud55c \uacbd\uc6b0, ADRCI \uba85\ub839\uc5b4\ub97c \uc774\uc6a9\ud558\uc5ec \uc5d0\ub7ec\ub97c \ud655\uc778\ud558\uace0 \uad00\ub828\ub41c alert.log \ubc0f trace file \uc744 \uc624\ub77c\ud074 \uace0\uac1d\uc9c0\uc6d0\uc13c\ud130\ub85c \uc804\uc1a1\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574\uc11c \uc124\uba85\ud55c\ub2e4. IPS \uc0ac\uc6a9\ubc95 ORACLE 11g \ub294 problem (Database \uc5d0\uc11c \ubc1c\uc0dd\ud55c \uc5d0\ub7ec\ucf54\ub4dc)\uacfc […]<\/p>\n","protected":false},"author":1,"featured_media":2602,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[14],"tags":[52,54],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/ond0.jpg?fit=300%2C225","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2643"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2643"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2643\/revisions"}],"predecessor-version":[{"id":2653,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2643\/revisions\/2653"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2602"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2643"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2643"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2643"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nSQL> select * from atab;
\nselect * from atab
\n*
\nERROR at line 1:
\nORA-01578: ORACLE data block corrupted (file # 6, block # 11)
\nORA-01110: data file 6: ‘\/opt\/oracle\/oradata\/db11g\/tt.dbf’<\/p>\n
\nADR\uc5d0\uc11c \uc5d0\ub7ec\ub97c \ud655\uc778\ud558\uae30 \uc704\ud558\uc5ec 11g \ud658\uacbd\uc758 OS prompt\uc5d0\uc11c adrci\ub97c \uc2e4\ud589\ud55c\ub2e4.
\n*%] adrci*
\nADR \ud648 \uacbd\ub85c\ub97c \ud655\uc778\ud55c\ub2e4.
\nadrci> show home<\/strong>
\n–> \ubaa8\ub4e0 ADR HOME \uc744 \ubcf4\uc5ec\uc900\ub2e4. \ud655\uc778\ud558\uace0\uc790 \ud558\ub294 ADR HOME \uc744 \uc9c0\uc815\ud55c\ub2e4.
\nadrci> set homepath <ADR HOME><\/strong>
\n\uc5d0\ub7ec \ucf54\ub4dc\ub97c problem \uc774\ub77c\uace0 \ud558\uba70, \uc774\ub97c \ud655\uc778\ud558\uae30 \uc704\ud574\uc11c \ub2e4\uc74c\uc744 \uc2e4\ud589\ud55c\ub2e4.
\nadrci> show problem<\/strong>
\nADR Home = \/opt\/oracle\/diag\/rdbms\/db11g\/db11g:
\n*************************************************************************
\nPROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
\n– – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
\n1 ORA 1578 18104 2009-06-01 22:06:19.501207 +10:00
\n1 rows fetched
\nDatabase \uc5d0 \ubb38\uc81c\uac00 \ub418\uace0 \uc788\ub294 \uc5d0\ub7ec \ucf54\ub4dc\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.
\n\uc774 \uc911, \ubd84\uc11d\uc774 \ud544\uc694\ud55c \uc5d0\ub7ec\ucf54\ub4dc\uc5d0 \ub300\ud558\uc5ec \uc555\ucd95\ud30c\uc77c\uc744 \uc0dd\uc131\ud560 \uc218 \uc788\ub2e4.<\/p>\n
\n\uc5d0\ub7ec\uc758 \ubc1c\uc0dd \uae30\ub85d\ub4e4\uc740 Incident \ub77c\uace0 \ud558\uba70, \ubaa8\ub4e0 incident \ub294 Alert.log \uc5d0 \uae30\ub85d\ub41c\ub2e4.
\n\uac01\uac01\uc758 incident \ub294 \uc720\uc77c\ud55c incident ID \ub97c \uac00\uc9c4\ub2e4.
\nADR \uc5d0\uc11c ‘show incident’ \uba85\ub839\uc744 \uc218\ud589\ud558\uc5ec \uc5d0\ub7ec \ubc1c\uc0dd \uae30\ub85d\uc744 \ud655\uc778\ud560 \uc218\uac00 \uc788\uc73c\uba70,
\n\uc5d0\ub7ec\uc5d0 \ub300\ud55c problem key\ub97c \ud655\uc778\ud558\uae30 \uc704\ud574\uc11c\ub294 ‘show problem’ \uc744 \uc218\ud589\ud55c\ub2e4.
\nadrci> show incident -p “problem_key=’ORA 1578′”<\/strong>
\nADR Home = \/opt\/oracle\/diag\/rdbms\/db11g\/db11g:
\n*************************************************************************
\nINCIDENT_ID PROBLEM_KEY CREATE_TIME
\n– – – – – – – – – – – – – – – – – – – – – – – – – – – –
\n18147 ORA 1578 2009-06-01 22:02:08.805002 +10:00
\n\ub3d9\uc77c\ud55c problem\uc5d0 \ub300\ud55c incidnet\ub294 \uc5ec\ub7ec \uac74\uc774 \ubc1c\uc0dd\ud560 \uc218 \uc788\ub2e4.<\/p>\n
\n\uc555\ucd95 \ud30c\uc77c\uc744 \uc0dd\uc131\ud558\uae30 \uc704\ud574\uc11c\ub294 \ud2b9\uc815 \uacbd\ub85c\ub97c \ud3ec\ud568\ud55c ‘IPS pack’ \uba85\ub839\uc744 \uc0ac\uc6a9\ud55c\ub2e4.
\n\ub2e4\uc74c\uc758 \uc608\ub294 incident \uad00\ub828 file\ub4e4\uc744 \/tmp directory \uc5d0 \uc555\ucd95 \ud30c\uc77c\ub85c \uc0dd\uc131\ud558\ub294 \ubc29\ubc95\uc774\ub2e4.
\nadrci> ips pack incident 18147 in \/tmp<\/strong>
\nGenerated package 9 in file \/tmp\/ORA1578_20090602113045_COM_1.zip, mode complete
\nIPS pack \uc758 \uc608\uc81c)
\nips pack problem 100 in \/tmp<\/strong>
\n— problem id 100 \uc5d0 \uad00\ub828\ub41c trace file \ub4e4\uc744 \/tmp directory \uc5d0 \uc555\ucd95\ud30c\uc77c\ub85c \uc0dd\uc131\ud55c\ub2e4.
\nips pack incident 6439 in \/tmp<\/strong>
\n— incident id 6439 \uc5d0 \uad00\ub828\ub41c trace file \ub4e4\uc744 \/tmp directory \uc5d0 \uc555\ucd95\ud30c\uc77c\ub85c \uc0dd\uc131\ud55c\ub2e4.
\nips pack problemkey “ORA 1578”<\/strong>
\n— problem_key ‘ORA 1578’ \ub97c \uac00\uc9c0\ub294 \ubaa8\ub4e0 problem \uc5d0 \uad00\ub828\ub41c trace file \ub4e4\uc744 \ud604\uc7ac directory \uc5d0 \uc555\ucd95\ud30c\uc77c\ub85c \uc0dd\uc131\ud55c\ub2e4.
\nips pack seconds 8<\/strong>
\n— \ucd5c\uadfc 8 \ucd08 \uc774\ub0b4\uc5d0 \ubc1c\uc0dd\ud55c incident \uc5d0 \ub300\ud55c \uc555\ucd95 \ud30c\uc77c\uc744 \uc0dd\uc131\ud55c\ub2e4.
\nips pack time ‘2007-05-01 10:00:00.00’ to ‘2007-05-01 23:00:00.00’<\/strong>
\n— \ud2b9\uc815 \uc2dc\uac04\ub300\uc758 incident \uc5d0 \ub300\ud55c \uc555\ucd95\ud30c\uc77c\uc744 \uc0dd\uc131\ud55c\ub2e4.
\n‘IPS pack’ \uba85\ub839\uc740 ‘IPC create’ \uc640 ‘IPS generage’ \uba85\ub839\uc744 \uc77c\uad04\uc801\uc73c\ub85c \uc218\ud589\ud560 \uc218 \uc788\ub294 \uba85\ub839\uc774\ub2e4.
\n\uc774\uc640 \uac19\uc774 \uc0dd\uc131\ub41c \uc555\ucd95 \ud30c\uc77c\uc744 SR (service request)\uc744 \ud1b5\ud574 \uc624\ub77c\ud074 \uace0\uac1d\uc9c0\uc6d0\uc13c\ud130\ub85c \uc804\uc1a1\ud558\uba74 \ub41c\ub2e4.<\/p>\n
\nDOC ID : 443529.1 11g Quick Steps to Package and Send Critical Error Diagnostic Information to Support (Video)<\/p>\n