{"id":112,"date":"2017-04-03T16:59:36","date_gmt":"2017-04-03T07:59:36","guid":{"rendered":"https:\/\/dong1lkim.oboki.net\/?p=112"},"modified":"2019-09-01T22:21:58","modified_gmt":"2019-09-01T13:21:58","slug":"tibero-redo-logfile-%ea%b4%80%eb%a6%ac","status":"publish","type":"post","link":"https:\/\/oboki.net\/workspace\/data-engineering\/database\/tibero\/tibero-redo-logfile-%ea%b4%80%eb%a6%ac\/","title":{"rendered":"[Tibero] REDO Logfile \uad00\ub9ac"},"content":{"rendered":"

logfile \uc0ac\uc774\uc988 \ubcc0\uacbd<\/h2>\n

logfile \uc0c1\ud0dc \ud655\uc778<\/h3>\n
select l.group#, l.status, l.bytes, lf.member , l.first_time\nfrom v$log l, v$logfile lf\nwhere l.group# = lf.group#\n<\/code><\/pre>\n
Inactive \ud30c\uc77c \uc0ad\uc81c<\/h3>\n
alter database drop logfile group 1;\n--\uc2e4\uc81c \ub370\uc774\ud130\ud30c\uc77c \uc0ad\uc81c \ud544\uc694\n<\/code><\/pre>\n
logfile \ucd94\uac00<\/h3>\n
alter database add logfile group 1 ( '\/tbdata\/redo011.redo','\/tbdata\/redo012.redo');\n<\/code><\/pre>\n
redo log \uad00\ub828 view<\/h2>\n
v$log<\/h3>\n
SQL> desc v$log\n\nCOLUMN_NAME                              TYPE               CONSTRAINT          \n---------------------------------------- ------------------ --------------------\nTHREAD#                                  NUMBER             \nGROUP#                                   NUMBER             \nSEQUENCE#                                NUMBER             \nBYTES                                    NUMBER             \nMEMBERS                                  NUMBER             \nARCHIVED                                 VARCHAR(3)         \nSTATUS                                   VARCHAR(8)         \nFIRST_CHANGE#                            NUMBER             \nFIRST_TIME                               DATE\n<\/code><\/pre>\n
v$log<\/h3>\n
SQL> desc v$logfile\n\nCOLUMN_NAME                              TYPE               CONSTRAINT          \n---------------------------------------- ------------------ --------------------\nGROUP#                                   NUMBER             \nSTATUS                                   VARCHAR(7)         \nTYPE                                     CHAR(6)            \nMEMBER                                   VARCHAR(256)\n<\/code><\/pre>\n
v$log_history<\/h3>\n
SQL> desc v$log_history\n\nCOLUMN_NAME                              TYPE               CONSTRAINT          \n---------------------------------------- ------------------ --------------------\nTHREAD#                                  NUMBER             \nSEQUENCE#                                NUMBER             \nFIRST_CHANGE#                            NUMBER             \nFIRST_TIME                               DATE               \nNEXT_CHANGE#                             NUMBER             \nNEXT_TIME                                DATE\n<\/code><\/pre>\n
redo logfile \uc0c1\ud0dc<\/h2>\n
CURRENT<\/h3>\n
log switch\uac00 \ubc1c\uc0dd\ud558\uace0 log file\uc758 \ub0b4\uc6a9\uc774 DB Buffer cache\uc5d0\uc11c datafile\ub85c \uc800\uc7a5\ub418\uc9c0 \uc54a\uc740 \uc0c1\ud0dc<\/p>\n
ACTIVE<\/h3>\n
log switch\uac00 \ubc1c\uc0dd\ud558\uace0 logfile\uc758 \ub0b4\uc6a9\uc774 DB Buffer cache\uc5d0\uc11c datafile\ub85c \uc800\uc7a5\ub418\uc9c0 \uc54a\uc740 \uc0c1\ud0dc<\/p>\n
UNUSED<\/h3>\n
online redo log file group\uc744 \uae30\ub85d\ud55c \uc801\uc774 \uc5c6\ub294 \uc0c1\ud0dc. \ubc29\uae08 \ucd94\uac00\ub41c online redo log file\uc758 \uc0c1\ud0dc.<\/p>\n
CLEARING<\/h3>\n
log\uac00 alter database clear logfile \uba85\ub839 \ud6c4\uc5d0 \ube44\uc5b4\uc788\ub294 \ub85c\uadf8\ub85c \uc7ac\uc0dd\uc131 \uc911\uc784\uc744 \ub098\ud0c0\ub0b4\ub294 \uc0c1\ud0dc. \uc9c0\uc6cc\uc9c4 \ud6c4\uc5d0\ub294 UNUSED\ub85c \ubcc0\uacbd.<\/p>\n
CLEARING_CURRENT<\/h3>\n
current redo log file\uc5d0 \ub300\ud55c \uc7a5\uc560 \uc0c1\ud669. \uc0c8 log header\ub97c \uae30\ub85d\ud558\ub294 \uc911 I\/O \uc624\ub958 \uac19\uc740 \uc2a4\uc704\uce58 \uc7a5\uc560\uac00 \ubc1c\uc0dd\ud55c \uacbd\uc6b0 \uc774 \uc0c1\ud0dc\uac00 \ub420 \uc218 \uc788\uc74c.<\/p>\n","protected":false},"excerpt":{"rendered":"
logfile \uc0ac\uc774\uc988 \ubcc0\uacbd logfile \uc0c1\ud0dc \ud655\uc778 select l.group#, l.status, l.bytes, lf.member , l.first_time from v$log l, v$logfile lf where l.group# = lf.group# Inactive \ud30c\uc77c \uc0ad\uc81c alter database drop logfile group 1; –\uc2e4\uc81c \ub370\uc774\ud130\ud30c\uc77c \uc0ad\uc81c \ud544\uc694 logfile \ucd94\uac00 alter database add logfile group 1 ( ‘\/tbdata\/redo011.redo’,’\/tbdata\/redo012.redo’); redo log \uad00\ub828 view v$log SQL> desc v$log COLUMN_NAME TYPE […]<\/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-112","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\/112","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=112"}],"version-history":[{"count":7,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/112\/revisions"}],"predecessor-version":[{"id":1317,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/112\/revisions\/1317"}],"wp:attachment":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/media?parent=112"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/categories?post=112"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/tags?post=112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}