Advertisement
m4ly

ORACLE ADRCI Purging

Jun 8th, 2015
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 1.31 KB | None | 0 0
  1. #!/bin/bash
  2.  
  3. # Author: Dawid Mocek
  4. # All rights reserved
  5.  
  6.  
  7. # Removes ALERT|INCIDENT|TRACE|CDUMP|HM|UTSCDMP messages for all instances
  8.  
  9. # Do not change values below :
  10. ADRCI_CMD="$ORACLE_HOME/bin/adrci"
  11.  
  12. if [ ! -x "$ADRCI_CMD" ]; then
  13.     echo "Not found: $ADRCI_CMD"
  14.     exit 1
  15. fi
  16.  
  17. ADRCI_EXEC="$($ADRCI_CMD exec="SHOW HOMES")"
  18. ADR_HOME=""
  19. ADR_HOMES=()
  20. ADR_HOMES_SIZE=0
  21. while read -r line; do
  22.     ADR_HOMES+=("$line")
  23. done <<< "$ADRCI_EXEC"
  24.  
  25. ADR_HOMES_SIZE=${#ADR_HOMES[@]}
  26.  
  27. if [ "$ADR_HOMES_SIZE" -ge "1" ]; then
  28.  
  29.     unset "ADR_HOMES[0]"
  30.  
  31.     for ADR_HOME in "${ADR_HOMES[@]}"
  32.     do
  33.         echo -n "Purging $ADR_HOME: "
  34.         if [ -d "$ORACLE_BASE/$ADR_HOME" ]; then
  35.             ADRCI_EXEC="  SET HOMEPATH $ADR_HOME;"
  36.             ADRCI_EXEC+=" PURGE -AGE 10080 -TYPE ALERT;"
  37.             ADRCI_EXEC+=" PURGE -AGE 10080 -TYPE INCIDENT;"
  38.             ADRCI_EXEC+=" PURGE -AGE 10080 -TYPE TRACE;"
  39.             ADRCI_EXEC+=" PURGE -AGE 10080 -TYPE CDUMP;"
  40.             ADRCI_EXEC+=" PURGE -AGE 10080 -TYPE HM;"
  41.             ADRCI_EXEC+=" PURGE -AGE 10080 -TYPE UTSCDMP"
  42.             echo "$ADRCI_EXEC"
  43.             ADRCI_RET="$($ADRCI_CMD exec="$ADRCI_EXEC")"
  44.             echo "$ADRCI_RET"
  45.         else
  46.             echo " ERROR home not found in system path: $ORACLE_BASE/$ADR_HOME"
  47.         fi
  48.     done
  49. fi
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement