{"id":344,"date":"2015-04-03T02:33:16","date_gmt":"2015-04-03T02:33:16","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=344"},"modified":"2015-04-03T02:33:16","modified_gmt":"2015-04-03T02:33:16","slug":"windows%ed%99%98%ea%b2%bd%ec%97%90%ec%84%9c-rman%ec%9d%84-%ec%9d%b4%ec%9a%a9%ed%95%9c-archive-log-%ec%82%ad%ec%a0%9c-%ec%8a%a4%ed%81%ac%eb%a6%bd%ed%8a%b8-%eb%a7%8c%eb%93%a4%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=344","title":{"rendered":"Windows\ud658\uacbd\uc5d0\uc11c RMAN\uc744 \uc774\uc6a9\ud55c Archive log \uc0ad\uc81c \uc2a4\ud06c\ub9bd\ud2b8 \ub9cc\ub4e4\uae30"},"content":{"rendered":"

\u00a0
\n\u00a0<\/p>\n

    \n
  1. rr.bat \ud30c\uc77c \uc0dd\uc131
    \n<\/span><\/li>\n<\/ol>\n

    rman target \/ @C:\\arch_del.sql
    \n<\/span><\/p>\n

    \u00a0
    \n\u00a0<\/p>\n

      \n
    1. arch_del.sql \ud30c\uc77c \uc0dd\uc131
      \n<\/span><\/li>\n<\/ol>\n

      delete archivelog all completed before ‘sysdate -90’;
      \n<\/span><\/p>\n

      \u00a0
      \n\u00a0<\/p>\n

        \n
      1. \n
        \uc791\uc5c5 \uc2a4\ucf00\uc904\ub7ec \ub4f1\ub85d(Windows 2008 \uae30\uc900)
        \n<\/span><\/div>\n

        \uc2dc\uc791 – \uc791\uc5c5\ub3c4\uad6c – \uc791\uc5c5 \uc2a4\ucf00\uc904\ub7ec \uc2e4\ud589
        \n<\/span><\/p>\n<\/li>\n<\/ol>\n

        \"\"
        \n\t\t<\/span><\/p>\n

        \u00a0
        \n\u00a0<\/p>\n

        \u00a0
        \n\u00a0<\/p>\n

        \ub3d9\uc791 – \uc791\uc5c5 \ub9cc\ub4e4\uae30 \uc2e4\ud589
        \n<\/span><\/p>\n

        \"\"
        \n\t\t<\/span><\/p>\n

        \u00a0
        \n\u00a0<\/p>\n

        \uc544\ub798\uc640 \uac19\uc774 \uc791\uc131 \ud6c4 \ud2b8\ub9ac\uac70 \ud0ed\uc73c\ub85c \uc774\ub3d9
        \n<\/span><\/p>\n

        \"\"
        \n\t\t<\/span><\/p>\n

        \u00a0
        \n\u00a0<\/p>\n

        \uc0c8\ub85c\ub9cc\ub4e4\uae30 \ud074\ub9ad
        \n<\/span><\/p>\n

        \"\"
        \n\t\t<\/span><\/p>\n

        \u00a0
        \n\u00a0<\/p>\n

        \u00a0
        \n\u00a0<\/p>\n

        \ub9e4 \uc77c\ub9c8\ub2e4 \uc2e4\ud589\ub418\uac8c\ub054 \uc124\uc815
        \n<\/span><\/p>\n

        \"\"
        \n\t\t<\/span><\/p>\n

        \u00a0
        \n\u00a0<\/p>\n

        \ub3d9\uc791 \ud0ed \ud074\ub9ad \ud6c4 \uc0c8\ub85c\ub9cc\ub4e4\uae30
        \n<\/span><\/p>\n

        \"\"
        \n\t\t<\/span><\/p>\n

        \u00a0
        \n\u00a0<\/p>\n

        \u00a0
        \n\u00a0<\/p>\n

        \ub3d9\uc791\uc744 \ud504\ub85c\uadf8\ub7a8 \uc2dc\uc791\uc73c\ub85c \uc124 \uc815\ud6c4 .bat \ud30c\uc77c \uc9c0\uc815
        \n<\/span><\/p>\n

        \"\"
        \n\t\t<\/span><\/p>\n

        \u00a0
        \n\u00a0<\/p>\n

        \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc785\ub825\ud558\uace0 \uc124\uc815\uc744 \ub9c8\uce69\ub2c8\ub2e4.
        \n<\/span><\/p>\n

        \"\"
        \n\t\t<\/span><\/p>\n

        \u00a0<\/span>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"

        \u00a0 \u00a0 rr.bat \ud30c\uc77c \uc0dd\uc131 rman target \/ @C:\\arch_del.sql \u00a0 \u00a0 arch_del.sql \ud30c\uc77c \uc0dd\uc131 delete archivelog all completed before ‘sysdate -90’; \u00a0 \u00a0 \uc791\uc5c5 \uc2a4\ucf00\uc904\ub7ec \ub4f1\ub85d(Windows 2008 \uae30\uc900) \uc2dc\uc791 – \uc791\uc5c5\ub3c4\uad6c – \uc791\uc5c5 \uc2a4\ucf00\uc904\ub7ec \uc2e4\ud589 \u00a0 \u00a0 \u00a0 \u00a0 \ub3d9\uc791 – \uc791\uc5c5 \ub9cc\ub4e4\uae30 \uc2e4\ud589 \u00a0 \u00a0 \uc544\ub798\uc640 \uac19\uc774 \uc791\uc131 \ud6c4 \ud2b8\ub9ac\uac70 \ud0ed\uc73c\ub85c \uc774\ub3d9 \u00a0 \u00a0 […]<\/p>\n","protected":false},"author":1,"featured_media":345,"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":[21],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile21.uf.274BD033551DFBE9247DF5.png?fit=576%2C356","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/344"}],"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=344"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/344\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/345"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=344"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=344"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=344"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}