{"id":110,"date":"2017-04-03T16:55:04","date_gmt":"2017-04-03T07:55:04","guid":{"rendered":"https:\/\/dong1lkim.oboki.net\/?p=110"},"modified":"2019-09-01T22:21:58","modified_gmt":"2019-09-01T13:21:58","slug":"tibero-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ec%a3%bc%ec%9a%94-%ed%8c%8c%ec%9d%bc-rename","status":"publish","type":"post","link":"https:\/\/oboki.net\/workspace\/data-engineering\/database\/tibero\/tibero-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ec%a3%bc%ec%9a%94-%ed%8c%8c%ec%9d%bc-rename\/","title":{"rendered":"[Tibero] \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc8fc\uc694 \ud30c\uc77c RENAME"},"content":{"rendered":"

\uac1c\ubcc4 \ud30c\uc77c \ubcc0\uacbd<\/h2>\n

LOGFILE RENAME<\/h3>\n
    \n
  1. \ub85c\uadf8\ud30c\uc77c \uc870\ud68c
    \nselect member from v$logfile;<\/code><\/li>\n
  2. DB \uc885\ub8cc \ud6c4 \uae30\uc874 \ub85c\uadf8\ud30c\uc77c \uc774\ub3d9
    \ncp redo001_old.redo redo001_new.redo<\/code><\/li>\n
  3. mount \ubaa8\ub4dc \uae30\ub3d9 <\/li>\n
  4. RENAME
    \nalter database rename file 'redo001_old.redo' to 'redo001_new.redo';<\/code><\/li>\n<\/ol>\n

    DATAFILE RENAME<\/h3>\n
      \n
    1. \ub370\uc774\ud130\ud30c\uc77c \uc870\ud68c
      \nselect name from v$datafile;<\/code><\/li>\n
    2. DB \uc885\ub8cc \ud6c4 \uae30\uc874 \ub370\uc774\ud130\ud30c\uc77c \uc774\ub3d9
      \ncp usr001_old.dtf usr001_new.dtf<\/code><\/li>\n
    3. mount \ubaa8\ub4dc \uae30\ub3d9<\/li>\n
    4. RENAME
      \nalter database rename file 'usr001_old.dtf' to 'usr001_new.dtf';<\/code><\/li>\n<\/ol>\n

      DEFAULT TEMPORARY TABLESPACE<\/h3>\n
        \n
      1. TEMP TABLESPACE \uc0dd\uc131
        \ncreate temporary tablespace TEMP01 tempfile 'temp01.dtf' size 1024M autoextend off;<\/code><\/li>\n
      2. Default temp tablespace \uc9c0\uc815
        \nalter database default temporary tablespace TEMP01;<\/code><\/li>\n
      3. TEMP tablespace \uc7ac\uc0dd\uc131
        \n drop database TEMP including contents and datafiles;
        \n create temporary tablespace TEMP tempfile 'temp00.dtf' size 1024M autoextend off;<\/code><\/li>\n
      4. Default \uc9c0\uc815
        \n alter database default temporary tablespace TEMP;
        \n drop tablespace TEMP01 including contents and datafiles;<\/code><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

        \uac1c\ubcc4 \ud30c\uc77c \ubcc0\uacbd LOGFILE RENAME \ub85c\uadf8\ud30c\uc77c \uc870\ud68c select member from v$logfile; DB \uc885\ub8cc \ud6c4 \uae30\uc874 \ub85c\uadf8\ud30c\uc77c \uc774\ub3d9 cp redo001_old.redo redo001_new.redo mount \ubaa8\ub4dc \uae30\ub3d9 RENAME alter database rename file ‘redo001_old.redo’ to ‘redo001_new.redo’; DATAFILE RENAME \ub370\uc774\ud130\ud30c\uc77c \uc870\ud68c select name from v$datafile; DB \uc885\ub8cc \ud6c4 \uae30\uc874 \ub370\uc774\ud130\ud30c\uc77c \uc774\ub3d9 cp usr001_old.dtf usr001_new.dtf mount \ubaa8\ub4dc \uae30\ub3d9 RENAME alter database rename […]<\/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":[89,23,148],"class_list":["post-110","post","type-post","status-publish","format-standard","hentry","category-tibero","tag-database","tag-tibero","tag-148"],"_links":{"self":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/110","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=110"}],"version-history":[{"count":4,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/110\/revisions"}],"predecessor-version":[{"id":1318,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/110\/revisions\/1318"}],"wp:attachment":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/media?parent=110"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/categories?post=110"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/tags?post=110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}