{"id":970,"date":"2015-06-04T11:19:03","date_gmt":"2015-06-04T09:19:03","guid":{"rendered":"http:\/\/fougere.myds.me:8080\/info\/?p=970"},"modified":"2015-06-04T11:19:03","modified_gmt":"2015-06-04T09:19:03","slug":"sauve_hot-sh","status":"publish","type":"post","link":"http:\/\/les-fougs.com\/wordpress\/2015\/06\/04\/sauve_hot-sh\/","title":{"rendered":"sauve_hot.sh"},"content":{"rendered":"<pre>#!\/bin\/bash\n# ==================================================\n# Nom : sauve_backup.sh\n# Objet : sauvegarde RMAN d'une base complete\n# Auteur : S. GOURGAND - DIGORA\n# Cree le : 28\/01\/2010\n# Syntaxe : sauve_backup.sh database_name\n# ==================================================<\/pre>\n<pre># ----------------------------------\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\n[ \"${HOSTNAME}\" = \"king\" -o \"${HOSTNAME}\" = \"king.faiveley.com\" ] &amp;&amp; w_num=1\n[ \"${HOSTNAME}\" = \"kong\" -o \"${HOSTNAME}\" = \"kong.faiveley.com\" ] &amp;&amp; w_num=2\n[ \"${HOSTNAME}\" = \"ping\" -o \"${HOSTNAME}\" = \"ping.faiveleytransport.local\" ] &amp;&amp; w_num=3\n[ \"${HOSTNAME}\" = \"pong\" -o \"${HOSTNAME}\" = \"pong.faiveleytransport.local\" ] &amp;&amp; w_num=4\nv_res=`grep \"${w_instance}${w_num}:\" \/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}${w_num}\necho instance : ${ORACLE_SID}\n# export NLS_DATE_FORMAT=YYYY.MM.DD.HH24.MI.SS\nexport NLS_DATE_FORMAT=\"DD\/MM\/YYYY 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>rman &lt;&lt;EORMAN &gt;${w_log_file} 2&gt;&amp;1\nconnect target \/ ;<\/pre>\n<pre>crosscheck backup;\ncrosscheck archivelog all;\ndelete noprompt expired backup;\ndelete noprompt expired archivelog all;\ndelete noprompt obsolete;<\/pre>\n<pre>backup incremental level 0 tag 'database level 0' database plus archivelog tag 'archives level 0';\ndelete noprompt obsolete;<\/pre>\n<pre>report need backup;\nlist backup summary;<\/pre>\n<pre>exit\nEORMAN<\/pre>\n<pre># Ajout 08\/04\/2010 : Envoi du fichier de traces par mail\n# ------------------------------------------------------\nw_host=`basename $HOSTNAME .faiveley.com`\nw_host=`basename ${w_host} .faiveleytransport.local | tr [a-z] [A-Z]`\nmail -s \"${w_host} : Hot Backup Database ${w_instance}\" nicolas.lamotte@faiveleytransport.com &lt;${w_log_file}<\/pre>\n<pre># Ajout 31\/03\/2011 : Traitement des anomalies pour VTOM\n# -----------------------------------------------------\nv_res=`grep \"^RMAN-\" ${w_log_file} | wc -l`\nv_res=`expr ${v_res}`\nif [ ${v_res} -gt 0 ]\nthen\n echo +----------------------------+\n echo ! DEBUT DU FICHIER DE TRACES !\n echo +----------------------------+\n cat ${w_log_file}\n echo +--------------------------+\n echo ! FIN DU FICHIER DE TRACES !\n echo +--------------------------+\n exit 1\nelse\n exit 0\nfi<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>#!\/bin\/bash # ================================================== # Nom : sauve_backup.sh # Objet : sauvegarde RMAN d&rsquo;une base complete # Auteur : S. GOURGAND &#8211; DIGORA # Cree le : 28\/01\/2010 # Syntaxe : sauve_backup.sh database_name # ================================================== # &#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; # &hellip; <a href=\"http:\/\/les-fougs.com\/wordpress\/2015\/06\/04\/sauve_hot-sh\/\" class=\"more-link\">Continuer la lecture<span class=\"screen-reader-text\"> de &laquo;&nbsp;sauve_hot.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\/970"}],"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=970"}],"version-history":[{"count":0,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/970\/revisions"}],"wp:attachment":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/media?parent=970"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/categories?post=970"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/tags?post=970"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}