Script for V$flash_recovery_area_usage Post: 302528942

Sponsored Content

Top Forums Shell Programming and Scripting Script for V$flash_recovery_area_usage Post 302528942 by jnrpeardba on Wednesday 8th of June 2011 09:27:45 AM

06-08-2011

Registered User

Script for V$flash_recovery_area_usage

Hello,

on a daily / hourly basis I need need to check the size for the Flash Recovery Area (v$flash_recovery_area_usage)

I was not in work yesterday and when I arrived today I checked the alert log only to find that the usage was 100%. This means the overnight backups will not run.

I was wondering if someone could provide a script that gives a warning at 80%

The SQL that I use to determine the ASM Flash Recovery Usage is -->

Code:

SQL> COL % FORMAT 99.0
SQL> SELECT name, free_mb, total_mb, free_mb/total_mb*100 "%" FROM v$asm_diskgroup;

NAME                              FREE_MB   TOTAL_MB          %
------------------------------ ---------- ---------- ----------
DATA                                36054      40960 88.0224609
REDOLOG                             40859      40960  99.753418
BACKUP                              17885      20480 87.3291016
OCRVOTE                             10145      10240 99.0722656

At the moment the usage is fine, but I'd like a shell script that I can schedule via cron, on an hourly basis and send an email, warning me that any of the ASM disks usage has gone above 80%

Thanks in advance

Last edited by pludi; 06-08-2011 at 10:40 AM..

jnrpeardba

View Public Profile for jnrpeardba

Find all posts by jnrpeardba

5 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

create a shell script that calls another script and and an awk script

Hi guys I have a shell script that executes sql statemets and sends the output to a file.the script takes in parameters executes sql and sends the result to an output file. #!/bin/sh echo " $2 $3 $4 $5 $6 $7 isql -w400 -U$2 -S$5 -P$3 << xxx use $4 go print"**Changes to the table...

2. Shell Programming and Scripting

Script will keep checking running status of another script and also restart called script at night

I am using blow script :-- #!/bin/bash FIND=$(ps -elf | grep "snmp_trap.sh" | grep -v grep) #check snmp_trap.sh is running or not if then # echo "process found" exit 0; else echo "process not found" exec /home/Ketan_r /snmp_trap.sh 2>&1 & disown -h ...

3. UNIX for Dummies Questions & Answers

Calling a script from master script to get value from called script

I am trying to call a script(callingscript.sh) from a master script(masterscript.sh) to get string type value from calling script to master script. I have used scripts mentioned below. #masterscript.sh ./callingscript.sh echo $fileExist #callingscript.sh echo "The script is called"...

4. Shell Programming and Scripting

Shell script works fine as a standalone script but not as part of a bigger script

Hello all, I am facing a weird issue while executing a code below - #!/bin/bash cd /wload/baot/home/baotasa0/sandboxes_finance/ext_ukba_bde/pset sh UKBA_publish.sh UKBA 28082015 3 if then echo "Param file conversion for all the areas are completed, please check in your home directory"...

5. Shell Programming and Scripting

How to block first bash script until second bash script script launches web server/site?

I'm new to utilities like socat and netcat and I'm not clear if they will do what I need. I have a "compileDeployStartWebServer.sh" script and a "StartBrowser.sh" script that are started by emacs/elisp at the same time in two different processes. I'm using Cygwin bash on Windows 10. My...

LEARN ABOUT REDHAT

sa2

SA2(8)								Linux User's Manual							    SA2(8)

NAME

       sa2 - Write a daily report in the /var/log/sa directory.

SYNOPSIS

       /usr/lib/sa/sa2

DESCRIPTION

       The  sa2  command  is  a shell procedure variant of the sar command which writes a daily report in the /var/log/sa/sardd file, where the dd
       parameter indicates the current day. The sa2 command handles all of the flags and parameters of the sar command.

       The sa2 command is designed to be started automatically by the cron command.

EXAMPLES

       To run the sa2 command daily, place the following entry in your root or adm crontab file:

       5 19 * * 1-5 /usr/lib/sa/sa2 -A &

       This will generate a daily report called /var/log/sa/sardd It will also remove reports more than one week old.

FILES

       /var/log/sa/sardd
	      Indicate the daily report file, where the dd parameter is a number representing the day of the month.

AUTHOR

       Sebastien Godard <sebastien.godard@wanadoo.fr>

SEE ALSO

       sar(1), sadc(8), sa1(8), mpstat(1), iostat(1), vmstat(8)

       http://perso.wanadoo.fr/sebastien.godard/

Linux								   DECEMBER 1999							    SA2(8)