Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- dba:oracle_rac_logfile_handling [2019/02/21 19:51] – [Audit Logs der Datenbank(en)] gpipperr
+++ dba:oracle_rac_logfile_handling [2019/02/21 20:58] – [Job um automatisch zu löschen] gpipperr
@@ Zeile 368: / Zeile 368: @@
 Script Fragment:
-<code bash >
+<code bash cleanDiagHome.sh >
 #!/bin/sh
-# clean DIAG HOMES
+# ######################################
 #
+#  Purge DIAG HOMES
+#  www.pipperr.de
+#  see https://www.pipperr.de/dokuwiki/doku.php?id=dba:oracle_rac_logfile_handling
+#
+# #####################################
+# Crontab
+#
+# M H  D M
+# Oracle purge  DIAG Logs
+# 0 20 * * * /home/grid/scripts/cleanDiagHome.sh  > /tmp/crontab_start_clean_diag_home_job_grid.log
+#
+# #####################################
-#set the enviroment to the grid home
+#set the enviroment to the ${USER} home
-source /home/grid/.profile
+source /home/${USER}/.profile
-# set the home switch ot the current user!
-ORA_HOME_SWITCH = 1
+# set the home switch to the current user!
+# Set this for each installation
+setdb 1 > /dev/null 2>&1
 # Fill out the diag home
+# Set this for each installation
 DIAG_HOME=/opt/oracle/
 # write log
-LOG_FILE=/tmp/diag_delete_log.log
+LOG_FILE=/tmp/diag_delete_log_${USER}.log
 #  set rentation policy days
 # 263520= 183 days
-HOURS=263520
+# Set this for each installation
+MINUTES=263520
 echo "Info - start to analyses all DIAG Homes  - start at  -- `date` -- "       > $LOG_FILE
-echo "Info - clean all 12c homes after for files older than ${HOURS} minutes"  >> $LOG_FILE
+echo "Info - clean all 12c homes after for files older than ${MINUTES} minutes"  >> $LOG_FILE
 for a in $(adrci exec="show homes" | grep diag)
@@ Zeile 399: / Zeile 412: @@
-  echo "Info - Info purge Log for Home  ${a}"         >> $LOG_FILE
+    echo "Info - Info purge Log for Home  ${a}"         >> $LOG_FILE
     # check the user for this home
@@ Zeile 410: / Zeile 423: @@
     if [[ ${USER} = ${FILE_OWNER} ]]; then
-		setdb ORA_HOME_SWITCH
+		adrci exec="set home ${a}; purge -age ${MINUTES} ;"   >> $LOG_FILE  2>&1
-		adrci exec="set home ${a}; purge -age 263520 ;"      >> $LOG_FILE  2>&1
+     else
-	fi
+	   echo "Warning - Can not clean ADR files from other user ${FILE_OWNER} as user ${USER}"        >> $LOG_FILE
+     fi
-  done
+done
-  echo "Info - finish at  -- `date` -- "                >> $LOG_FILE
+echo "Info - finish at  -- `date` -- "                >> $LOG_FILE
 </code>
+Aktuellste Version siehe hier => https://github.com/gpipperr/OraPowerShell/blob/master/Ora_Bash_env_DB_backup/scripts/cleanDiagHome.sh
 (Achtung, falls Ihr das Script kopiert, müsste Ihr die Oracle Home Umgebung manuell setzen oder .profile von mir verwenden)