oracle检查备份,oracle 备份,表空间检查shell脚本代码

#!/bin/ksh

#****************************************************************************

#

# (C) Copyright CPIC. 2008

#

# File name:    check_db_alert.sh

# Project:      Database Alerts Check

#

# Parameter : app_name -- name of db application(=oracle_sid)

#         ipaddress -- ip of the db server

#

# Creation Date:        Aug 19, 2008

# Origin Author:        Shangkun Peng

#

#

# Prerequisites:

# before using this shell script, directory $DAILY_CHECK must be created

# and this shell script should be put into it.

# for each application, environment file $DBENVFILE must be put into it.

# also, variables for auto ftp must be set

#

# Limitations:

# this shell script can be run at most once an hour

# additional job can be added but variable JOB_LIST must be modified

# and relative function must be coded too

#

#****************************************************************************

# record start date and time

echo "------------------------------------------------------------"

echo "database information collect started at:"; date

# check necessary parameter(s)

if [ $# -ne 2 ]

then

echo "ERROR: parameter(s) not supplied correctly"

echo "USAGE: check_db_alert.sh app_name ipaddress"

echo "WHERE:"

echo "app_name -- name of db application"

echo "ipaddress -- ip of the db server"

exit 1

fi

# -----------------------------------------------------------------------------------------------------------

# DEFINE VALUES FOR VARIABLES IN THIS SHELL

# general variables, can not be modified

APP_NAME=$1     # name of db application

IPADDRESS=$2     # ip of db server

DAILY_CHECK=/tmp/db_dailycheck   # directory for information collection of db application

DBENVFILE=$APP_NAME".dbenv"&