一共两个脚本
生成脚本:dba_oracle_awr.sh
调用脚本:awr_everyday.sh
#!/usr/bin/bash
# ********************************
# * dba_oracle_awr.sh
# ********************************
# Usage: dba_oracle_awr.sh -s [instance_name]
# -f [from time]
# -t [to time]
# -p [report type, html or text]
# -h [oracle home]
# -n [tns admin]
#
# time format: 'yyyymmddhh24miss'.
# E.g 20110304170000 means 05:00:00pm, Mar 04, 2011
#
#
# **********************
# get parameters
# **********************
while getopts ":s:f:t:p:h:n" opt
do
case $opt in
s) instance=$OPTARG
;;
f) from=$OPTARG
;;
t) to=$OPTARG
;;
p) type=$OPTARG
type=$(echo $type|tr "[:upper:]" "[:lower:]")
;;
h) oracle_home=$OPTARG
;;
n) tns_admin=$OPTARG
;;
'?') echo "$0: invalid option -$OPTARG">&2
exit 1
;;
esac
done
if [ "$instance" =