{"id":523,"date":"2008-05-28T10:39:33","date_gmt":"2008-05-28T10:39:33","guid":{"rendered":""},"modified":"2017-07-28T18:05:49","modified_gmt":"2017-07-28T09:05:49","slug":"oracle-9i-archive-mode-%eb%b3%80%ea%b2%bd","status":"publish","type":"post","link":"https:\/\/heyo.net\/wp\/523","title":{"rendered":"[oracle] 9i archive mode \ubcc0\uacbd"},"content":{"rendered":"

* \uae30\ubcf8\uac1c\ub150..
\n   – spfile \ubcc0\uacbd
\n   – shutdown  (\ubcc0\uacbd\ub41c spfile \uc801\uc6a9\uc744 \uc704\ud574 \uc7ac\uae30\ub3d9)
\n   – startup mount
\n   – archive mode \ubcc0\uacbd
\n   – alter database open<\/p>\n

* archive mode \ud655\uc778
\nSQL> archive log list
\nDatabase log mode              No Archive Mode
\nAutomatic archival             Disabled
\nArchive destination            \/ora_edu1\/user19\/arch
\nOldest online log sequence     0
\nCurrent log sequence           1<\/p>\n

(Database log mode \uc640 Automatic archival \uc740 \uc11c\ub85c \ub9de\uc544 \ub5a8\uc5b4\uc838\uc57c \ud55c\ub2e4. No archive Mode-Disable, Archive Mode-Enable)<\/p>\n

* archive \ud30c\ub77c\uba54\ud130 \ud655\uc778
\nSQL> show parameter log_archive  \ud639\uc740 SQL> select name, value from v$parameter where name like ‘log_archive%’<\/p>\n

\n\u25cb archive mode \ub85c \ubcc0\uacbd
\n1) \ud544\uc218 \ud30c\ub77c\uba54\ud130 \ubcc0\uacbd
\nSQL> alter system set log_archive_start=true scope=spfile;
\nSQL> alter system set log_archive_dest_1=’location=\/archive\/common\/’ scope=spfile;
\nSQL> alter system set log_archive_format=’comm_%t_%s.arc’ scope=spfile;<\/p>\n

2) Database \uc7ac\uae30\ub3d9
\nSQL> shutdown immedate;
\nSQL> startup mount;<\/p>\n

3) archive log mode \ubcc0\ud658
\nSQL> alter database archivelog;<\/p>\n

4) \ud655\uc778 \ubc0f database open
\nSQL> archive log list;
\nSQL> alter database open;<\/p>\n

5) \uc544\uce74\uc774\ube0c \ud30c\uc77c \uac15\uc81c \uc0dd\uc131(\uc81c\ub300\ub85c \ub410\ub294\uc9c0 \ud655\uc778\uc744 \uc704\ud574)
\nSQL> alter system switch logfile;
\nSQL> \/
\nSQL> \/<\/p>\n

\u25cb noarchive mode \ub85c \ubcc0\uacbd
\n1) \ud544\uc218 \ud30c\ub77c\uba54\ud130 \ubcc0\uacbd
\nSQL> alter system set log_archive_start=false scope=spfile;<\/p>\n

2) Database \uc7ac\uae30\ub3d9
\nSQL> shutdown immedate;
\nSQL> startup mount;<\/p>\n

3) archive log mode \ubcc0\ud658
\nSQL> alter database noarchivelog;<\/p>\n

4) \ud655\uc778 \ubc0f database open
\nSQL> archive log list;
\nSQL> alter database open;<\/p>\n

<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

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

* \uae30\ubcf8\uac1c\ub150..    – spfile \ubcc0\uacbd    – shutdown  (\ubcc0\uacbd\ub41c spfile…<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[3],"tags":[],"class_list":["post-523","post","type-post","status-publish","format-standard","hentry","category-prog_tip"],"_links":{"self":[{"href":"https:\/\/heyo.net\/wp\/wp-json\/wp\/v2\/posts\/523","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/heyo.net\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/heyo.net\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/heyo.net\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/heyo.net\/wp\/wp-json\/wp\/v2\/comments?post=523"}],"version-history":[{"count":1,"href":"https:\/\/heyo.net\/wp\/wp-json\/wp\/v2\/posts\/523\/revisions"}],"predecessor-version":[{"id":65961,"href":"https:\/\/heyo.net\/wp\/wp-json\/wp\/v2\/posts\/523\/revisions\/65961"}],"wp:attachment":[{"href":"https:\/\/heyo.net\/wp\/wp-json\/wp\/v2\/media?parent=523"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/heyo.net\/wp\/wp-json\/wp\/v2\/categories?post=523"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/heyo.net\/wp\/wp-json\/wp\/v2\/tags?post=523"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}