{"id":430,"date":"2015-09-03T01:22:55","date_gmt":"2015-09-03T01:22:55","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=430"},"modified":"2015-09-03T01:22:55","modified_gmt":"2015-09-03T01:22:55","slug":"data-block%ec%9d%b4%eb%82%98-index-block%ec%9d%b4-corrupt-%eb%82%9c-%ea%b2%bd%ec%9a%b0","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=430","title":{"rendered":"Data block\uc774\ub098 Index block\uc774 corrupt \ub09c \uacbd\uc6b0"},"content":{"rendered":"

\uc774 \ubc29\ubc95\uc740 \ubc31\uc5c5\uc73c\ub85c \ubcf5\uad6c\uac00 \ubd88\uac00\ub2a5 \ud560\uacbd\uc6b0 \ucd5c\ub300\ud55c \ub9c8\uc9c0\ub9c9 \ubc29\ubc95 \uc785\ub2c8\ub2e4. \uc624\ub77c\ud074 \uad8c\uace0 \uc0ac\ud56d\uc740 \uc808\ub300 \uc544\ub2d9\ub2c8\ub2e4. <\/font><\/p>\n


<\/span><\/p>\n

Data block<\/span>\uc774\ub098<\/span> Index block<\/span>\uc774<\/span> corruption<\/span>\uc73c\ub85c<\/span> <\/span>\uc778\ud574<\/span> startup<\/span>\uc774<\/span> <\/span>\ub418\uc9c0<\/span>
\n<\/span>\uc54a\uac70\ub098<\/span> <\/span>\uc5b4\ub5a4<\/span> object<\/span>\ub97c<\/span> select<\/span>\ubabb\ud560<\/span> <\/span>\uacbd\uc6b0\uc5d0<\/span> <\/span>\ub2e4\uc74c\uacfc<\/span>
\n<\/span>\uac19\uc740<\/span> event<\/span>\ub97c<\/span> <\/span>\uc0ac\uc6a9 \ud569\ub2c8\ub2e4.<\/span><\/p>\n

 <\/span><\/p>\n\n\n\n

\n <\/span><\/p>\n

10210
\n :<\/span><\/b> Check Data block integrity<\/span><\/span><\/p>\n


\n <\/span><\/p>\n

  <\/span>\uc774<\/span> event<\/span>\ub97c<\/span> <\/span>\uc9c0\uc815\ud558\uba74<\/span> kernel<\/span>\uc774<\/span> <\/span>\uac15\uc81c\uc801\uc73c\ub85c<\/span> data block<\/span>\uc5d0<\/span> <\/span>\ub300\ud55c<\/span> integrity check<\/span>\ub97c<\/span> <\/span>\ud558\ub3c4\ub85d<\/span> <\/span>\ud55c\ub2e4<\/span>. <\/span>\uc774<\/span> event<\/span>\ub97c<\/span> <\/span>\uc9c0\uc815\ud558\uba74<\/span> data
\n block<\/span>\uc774<\/span> Disk<\/span>\uc5d0\uc11c<\/span> Cache<\/span>\ub85c<\/span> <\/span>\uc77d\ud600\uc9c8<\/span> <\/span>\ub54c<\/span> check<\/span>\ub97c<\/span> <\/span>\ud55c\ub2e4<\/span>. <\/span>\ub9cc\uc57d<\/span> corrupt<\/span>\uac00<\/span> <\/span>\ubc1c\uc0dd<\/span> <\/span>\ud588\ub2e4\uba74<\/span>, ORA-600 error<\/span>\ub97c<\/span>
\n <\/span>\ubc1c\uc0dd<\/span> <\/span>\uc2dc\ud0a4\uace0<\/span>, <\/span>\ud574\ub2f9<\/span> block<\/span>\uc5d0<\/span> corrupted
\n block<\/span>\uc774\ub77c\ub294<\/span> mark<\/span>\ub97c<\/span> <\/span>\ud55c\ub2e4<\/span>(sequence number<\/span>\ub97c<\/span> 0).<\/span>  <\/span><\/span>\uc774<\/span> event<\/span>\ub97c<\/span> <\/span>\uc9c0\uc815\ud558\uba74<\/span>
\n performance<\/span>\uc758<\/span> 5~10%<\/span>\uac00<\/span> <\/span>\uac10\uc18c<\/span>  <\/span>\ub41c\ub2e4<\/span>. <\/span><\/span><\/p>\n


\n <\/span><\/p>\n

10211
\n :<\/span><\/b> Check Index block integrity<\/span><\/span><\/p>\n


\n <\/span><\/p>\n

  <\/span>\uc774<\/span> event<\/span>\ub294<\/span> index block<\/span>\uc5d0<\/span>
\n <\/span>\ub300\ud55c<\/span> integrity
\n check<\/span>\ub97c<\/span> <\/span>\ud558\ub3c4\ub85d<\/span> <\/span>\ud55c\ub2e4<\/span>. <\/span><\/span><\/p>\n


\n <\/span><\/p>\n

10231
\n :<\/span><\/b> Skip corrupted block on << table scan
\n >><\/span><\/span><\/p>\n


\n <\/span><\/p>\n

  <\/span>\uc774<\/span> event<\/span>\ub97c<\/span> <\/span>\uc9c0\uc815\ud558\uba74<\/span> scan<\/span>\uc2dc<\/span> corrupted
\n block<\/span>\uc744<\/span> skip<\/span>\ud55c\ub2e4<\/span>. <\/span>\uadf8\ub9ac\uace0<\/span> trace
\n file<\/span>\uc744<\/span> <\/span>\uc0dd\uc131\ud55c\ub2e4<\/span>. <\/span><\/span><\/p>\n


\n <\/span><\/p>\n

10232
\n :<\/span><\/b> Dump corrupted blocks symbolically gotten by
\n <<kcbget>><\/span><\/span><\/p>\n


\n <\/span><\/p>\n

  <\/span>Corrupted Block<\/span><\/span>\uc5d0<\/span> <\/span>\ub300\ud55c<\/span> <\/span>\uc815\ubcf4\ub97c<\/span> Dump<\/span>\ud55c\ub2e4<\/span>.<\/span><\/span><\/p>\n


\n <\/span><\/p>\n

 <\/span><\/p>\n


\n <\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/span><\/p>\n

Block corrupt<\/span>\uc758<\/span>
\n<\/span>\ub300\ud45c\uc801\uc778<\/span> error<\/span>\ub294<\/span>
\nORA-00600[3398], ORA-00600[4519], ORA-00600[3339]<\/span>\uc774\ub2e4<\/span>.<\/span>  <\/span><\/span>\ub9cc\uc57d<\/span>
\nORA-00600[3398]<\/span>\uc774<\/span> <\/span>\ubc1c\uc0dd<\/span> <\/span>\ud588\ub2e4\uace0<\/span>
\n<\/span>\uac00\uc815\ud558\uba74<\/span><\/p>\n

\uc6b0\uc120<\/span> init.ora<\/span>\uc5d0<\/span> <\/span>\uc544\ub798\uc758<\/span> event<\/span>\ub97c<\/span> <\/span>\uc9c0\uc815\ud569\ub2c8\ub2e4.<\/span><\/p>\n


<\/span><\/p>\n

  <\/span>event=”10210 trace name context forever,
\nlevel 10″<\/span><\/span><\/p>\n

  <\/span>event=”10211 trace name context forever,
\nlevel 10″<\/span><\/span><\/p>\n


<\/span><\/span><\/p>\n

 <\/span>\uc774\ud6c4<\/span> database<\/span>\ub97c<\/span> startup<\/span>\ud55c<\/span> <\/span>\ud6c4\uc5d0<\/span> trace<\/span>\uac00<\/span> <\/span>\ubc1c\uc0dd\ud558\uba74<\/span> <\/span>\uc5b4\ub5a4<\/span> object<\/span>\uac00<\/span> error<\/span>\uc778\uc9c0\ub97c<\/span> <\/span>\ud30c\uc545\ud560<\/span> <\/span>\uc218<\/span>
\n<\/span>\uc788\uc2b5\ub2c8\ub2e4<\/span>. <\/span>\ub9cc\uc57d<\/span> table<\/span>\uc774<\/span> error<\/span>\uc77c<\/span> <\/span>\uacbd\uc6b0\uc5d0\ub294<\/span> <\/span><\/span><\/p>\n


<\/span><\/p>\n

                  <\/span>event=”10231
\ntrace name context forever, level 10″<\/span><\/span><\/p>\n


<\/span><\/span><\/p>\n

\uc744<\/span> <\/span>\uc9c0\uc815\ud558\uace0<\/span> <\/span>\ud574\ub2f9<\/span> table<\/span>\uc744<\/span> export<\/span>\ubc1b\uc740<\/span> <\/span>\ud6c4\uc5d0<\/span> drop<\/span>\uc744<\/span> <\/span>\ud558\uace0<\/span>
\n<\/span>\ub2e4\uc2dc<\/span> import<\/span>\ud558\uba74<\/span> \ub429\ub2c8\ub2e4.<\/span><\/p>\n


<\/span><\/span><\/p>\n

<\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

\ub9cc\uc57d<\/span> index<\/span>\uc77c<\/span> <\/span>\uacbd\uc6b0\uc5d0\ub294<\/span> <\/span>\ud574\ub2f9<\/span> index<\/span>\ub97c<\/span> drop<\/span>\ud55c<\/span> <\/span>\ud6c4\uc5d0<\/span> <\/span>\uc7ac\uc0dd\uc131<\/span>
\n<\/span>\ud558\uba74<\/span> \ub429\ub2c8\ub2e4.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

\uc774 \ubc29\ubc95\uc740 \ubc31\uc5c5\uc73c\ub85c \ubcf5\uad6c\uac00 \ubd88\uac00\ub2a5 \ud560\uacbd\uc6b0 \ucd5c\ub300\ud55c \ub9c8\uc9c0\ub9c9 \ubc29\ubc95 \uc785\ub2c8\ub2e4. \uc624\ub77c\ud074 \uad8c\uace0 \uc0ac\ud56d\uc740 \uc808\ub300 \uc544\ub2d9\ub2c8\ub2e4.  Data block\uc774\ub098 Index block\uc774 corruption\uc73c\ub85c \uc778\ud574 startup\uc774 \ub418\uc9c0 \uc54a\uac70\ub098 \uc5b4\ub5a4 object\ub97c select\ubabb\ud560 \uacbd\uc6b0\uc5d0 \ub2e4\uc74c\uacfc \uac19\uc740 event\ub97c \uc0ac\uc6a9 \ud569\ub2c8\ub2e4.  <\/p>\n","protected":false},"author":1,"featured_media":0,"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":[192],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/430"}],"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=430"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/430\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=430"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=430"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=430"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}