{"id":427,"date":"2015-09-03T00:21:23","date_gmt":"2015-09-03T00:21:23","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=427"},"modified":"2015-09-03T00:21:23","modified_gmt":"2015-09-03T00:21:23","slug":"rollback-segment-corrupt-error-message%ea%b0%80-%eb%b0%9c%ec%83%9d-%ed%96%88%ec%9d%84-%ea%b2%bd%ec%9a%b0%ec%97%90","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=427","title":{"rendered":"Rollback segment corrupt error message\uac00 \ubc1c\uc0dd \ud588\uc744 \uacbd\uc6b0\uc5d0"},"content":{"rendered":"

Rollback segment corrupt error message<\/span>\uac00<\/span> <\/span>\ubc1c\uc0dd<\/span>
\n<\/span>\ud588\uc744<\/span> <\/span>\uacbd\uc6b0\uc5d0<\/span>
\n<\/span>\uc6b0\uc120<\/span> rollback
\nsegment<\/span>\uc5d0<\/span> <\/span>\ub300\ud55c<\/span>
\n<\/span>\uc815\ubcf4\ub97c<\/span> <\/span>\uc54c\uc544\uc57c<\/span>
\n<\/span>\ud55c\ub2e4<\/span>. <\/span>\uc989<\/span>, <\/span>\uc5b4\ub5a4<\/span> rollback
\nsegment<\/span>\uc5d0<\/span> <\/span>\ubb38\uc81c\uac00<\/span>
\n<\/span>\ubc1c\uc0dd<\/span> <\/span>\ud588\ub294\uc9c0\ub97c<\/span>
\n<\/span>\uc54c\uae30<\/span> <\/span>\uc704\ud574<\/span>
\n<\/span>\uc544\ub798\uc758<\/span> event<\/span>\ub97c<\/span> <\/span>\uc0ac\uc6a9\ud55c\ub2e4<\/span>.<\/span><\/span><\/p>\n

  <\/span>Init.ora<\/span><\/span><\/p>\n

  <\/span>event=”<\/span>10013<\/span><\/b> trace name context forever, level 10\u201d <\/span><\/span><\/p>\n

  <\/span>(Dumps the recovery of transactions during
\nstartup)<\/span><\/span><\/p>\n

  <\/span>event=\u201d<\/span>10015<\/span><\/b>
\ntrace name context forever, level 10\u201d <\/span><\/span><\/p>\n

  <\/span>(Dumps every rollback segment header,
\ntransaction table, during startup, before, after recovery)<\/span><\/span><\/p>\n

\uc704\uc758<\/span> event<\/span>\ub97c<\/span> init.ora<\/span>\uc5d0<\/span> <\/span>\uc9c0\uc815\ud55c<\/span> <\/span>\ud6c4\uc5d0<\/span>
\n<\/span>\ub2e4\uc2dc<\/span> startup<\/span>\ud55c\ub2e4<\/span>. <\/span>\uc774\ub54c<\/span> <\/span>\ub098\uc628<\/span> trace file<\/span>\uc744<\/span> <\/span>\uc774\uc6a9\ud558\uc5ec<\/span> <\/span>\ud574\ub2f9<\/span> object<\/span>\ub97c<\/span> <\/span>\uc54c\uc544\ub0b8\ub2e4<\/span>.<\/span><\/span><\/p>\n


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

                  <\/span>Tx(#,#):
\ntransaction information<\/span><\/span><\/p>\n

                  <\/span>object#:
\nobject id<\/span><\/span><\/p>\n


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

\uacbd\uc6b0<\/span> 1<\/span><\/b>: corrupt<\/span>\ub41c<\/span> object<\/span>\uac00<\/span> rollback segment<\/span>\uc77c<\/span>
\n<\/span>\uacbd\uc6b0<\/span>.(media
\nrecovery<\/span>\ub97c<\/span> <\/span>\ud558\uc9c0<\/span>
\n<\/span>\ubabb\ud560<\/span> <\/span>\uacbd\uc6b0<\/span>)<\/span><\/span><\/p>\n

\ud574\ub2f9<\/span> segment<\/span>\ub97c<\/span> init.ora<\/span>\uc758<\/span> rollback_segments<\/span>\uc5d0\uc11c<\/span>
\n<\/span>\uc81c\uc678\ud558\uace0 <\/span>_corrunted_rollback_segment<\/span>\uc5d0<\/span> <\/span>\uc9c0\uc815\ud55c<\/span>
\n<\/span>\ud6c4<\/span> <\/span>\ub2e4\uc2dc<\/span>
\n<\/span>\uc2dc\ub3c4<\/span> <\/span>\ud55c\ub2e4<\/span>.<\/span><\/span><\/p>\n

\uc774\ud6c4\uc5d0<\/span>
\n<\/span>\uc774\ub97c<\/span> drop<\/span>\ud55c\ub2e4<\/span>. <\/span>\uadf8\ub9ac\uace0<\/span>, database<\/span>\ub97c<\/span> backup<\/span>\ubc1b\uace0<\/span>, rebuild<\/span>\ud55c\ub2e4<\/span>. <\/span><\/span><\/p>\n

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

\uacbd\uc6b0<\/span> 2<\/span><\/b>: <\/span>\uc77c\ubc18<\/span> data block<\/span>\uc774<\/span> corrupt<\/span>\ub418\uc5c8\uc744<\/span> <\/span>\uacbd\uc6b0<\/span>.(media
\nrecovery<\/span>\ub97c<\/span> <\/span>\ud558\uc9c0<\/span>
\n<\/span>\ubabb\ud560<\/span> <\/span>\uacbd\uc6b0<\/span>)<\/span><\/span><\/p>\n

\ud574\ub2f9<\/span> object<\/span>\uc640<\/span> <\/span>\uad00\ub828\ud55c<\/span> rollback
\nsegment<\/span>\ub97c<\/span> init.ora<\/span>\uc5d0<\/span>
\n_offline_rollback_segment<\/span>\uc5d0<\/span>
\n<\/span>\uc9c0\uc815\ud55c<\/span> <\/span>\ud6c4<\/span> startup<\/span>\ud558\uace0<\/span> <\/span>\ud574\ub2f9<\/span> object<\/span>\ub97c<\/span> drop <\/span>\ud55c\ub2e4<\/span>. (object<\/span>\uc744<\/span> drop<\/span>\ud558\uba74<\/span> undo<\/span>\ub294<\/span> discard<\/span>\ub41c\ub2e4<\/span>.)<\/span><\/span><\/p>\n

_offline<\/span>\uc5c6\uc774<\/span> startup<\/span>\ud55c\ub2e4<\/span>.<\/span> <\/span>\ud574\ub2f9<\/span> object<\/span>\ub97c<\/span> rebuild<\/span>\ud55c\ub2e4<\/span>.<\/span><\/span><\/p>\n

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

_offline_rollback_segments<\/span><\/b> : <\/span>\uc784\uc758\uc758<\/span> tx<\/span>\uc5d0<\/span> <\/span>\ub300\ud55c<\/span> ITL<\/span>\uc774<\/span> rollback
\nsegment<\/span>\uc640<\/span> <\/span>\uc5f0\uad00\ub418\uc5b4<\/span>
\n<\/span>\uc788\uc744<\/span> <\/span>\uacbd\uc6b0\uc5d0<\/span>
\n<\/span>\uc774<\/span> rollback
\nsegment<\/span>\uac00<\/span> _offline<\/span>\uc5d0<\/span> <\/span>\uc9c0\uc815\ub418\uc5b4<\/span>
\n<\/span>\uc788\uc73c\uba74<\/span>,<\/span>  <\/span><\/span>\ud574\ub2f9<\/span> segment<\/span>\ub294<\/span> transaction<\/span>\uc758<\/span> <\/span>\uc0c1\ud0dc\ub97c<\/span> <\/span>\ucc3e\ub294\ub2e4<\/span>. <\/span>\uc774\ub54c<\/span> tx<\/span>\uc774<\/span> committed<\/span>\ub418\uc5c8\uc73c\uba74<\/span> delayed clean out<\/span>\ub97c<\/span>
\n<\/span>\uc218\ud589\ud558\uace0<\/span>, <\/span>\ud604\uc7ac<\/span> active<\/span>\ud558\uba74<\/span> ITL<\/span>\uc5d0<\/span> <\/span>\ud574\ub2f9\ud558\ub294<\/span> consistent read<\/span>\ub97c<\/span>
\n<\/span>\uc218\ud589\ud55c\ub2e4<\/span>. <\/span>\ub9cc\uc57d<\/span> <\/span>\ud574\ub2f9<\/span> tx<\/span>\uac00<\/span> active<\/span>\ud558\uace0<\/span> <\/span>\uc774<\/span> ITL<\/span>\uc744<\/span> <\/span>\ubcc0\uacbd\ud558\uace0\uc790<\/span>
\n<\/span>\ud560<\/span> <\/span>\uacbd\uc6b0\uc5d0\ub294<\/span>
\n<\/span>\ubb34\ud55c<\/span> <\/span>\ub8e8\ud504\uc5d0<\/span>
\n<\/span>\ube60\uc838<\/span> <\/span>\ub4e4\uac8c<\/span>
\n<\/span>\ub41c\ub2e4<\/span>. <\/span>\ub610\ud55c<\/span> <\/span>\uc774<\/span> segment<\/span>\ub97c<\/span> drop<\/span>\ud558\uba74<\/span> <\/span>\ubaa8\ub4e0<\/span> tx<\/span>\ub294<\/span> commit<\/span>\ub41c\ub2e4<\/span>.<\/span><\/span><\/p>\n

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

_corrupted_rollback_segment<\/span><\/b> : <\/span>\ub9cc\uc57d<\/span> ITL<\/span>\uc744<\/span> open<\/span>\ud560<\/span> <\/span>\ub54c<\/span> <\/span>\uc774\uc5d0<\/span>
\n<\/span>\uc5f0\uad00\ub41c<\/span> segment<\/span>\uac00<\/span> _corrupted<\/span>\uc5d0<\/span> <\/span>\uc9c0\uc815\ub418\uc5b4<\/span>
\n<\/span>\uc788\uc73c\uba74<\/span>, <\/span>\ud574\ub2f9<\/span> ITL<\/span>\uc758<\/span> transaction<\/span>\uc758<\/span> <\/span>\uc0c1\ud0dc\ub97c<\/span>
\n<\/span>\uc54c\uae30<\/span> <\/span>\uc704\ud574\uc11c<\/span> segment<\/span>\ub97c<\/span> read<\/span>\ud558\uc9c0<\/span> <\/span>\uc54a\uace0<\/span>, <\/span>\ud574\ub2f9<\/span> transaction<\/span>\uc774<\/span> commit<\/span>\ub418\uc5c8\ub2e4\uace0<\/span> <\/span>\uac00\uc815\ud558\uace0<\/span>, delayed block clean out<\/span>\uc744<\/span>
\n<\/span>\uc218\ud589\ud55c\ub2e4<\/span>. <\/span>\uadf8\ub7ec\ubbc0\ub85c<\/span> logical
\ncorruption<\/span>\uc774<\/span> <\/span>\ubc1c\uc0dd<\/span> <\/span>\ud560<\/span>
\n<\/span>\uc218<\/span> <\/span>\uc788\ub2e4<\/span>. <\/span>\uadf8\ub7ec\ubbc0\ub85c<\/span> <\/span>\uc774\ub7ec\ud55c<\/span> <\/span>\uacbd\uc6b0\uc5d0\ub294<\/span> logical corruption<\/span>\uc774<\/span>
\n<\/span>\ubc1c\uc0dd<\/span> <\/span>\ud55c\ub2e4<\/span>.<\/span><\/span><\/p>\n

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

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

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


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

  <\/span>1<\/span> 
\n <\/span>SQL> set transaction use rollback segment r01<\/span><\/span><\/p>\n


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

      <\/span>Transaction set.<\/span><\/span><\/p>\n


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

     <\/span>SQL> insert into emp (empno ) values
\n (1111);<\/span><\/span><\/p>\n


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

      <\/span>1 row created.<\/span><\/span><\/p>\n


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

2<\/span>  <\/span><\/span>\ub2e4\ub978<\/span> session<\/span>\uc5d0\uc11c<\/span> shutdown
\n abort<\/span><\/span><\/p>\n


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

3.
\n <\/span>       
\n <\/span><\/span>init.ora<\/span>\uc5d0<\/span>
\n _offline_rollback_segment=(r01)<\/span>\ub85c<\/span>
\n <\/span>\uc9c0\uc815<\/span><\/span><\/p>\n


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

4.
\n <\/span>       
\n <\/span><\/span>startup.<\/span><\/span><\/p>\n


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

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


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

* <\/span>\uc774\ub54c<\/span> <\/span>\ub9cc\uc57d<\/span> _offline<\/span>\uc73c\ub85c<\/span> <\/span>\uc9c0\uc815\ud558\uba74<\/span> empno<\/span>\ub294<\/span> rollback<\/span>\uc774<\/span> <\/span>\ub418\uace0<\/span> _corrupted<\/span>\ub85c<\/span> <\/span>\uc9c0\uc815\ud558\uba74<\/span> <\/span>\uc0c8\ub85c<\/span>
\n <\/span>\uc785\ub825\ud55c<\/span> 1111<\/span>\uc774<\/span> <\/span>\ub41c\ub2e4<\/span>. <\/span>\uc989<\/span> _offline<\/span>\uacfc<\/span> _corrupted<\/span>\uc758<\/span> <\/span>\ucc28\uc774\ub294<\/span> <\/span>\ubd84\uba85\ud558\ub2e4<\/span>.<\/span><\/span><\/p>\n


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

\ub610\ud55c<\/span>
\n <\/span>\ud604\uc7ac<\/span> active<\/span>\ud55c<\/span> tx<\/span>\uac00<\/span> <\/span>\uc788\ub354\ub77c\ub3c4<\/span> <\/span>\uc704\uc758<\/span> _offline, _corrupted<\/span>\ub97c<\/span>
\n <\/span>\uc0ac\uc6a9\ud558\uba74<\/span> tx<\/span>\uc5d0<\/span> <\/span>\ub300\ud55c<\/span> check<\/span>\uc5c6\uc774<\/span> drop<\/span>\ud560<\/span> <\/span>\uc218<\/span> <\/span>\uc788\ub2e4<\/span>. <\/span><\/span><\/p>\n


\n <\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\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

<\/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

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

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

 <\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Rollback segment corrupt error message\uac00 \ubc1c\uc0dd \ud588\uc744 \uacbd\uc6b0\uc5d0 \uc6b0\uc120 rollback segment\uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c \uc54c\uc544\uc57c \ud55c\ub2e4. \uc989, \uc5b4\ub5a4 rollback segment\uc5d0 \ubb38\uc81c\uac00 \ubc1c\uc0dd \ud588\ub294\uc9c0\ub97c \uc54c\uae30 \uc704\ud574 \uc544\ub798\uc758 event\ub97c \uc0ac\uc6a9\ud55c\ub2e4.   Init.ora   event=”10013 trace name context forever, level 10\u201d    (Dumps the recovery of transactions during startup)   event=\u201d10015 trace name context forever, level 10\u201d    (Dumps […]<\/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":[49,186,187],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/427"}],"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=427"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/427\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=427"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=427"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=427"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}