Script for V$flash_recovery_area_usage Post: 302529011

Sponsored Content

Top Forums Shell Programming and Scripting Script for V$flash_recovery_area_usage Post 302529011 by jnrpeardba on Wednesday 8th of June 2011 11:11:05 AM

06-08-2011

Registered User

Hi,

thanks and that is true what you say, and I was just using the ORA-600 as an example. But I wanted to be able to act on the Flash back area, if the disk was say 80% full.

Thanks

---------- Post updated at 04:11 PM ---------- Previous update was at 03:54 PM ----------

Hi,

does this make it easier?

When it generates an alert for Disk usage, I get an email like this

Code:

ADR Home = /u01/app/oracle/diag/rdbms/dctmprod/DCTMPROD1:
*************************************************************************
2011-06-07 08:36:24.865000 +01:00
Errors in file /u01/app/oracle/diag/rdbms/dctmprod/DCTMPROD1/trace/DCTMPROD1_m000_31563.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 10737418240 bytes is 97.17% used, and has 304087040 remaining bytes available.
2011-06-07 10:21:17.155000 +01:00
Errors in file /u01/app/oracle/diag/rdbms/dctmprod/DCTMPROD1/trace/DCTMPROD1_ora_17971.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 10737418240 bytes is 100.00% used, and has 0 remaining bytes available.

So in my script can I do something which only searches for ORA-19815 errors
On that line it displays the percentage - so if it is above 80% (threshold) then it can send an email.

Thanks again

Last edited by radoulov; 06-08-2011 at 12:34 PM.. Reason: Code tags.

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 OSX

instruments

instruments(1)						    BSD General Commands Manual 					    instruments(1)

NAME

     instruments, version 1.0

USAGE

     instruments [-t template] [-d document] [-l timeLimit] [-i #] [-w device] [[-p pid] | [-a application [-e variable value] [-g argument]]]

DESCRIPTION

     Runs an Instruments template from the command line.

     Options are :

     -t template
	      The path to the template to run

     -s       Show list of known templates and exit

     -d document
	      The path to save the trace document data to (This may already exist, in which case a new Run will be added)

     -l #     The limit of milliseconds to record until termination ( infinite is default )

     -i #     The index of the instrument to apply the following target data to ( default if missing )

     -p pid   The ID of the process to attach to

     -a application
	      The path to the application or command to launch

     -w hardware device
	      The identifier of the hardware to target

     -e variable value
	      An environment variable setting (You may specify more than one)

     -g argument
	      Command line argument to be sent to the launched process (You may specify more than one)

     -v       Turn on verbose logging

FILES

     /usr/bin/instruments			   Executable

SEE ALSO

     /Developer/Applications/Instruments.app may be used to perform trace executions in a graphical environment and may also be used to open trace
     documents created in either instruments or Instruments.app.

EXAMPLES

     instruments -t mytemplate -a myapp.app

Mac OS								   June 2, 2019 							    Mac OS