{"id":1087,"date":"2019-06-14T21:56:51","date_gmt":"2019-06-14T12:56:51","guid":{"rendered":"https:\/\/oboki.net\/workspace\/?p=1087"},"modified":"2019-09-01T22:19:51","modified_gmt":"2019-09-01T13:19:51","slug":"_tx_recovery_suspend","status":"publish","type":"post","link":"https:\/\/oboki.net\/workspace\/data-engineering\/database\/tibero\/_tx_recovery_suspend\/","title":{"rendered":"[Tibero] _TX_RECOVERY_SUSPEND=Y"},"content":{"rendered":"

_TX_RECOVERY_SUSPEND=Y<\/h1>\n

\ub300\uc6a9\ub7c9 \ud2b8\ub79c\uc7ad\uc158 \uc218\ud589 \uc911 DB\uac00 \uc885\ub8cc\ub418\uc5c8\uc744 \ub54c, \ubcf5\uad6c \ub300\uc0c1\uc778 \ud2b8\ub79c\uc7ad\uc158\ub4e4\uc744 undo segment\uc5d0\uc11c \ubaa8\ub450 \ucc3e\uc544 \ud574\ub2f9 object\uc5d0 \ubc18\uc601\ud574\uc8fc\ub294 \uc791\uc5c5\uc744 \uc218\ud589\ud558\uac8c \ub41c\ub2e4. \ub300\uc6a9\ub7c9 insert \ub610\ub294 update \ub3c4\uc911 DB\uac00 \uc885\ub8cc\ub41c \uacbd\uc6b0 \ubaa8\ub450 rollback \ucc98\ub9ac\uac00 \uc120\ud589\ub418\uba70 \uc774 \uacfc\uc815\uc5d0\uc11c \ud574\ub2f9 object\uc5d0 \ub300\ud55c \uc544\ubb34\ub7f0 \uc791\uc5c5\uc744 \ud560 \uc218 \uc5c6\uace0 \ubaa8\ub4e0 DDL\uc774 \uc218\ud589\ub418\uc9c0 \uc54a\ub294 \uc0c1\ud0dc\uac00 \ub418\ub294\ub370 \uc774\ub7f0 \uacbd\uc6b0 _TX_RECOVERY_SUSPEND<\/code> \ud30c\ub77c\ubbf8\ud130\ub97c \uc801\uc6a9\ud574\ubcfc \uc218 \uc788\ub2e4.<\/p>\n

\uc774 \ubc29\ubc95\uc744 \uc0ac\uc6a9\ud55c \uacbd\uc6b0 \ud574\ub2f9 \uc624\ube0c\uc81d\ud2b8\uc5d0 \ub300\ud55c \uc815\ud569\uc131\uc744 \ubcf4\uc7a5\ud560 \uc218 \uc5c6\uc73c\ubbc0\ub85c, \uae54\ub054\ud558\uac8c \uc81c\uac70\ud574\uc8fc\ub294 \uac83\uc774 \uc88b\uace0 \ub2f9\uc5f0\ud788 \uc6b4\uc601 \ub370\uc774\ud130\uac00 \uc544\ub2cc, \uac1c\ubc1c \uacfc\uc815\uc5d0\uc11c \uc7ac\uc0dd\uc131\uc774 \uac00\ub2a5\ud55c \ub370\uc774\ud130\uc758 \uacbd\uc6b0\uc5d0\ub9cc \uc801\uc6a9\ud574\uc57c\ud55c\ub2e4.<\/p>\n

    \n
  1. $TB_SID.tip<\/code> \ud30c\uc77c\uc5d0 \ub2e4\uc74c \ud30c\ub77c\ubbf8\ud130 \ucd94\uac00 \ud6c4 DB \uc7ac\uae30\ub3d9<\/li>\n<\/ol>\n

    vi $TB_HOME\/config\/$TB_SID.tip<\/code><\/p>\n

    _TX_RECOVERY_SUSPEND=Y<\/code><\/pre>\n
    tbboot<\/code><\/p>\n
      \n
    1. sys \uacc4\uc815\uc73c\ub85c \uc811\uc18d\ud558\uc5ec \ub2e4\uc74c SQL \uc218\ud589 \uacb0\uacfc \ud655\uc778<\/li>\n<\/ol>\n
      SELECT * FROM V$CORRUPT_XID;<\/code><\/pre>\n
        \n
      1. TX \uac15\uc81c \ucee4\ubc0b<\/li>\n<\/ol>\n
        COMMIT FORCE CORRUPT_XID_ALL;<\/code><\/pre>\n
          \n
        1. \ntx \ub300\uc0c1 \uc624\ube0c\uc81d\ud2b8\ub97c drop, truncate ddl\ub85c \uc815\ub9ac\n<\/li>\n
        2. \n\ud301\ud30c\uc77c \ud30c\ub9ac\ubbf8\ud130 \uc81c\uac70 \ud6c4 \uc7ac\uae30\ub3d9\n<\/li>\n<\/ol>\n
          tbdown;tbboot<\/code><\/p>\n
          \uc704 \ubc29\ubc95\uc740 \uae34\uae09 \uc0c1\ud669\uc5d0 \uace0\ub824\ud574\ubcfc \uc218 \uc788\uaca0\uc9c0\ub9cc \uae30\ubcf8\uc801\uc73c\ub85c\ub294 \ud574\ub2f9 \ud2b8\ub79c\uc7ad\uc158 \ubc1c\uc0dd \uc804\uae4c\uc9c0 \uc544\uce74\uc774\ube0c \ub85c\uadf8\ub97c \ud1b5\ud574 \ubcf5\uad6c\ud558\ub294 Media Recovery \ub97c \uc218\ud589\ud558\ub294 \uac83\uc774 \uc88b\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"
          _TX_RECOVERY_SUSPEND=Y \ub300\uc6a9\ub7c9 \ud2b8\ub79c\uc7ad\uc158 \uc218\ud589 \uc911 DB\uac00 \uc885\ub8cc\ub418\uc5c8\uc744 \ub54c, \ubcf5\uad6c \ub300\uc0c1\uc778 \ud2b8\ub79c\uc7ad\uc158\ub4e4\uc744 undo segment\uc5d0\uc11c \ubaa8\ub450 \ucc3e\uc544 \ud574\ub2f9 object\uc5d0 \ubc18\uc601\ud574\uc8fc\ub294 \uc791\uc5c5\uc744 \uc218\ud589\ud558\uac8c \ub41c\ub2e4. \ub300\uc6a9\ub7c9 insert \ub610\ub294 update \ub3c4\uc911 DB\uac00 \uc885\ub8cc\ub41c \uacbd\uc6b0 \ubaa8\ub450 rollback \ucc98\ub9ac\uac00 \uc120\ud589\ub418\uba70 \uc774 \uacfc\uc815\uc5d0\uc11c \ud574\ub2f9 object\uc5d0 \ub300\ud55c \uc544\ubb34\ub7f0 \uc791\uc5c5\uc744 \ud560 \uc218 \uc5c6\uace0 \ubaa8\ub4e0 DDL\uc774 \uc218\ud589\ub418\uc9c0 \uc54a\ub294 \uc0c1\ud0dc\uac00 \ub418\ub294\ub370 \uc774\ub7f0 \uacbd\uc6b0 _TX_RECOVERY_SUSPEND \ud30c\ub77c\ubbf8\ud130\ub97c \uc801\uc6a9\ud574\ubcfc \uc218 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-1087","post","type-post","status-publish","format-standard","hentry","category-tibero"],"_links":{"self":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/1087","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/comments?post=1087"}],"version-history":[{"count":5,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/1087\/revisions"}],"predecessor-version":[{"id":1163,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/1087\/revisions\/1163"}],"wp:attachment":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/media?parent=1087"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/categories?post=1087"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/tags?post=1087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}