{"id":3615,"date":"2018-03-19T10:00:47","date_gmt":"2018-03-19T01:00:47","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=3615"},"modified":"2018-03-19T10:00:47","modified_gmt":"2018-03-19T01:00:47","slug":"rollback-segment-%ea%b0%95%ec%a0%9c-drop-%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=3615","title":{"rendered":"Rollback segment \uac15\uc81c Drop \ud558\uae30"},"content":{"rendered":"

\uc5b4\ub5a4 session \uc774 rollback segment \ub97c \uc7a1\uace0 \ube44\uc815\uc0c1 \uc791\ub3d9 \uc2dc \ud574\ub2f9 rollback segment \ub97c \ucc3e\uc544 \uc774\ub97c drop \ud6c4 \uc7ac\uc0dd\uc131 \ud574\uc8fc\uc5b4\uc57c \ud55c\ub2e4.<\/p>\n

1. \ud574\ub2f9 session \uc774 \uc7a1\uace0 \uc788\uc5c8\ub358 rollback segment \ucc3e\uae30<\/p>\n

\uc774\ub54c rollback segment \ub97c offline \ud574\ub3c4 pending offline \uc0c1\ud0dc\ub85c \ube60\uc9c0\ubbc0\ub85c DB\uc758 \uc7ac\uae30\ub3d9\uc774 \ud544\uc694\ud558\ub2e4.<\/p>\n

DB \uc7ac\uae30\ub3d9 \ud6c4<\/p>\n

select * from v$rollstat;<\/p>\n

\uc744 \ubcf4\uba74 XACTS \uc758 \uc218\uac00 1\uc774\uc0c1\uc774\uba74\uc11c writes \uc218\uac00 0\uc778\uac83\uc774 \uc788\ub2e4.<\/p>\n

\uc774\ub294 session \uc774 \uc7a1\uace0 \uc788\uc73c\uba74\uc11c rollback \ud639\uc740 commit\uc744 \ud558\uc9c0 \ubabb\ud55c \uc0c1\ud0dc\uc774\ub2e4.<\/p>\n

\uc774\ub97c Offline Drop \ud558\uc5ec\uc57c \ud55c\ub2e4.<\/p>\n

select segment_name, writes,xacts from v$rollstat, dba_rollback_segs
\nwhere usn = segment_id;<\/p>\n

 <\/p>\n

 <\/p>\n

2. init \ud30c\uc77c \uc218\uc815 \ud6c4 drop \uc2dc\ud589<\/p>\n

rollback_segments = (rbs01,rbs02,rbs03,rbs05,rbs06)<\/p>\n

 <\/p>\n

# \ud574\ub2f9 rollback segment \uc0ad\uc81c
\n_offline_rollback_segments = (rbs04,rbs07)<\/p>\n

 <\/p>\n

# \uc0ad\uc81c\ud560 rollback segment \ub97c DB \uae30\ub3d9\uc2dc offline\uc73c\ub85c setting<\/p>\n

3. init \ud30c\uc77c \uc218\uc815 \ud6c4 DB \uc7ac\uae30\ub3d9 \ud558\uba74 \ud574\ub2f9 rollback segment \uac00 offline\uc73c\ub85c setting \ub418\uc5b4 \uc788\ub2e4.
\n\uc774\ub97c Drop \ud558\uace0 \uc7ac\uc0dd\uc131\ud55c\ub2e4.<\/p>\n

Drop rollback segment rbs04;
\nCreate rollback segment rbs04 tablespace RBS storage (\u2026\u2026);<\/p>\n

4. init \ud30c\uc77c\uc744 \uc6d0\uc0c1\ubcf5\uad6c\ud558\uace0 DB \uc7ac\uae30\ub3d9\uc744 \uc218\ud589\ud55c\ub2e4.<\/p>\n

 <\/p>\n

 <\/p>\n

* truncate table \uc2dc \ub3c4\uc911 cancel\ub85c \uc778\ud558\uc5ec \uc704\uc640 \uac19\uc740 \uc0c1\ud669 \ubc1c\uc0dd\uc2dc\ub294 \ud574\ub2f9 table\uc744 drop \ud574 \uc8fc\uc5b4\uc57c \ud55c\ub2e4.<\/p>\n

\uc774\ub54c trace file\uc744 \ubcf4\uba74 \ud574\ub2f9 table\uc774 \ub098\ud0c0\ub098\ubbc0\ub85c \uc774\ub97c \uba3c\uc800 drop \ud558\uace0 \uc704\uc758 \uc791\uc5c5\uc744 \uc218\ud589\ud574\uc57c \ud55c\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"

\uc5b4\ub5a4 session \uc774 rollback segment \ub97c \uc7a1\uace0 \ube44\uc815\uc0c1 \uc791\ub3d9 \uc2dc \ud574\ub2f9 rollback segment \ub97c \ucc3e\uc544 \uc774\ub97c drop \ud6c4 \uc7ac\uc0dd\uc131 \ud574\uc8fc\uc5b4\uc57c \ud55c\ub2e4. 1. \ud574\ub2f9 session \uc774 \uc7a1\uace0 \uc788\uc5c8\ub358 rollback segment \ucc3e\uae30 \uc774\ub54c rollback segment \ub97c offline \ud574\ub3c4 pending offline \uc0c1\ud0dc\ub85c \ube60\uc9c0\ubbc0\ub85c DB\uc758 \uc7ac\uae30\ub3d9\uc774 \ud544\uc694\ud558\ub2e4. DB \uc7ac\uae30\ub3d9 \ud6c4 select * from v$rollstat; \uc744 \ubcf4\uba74 XACTS \uc758 \uc218\uac00 […]<\/p>\n","protected":false},"author":1,"featured_media":2875,"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":[1034,1033,49,186,1035,1032,1031],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/1-know-how.jpg?fit=937%2C450","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3615"}],"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=3615"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3615\/revisions"}],"predecessor-version":[{"id":3617,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3615\/revisions\/3617"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2875"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3615"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3615"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3615"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}