{"id":974,"date":"2015-06-04T11:20:46","date_gmt":"2015-06-04T09:20:46","guid":{"rendered":"http:\/\/fougere.myds.me:8080\/info\/?p=974"},"modified":"2015-06-04T11:20:46","modified_gmt":"2015-06-04T09:20:46","slug":"ora_arch_logfile-sh","status":"publish","type":"post","link":"http:\/\/les-fougs.com\/wordpress\/2015\/06\/04\/ora_arch_logfile-sh\/","title":{"rendered":"ora_arch_logfile.sh"},"content":{"rendered":"<pre>#!\/bin\/bash\n# ----------------------------------\n# Fonction d'affichage de la syntaxe\n# ----------------------------------\nsyntaxe()\n{\n echo \"Usage : $0 database_name\"\n}<\/pre>\n<pre># --------------------------\n# Verification de la syntaxe\n# --------------------------\nif [ $# -ne 1 ]\nthen\n echo \"==================================================\"\n echo \"ERREUR : Nombre d'arguments incorrects !\"\n syntaxe\n echo \"==================================================\"\n exit 1\nfi<\/pre>\n<pre># --------------------------\n# Verification des arguments\n# --------------------------\nw_instance=$1\nv_res=`grep \"${w_instance}:\" \/etc\/oratab | wc -l`\nv_res=`expr ${v_res}`\nif [ ${v_res} -eq 0 ]\nthen\n echo \"==================================================\"\n echo \"ERREUR : Base de donnees ${w_instance} inexistante !\"\n syntaxe\n echo \"==================================================\"\n exit 1\nfi<\/pre>\n<pre>export ORACLE_SID=${w_instance}\necho $ORACLE_SID\n# export NLS_DATE_FORMAT=YYYY.MM.DD.HH24.MI.SS<\/pre>\n<pre>w_prog=`basename $0 .sh`\nw_date=$(date '+%Y_%m_%d_%H_%M_%S')<\/pre>\n<pre>w_log_dest=\/exploit\/logs\nw_log_file=$w_log_dest\/${w_date}_${w_prog}_${w_instance}.log;<\/pre>\n<pre>sqlplus \/nolog &lt;&lt;EOSQL &gt;&gt;$w_log_file 2&gt;&amp;1\nWHENEVER SQLERROR EXIT SQL.SQLCODE\nconnect \/ as sysdba\nALTER SYSTEM ARCHIVE LOG CURRENT;\nexit<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>#!\/bin\/bash # &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;- # Fonction d&rsquo;affichage de la syntaxe # &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;- syntaxe() { echo &laquo;&nbsp;Usage : $0 database_name&nbsp;&raquo; } # &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; # Verification de la syntaxe # &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; if [ $# -ne 1 ] then echo &laquo;&nbsp;==================================================&nbsp;&raquo; echo &laquo;&nbsp;ERREUR : Nombre d&rsquo;arguments incorrects !&nbsp;&raquo; syntaxe echo &laquo;&nbsp;==================================================&nbsp;&raquo; exit 1 fi # &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; # Verification des &hellip; <a href=\"http:\/\/les-fougs.com\/wordpress\/2015\/06\/04\/ora_arch_logfile-sh\/\" class=\"more-link\">Continuer la lecture<span class=\"screen-reader-text\"> de &laquo;&nbsp;ora_arch_logfile.sh&nbsp;&raquo;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[53,37],"tags":[],"_links":{"self":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/974"}],"collection":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/comments?post=974"}],"version-history":[{"count":0,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/974\/revisions"}],"wp:attachment":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/media?parent=974"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/categories?post=974"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/tags?post=974"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}