{"id":4034,"date":"2018-07-04T13:07:59","date_gmt":"2018-07-04T04:07:59","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=4034"},"modified":"2018-07-04T13:07:59","modified_gmt":"2018-07-04T04:07:59","slug":"oracle-log-%ea%b4%80%eb%a6%ac-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=4034","title":{"rendered":"Oracle Log \uad00\ub9ac \ubc29\ubc95"},"content":{"rendered":"<p>\ub2e4\uc74c\uc758 \ub0b4\uc6a9\ub4e4\uc740 \uac1c\uc778\uc801\uc778 \uad8c\uc7a5\ud558\ub294 \uc0ac\ud56d\ub4e4\uc774\ub2e4.<\/p>\n<p>\uc624\ub77c\ud074 10g\uc758 \uacbd\uc6b0 \uc5d4\uc9c4 \uc124\uce58\ub97c \uc704\ud55c \ub514\ub809\ud1a0\ub9ac \uacf5\uac04\uc744 20GB \uc774\uc0c1 \uc8fc\ub294 \uac83\uc744 \uad8c\uc7a5\ud55c\ub2e4.<\/p>\n<p>\uc624\ub77c\ud074\uc758 adump, bdump, udump, \ub9ac\uc2a4\ub108 \ub85c\uadf8, \uc544\uce74\uc774\ube0c \ub85c\uadf8 \ub4f1\uc744 \ubc31\uc5c5\ud560 \uc218 \uc788\uc73c\uba74<\/p>\n<p>\ubc31\uc5c5\ud558\ub294 \uac83\uc744 \uad8c\uc7a5\ud55c\ub2e4. \ud558\uc9c0\ub9cc \ub300\ubd80\ubd84\uc758 \uacbd\uc6b0 \ubc31\uc5c5\uc758 \ud544\uc694\uc131\uc774 \uc808\uc2e4\ud558\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc5d0<\/p>\n<p>\uc0ad\uc81c\ud55c\ub2e4.<\/p>\n<p>\uac01\uc885 \ub85c\uadf8\uc758 \uc790\ub3d9 \uad00\ub9ac\ub97c \uc704\ud558\uc5ec \ucca8\ubd80\ud55c \ud30c\uc77c\uacfc \uac19\uc774 CRONTAB \uc5d0 \ub4f1\ub85d\ud558\uc5ec \uad00\ub9ac\ud558\uba74 \ud3b8\ub9ac\ud558\ub2e4.<br \/>\n\uac01\uac01\uc758 \ub85c\uadf8 \uad00\ub9ac\uc5d0 \ub300\ud55c \uc815\ucc45\uc774 \ud544\uc694\ud558\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>\uc815\ucc45 \uc608\uc2dc)<\/strong><\/p>\n<p><strong>1. alert \ub85c\uadf8 : \uc6d4\ubcc4\ub85c \ub85c\uadf8\ub97c \uad00\ub9ac. \uc601\uad6c \ubcf4\uad00\ud558\ub294 \uac83\uc774 \uc88b\ub2e4. compress \uba85\ub839\uc73c\ub85c \uc555\ucd95\ud558\uc5ec \ubcf4\uad00.<\/strong><\/p>\n<p><strong>2. adump audit \ud30c\uc77c : 180\uc77c \uc815\ub3c4 \uc720\uc9c0, \ub9e4\uc77c 180\uc77c\uc774 \uc9c0\ub09c trc\ud30c\uc77c\uc744 \uc0ad\uc81c<\/strong><\/p>\n<p><strong>3. bdump trace \ud30c\uc77c : 90\uc77c \uc815\ub3c4 \uc720\uc9c0, \ub9e4\uc77c 90\uc77c\uc774 \uc9c0\ub09c trc\ud30c\uc77c\uc744 \uc0ad\uc81c<\/strong><\/p>\n<p><strong>4. udump trace \ud30c\uc77c : 90\uc77c \uc815\ub3c4 \uc720\uc9c0, \ub9e4\uc77c 90\uc77c\uc774 \uc9c0\ub09c trc\ud30c\uc77c\uc744 \uc0ad\uc81c<\/strong><\/p>\n<p><strong>5. \ub9ac\uc2a4\ub108 \ub85c\uadf8 : \ub9ac\uc2a4\ub108\ub97c \ub85c\uae45\ud558\ub3c4\ub85d \uc124\uc815\ud588\uc744 \uacbd\uc6b0 \uc6d4\ubcc4\ub85c \ub85c\uadf8\ub97c \uad00\ub9ac. 180\uc77c\uc774 \uc9c0\ub09c \ud30c\uc77c\uc740 \uc0ad\uc81c. compress \uba85\ub839\uc73c\ub85c \uc555\ucd95\ud558\uc5ec \ubcf4\uad00.<\/strong><\/p>\n<p><strong>6. \uc544\uce74\uc774\ube0c\ub85c\uadf8 \ud30c\uc77c : \uae30\ubcf8\uc801\uc73c\ub85c 1\uc8fc\uc77c\uc5d0 1\ubc88 \uc774\uc0c1 FULL BACKUP\uc744 \ubc1b\uc744 \uacbd\uc6b0 \ubc31\uc5c5 \ud234\uc5d0\uc11c \uc544\uce74\uc774\ube0c\ub85c\uadf8\ub97c \uad00\ub9ac\ud574 \uc8fc\uc9c0 \uc54a\uc744 \uacbd\uc6b0 \ub4f1\ub85d\ud558\uc5ec \uc0ac\uc6a9 7\uc77c\uc804 \uc544\uce74\uc774\ube0c\ub85c\uadf8 \ud30c\uc77c \uc0ad\uc81c.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<pre class=\"lang:plsql decode:true\">\uc258 \uc608\uc2dc)\r\n\r\n\uc258 \uc2a4\ud06c\ub9bd\ud2b8 \uc791\uc131 \uc2dc \uc624\ud0c0\uc5d0 \uc8fc\uc758\ud560 \uac83. \ubc18\ub4dc\uc2dc \ud14c\uc2a4\ud2b8 \ud6c4 \uc801\uc6a9\ud560 \uac83\r\n###################################################\r\n#### alert.log                                 ####\r\n#### (\ub9e4\uc6d4 1\uc77c \uc2e4\ud589\ud560 \uc218 \uc788\ub3c4\ub85d cron job \ub4f1\ub85d )    ####\r\n###################################################\r\nnDate=`date +%Y%m%d`\r\ncp $ORACLE_BASE\/admin\/TESTDB\/bdump\/alert_TESTDB.log $ORACLE_BASE\/TESTDB\/bdump\/alert_TESTDB.log.$nDate\r\ncat \/dev\/null &gt; $ORACLE_BASE\/admin\/TESTDB\/bdump\/alert_TESTDB.log\r\ncompress -vf $ORACLE_BASE\/TESTDB\/bdump\/alert_TESTDB.log.$nDate\r\n\r\n \r\n\r\n#######################################################\r\n#### listener.log                                  ####\r\n#### (\ub9e4\uc6d4 1\uc77c \uc2e4\ud589\ud560 \uc218 \uc788\ub3c4\ub85d cron job \ub4f1\ub85d )        ####\r\n#######################################################\r\nnDate=`date +%Y%m%d`\r\ncp $ORACLE_HOME\/network\/admin\/listener.log $ORACLE_HOME\/network\/admin\/listener.log.$nDate\r\ncat \/dev\/null &gt; $ORACLE_HOME\/network\/admin\/listener.log\r\ncompress -vf $ORACLE_HOME\/network\/admin\/listener.log.$nDate\r\n\r\n \r\n\r\n#######################################################\r\n#### audit                                         ####\r\n#######################################################\r\n# 180\uc77c\uc774 \uc9c0\ub09c *.aud\ub97c \ucc3e\uc544 \uc0ad\uc81c\r\nfind $ORACLE_BASE\/admin\/TESTDB\/adump \\( -ctime +180 -name '*.aud' \\) -exec rm -f {} \\;\r\n\r\n \r\n\r\n####################################################\r\n#### .trc                                       ####\r\n# 90\uc77c\uc774 \uc9c0\ub09c *.trc\ub97c \ucc3e\uc544 \uc0ad\uc81c                    ####\r\n####################################################\r\nfind $ORACLE_BASE\/admin\/TESTDB\/bdump \\( -ctime +90 -name '*.trc' \\) -exec rm -f {} \\;\r\nfind $ORACLE_BASE\/admin\/TESTDB\/udump \\( -ctime +90 -name '*.trc' \\) -exec rm -f {} \\;\r\n\r\n \r\n\r\n#######################################################\r\n#### archive log                                   ####\r\n#######################################################\r\n# 7\uc77c\uc774 \uc9c0\ub09c *.arc\ub97c \ucc3e\uc544 \uc0ad\uc81c\r\nfind \/archive_log \\( -ctime +7 -name '*.arc' \\) -exec rm -f {} \\;\r\n\r\n\u200b\r\n\r\n[\ucc38\uace0] $\ub294 \ubcc0\uc218, #\uc740 \uc8fc\uc11d\uc744 \ud45c\uc2dc<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ub2e4\uc74c\uc758 \ub0b4\uc6a9\ub4e4\uc740 \uac1c\uc778\uc801\uc778 \uad8c\uc7a5\ud558\ub294 \uc0ac\ud56d\ub4e4\uc774\ub2e4. \uc624\ub77c\ud074 10g\uc758 \uacbd\uc6b0 \uc5d4\uc9c4 \uc124\uce58\ub97c \uc704\ud55c \ub514\ub809\ud1a0\ub9ac \uacf5\uac04\uc744 20GB \uc774\uc0c1 \uc8fc\ub294 \uac83\uc744 \uad8c\uc7a5\ud55c\ub2e4. \uc624\ub77c\ud074\uc758 adump, bdump, udump, \ub9ac\uc2a4\ub108 \ub85c\uadf8, \uc544\uce74\uc774\ube0c \ub85c\uadf8 \ub4f1\uc744 \ubc31\uc5c5\ud560 \uc218 \uc788\uc73c\uba74 \ubc31\uc5c5\ud558\ub294 \uac83\uc744 \uad8c\uc7a5\ud55c\ub2e4. \ud558\uc9c0\ub9cc \ub300\ubd80\ubd84\uc758 \uacbd\uc6b0 \ubc31\uc5c5\uc758 \ud544\uc694\uc131\uc774 \uc808\uc2e4\ud558\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc5d0 \uc0ad\uc81c\ud55c\ub2e4. \uac01\uc885 \ub85c\uadf8\uc758 \uc790\ub3d9 \uad00\ub9ac\ub97c \uc704\ud558\uc5ec \ucca8\ubd80\ud55c \ud30c\uc77c\uacfc \uac19\uc774 CRONTAB \uc5d0 \ub4f1\ub85d\ud558\uc5ec \uad00\ub9ac\ud558\uba74 \ud3b8\ub9ac\ud558\ub2e4. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2857,"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":[9],"tags":[1112,1111],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/oracle-business-intelligence.jpg?fit=973%2C615","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4034"}],"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=4034"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4034\/revisions"}],"predecessor-version":[{"id":4035,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4034\/revisions\/4035"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2857"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4034"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4034"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4034"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}