{"id":972,"date":"2015-06-04T11:20:11","date_gmt":"2015-06-04T09:20:11","guid":{"rendered":"http:\/\/fougere.myds.me:8080\/info\/?p=972"},"modified":"2015-06-04T11:20:11","modified_gmt":"2015-06-04T09:20:11","slug":"sauve_cold-sh","status":"publish","type":"post","link":"http:\/\/les-fougs.com\/wordpress\/2015\/06\/04\/sauve_cold-sh\/","title":{"rendered":"sauve_cold.sh"},"content":{"rendered":"<pre>#!\/bin\/bash\n# ==================================================\n# Nom : sauve_cold.sh\n# Objet : sauvegarde RMAN a froid d'une base complete\n# Auteur : S. GOURGAND - DIGORA\n# Cree le : 27\/01\/2010\n# Syntaxe : sauve_cold.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\necho \"w_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}\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 \/ ;\nconnect catalog rman\/rman@ref_rman;<\/pre>\n<pre>crosscheck backup;\ncrosscheck archivelog all;\ndelete noprompt expired backup;\ndelete noprompt expired archivelog all;\ndelete noprompt obsolete;<\/pre>\n<pre>startup force dba;\nshutdown immediate;\nstartup mount;\nbackup tag 'database cold' database plus archivelog tag 'archives cold';\nalter database open;\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} : Sauvegarde a froid de la base ${w_instance}\" u1_info_exploit@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_cold.sh # Objet : sauvegarde RMAN a froid d&rsquo;une base complete # Auteur : S. GOURGAND &#8211; DIGORA # Cree le : 27\/01\/2010 # Syntaxe : sauve_cold.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; } # &hellip; <a href=\"http:\/\/les-fougs.com\/wordpress\/2015\/06\/04\/sauve_cold-sh\/\" class=\"more-link\">Continuer la lecture<span class=\"screen-reader-text\"> de &laquo;&nbsp;sauve_cold.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\/972"}],"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=972"}],"version-history":[{"count":0,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/972\/revisions"}],"wp:attachment":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/media?parent=972"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/categories?post=972"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/tags?post=972"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}