#!/bin/sh
# $Header: hot_database_backup_proxy.sh,v 1.3 2003/09/11 21:27:32 $
#
#bcpyrght
#***************************************************************************
#* $VRTScprght: Copyright 1993 - 2005 VERITAS Software Corporation, All Rights Reserved $ *
#***************************************************************************
#ecpyrght
#
# ---------------------------------------------------------------------------
#  			hot_database_backup_proxy.sh
# ---------------------------------------------------------------------------
#  This script uses Recovery Manager to take a hot (inconsistent) database
#  backup. A hot backup is inconsistent because portions of the database are
#  being modified and written to the disk while the backup is progressing.
#  You must run your database in ARCHIVELOG mode to make hot backups. It is
#  assumed that this script will be executed by user root. In order for RMAN
#  to work properly we switch user (su -) to the oracle dba account before
#  execution. If this script runs under a user account that has Oracle dba
#  privilege, it will be executed using this user's account.
# ---------------------------------------------------------------------------

# ---------------------------------------------------------------------------
# Determine the user which is executing this script.
# ---------------------------------------------------------------------------
 
CUSER=`id |cut -d"(" -f2 | cut -d ")" -f1`
 
# ---------------------------------------------------------------------------
# Put output in <this file name>.out. Change as desired.
# Note: output directory requires write permission.
# ---------------------------------------------------------------------------

# 20060418
SYSDATE=`date +'%Y%m%d%H%M'`
## PRGDIR=`dirname`
PRGDIR="/opt/oracle/admin/TIAEEG/script/nbu/"
BASENAME=`basename ${0}`
FILENAME="`/usr/ucb/echo -n $BASENAME | cut -f1 -d'.'`"
RMAN_LOG_FILE="$PRGDIR/../../log/nbu/$FILENAME"_"$SYSDATE.log"

# ---------------------------------------------------------------------------
# You may want to delete the output file so that backup information does
# not accumulate.  If not, delete the following lines.
# ---------------------------------------------------------------------------

if [ -f "$RMAN_LOG_FILE" ]
then
	rm -f "$RMAN_LOG_FILE"
fi

# -----------------------------------------------------------------
# Initialize the log file.
# -----------------------------------------------------------------
 
echo >> $RMAN_LOG_FILE
chmod 666 $RMAN_LOG_FILE
 
# ---------------------------------------------------------------------------
# Log the start of this script.
# ---------------------------------------------------------------------------
 
echo Script $0 >> $RMAN_LOG_FILE
echo ==== started on `date` ==== >> $RMAN_LOG_FILE
echo >> $RMAN_LOG_FILE

# ---------------------------------------------------------------------------
# Replace /db/oracle/product/ora81, below, with the Oracle home path.
# ---------------------------------------------------------------------------

ORACLE_HOME=/opt/oracle/product/10.1.0/db_1

# ---------------------------------------------------------------------------
# Replace ora81, below, with the Oracle SID of the target database.
# ---------------------------------------------------------------------------

ORACLE_SID=TIAEEG01
export ORACLE_SID

# ---------------------------------------------------------------------------
# Replace ora81, below, with the Oracle DBA user id (account).
# ---------------------------------------------------------------------------

ORACLE_USER=oracle10

# ---------------------------------------------------------------------------
# Set the target connect string.
# Replace "sys/manager", below, with the target connect string.
# ---------------------------------------------------------------------------

TARGET_CONNECT_STR=/

# ---------------------------------------------------------------------------
# Set the Oracle Recovery Manager name.
# ---------------------------------------------------------------------------

RMAN=$ORACLE_HOME/bin/rman

# ---------------------------------------------------------------------------
# Replace the value of the following variable:
#
#       NB_ORA_PC_STREAMS - specifies the number of parallel backup streams
#                           to be started.
# ---------------------------------------------------------------------------

NB_ORA_PC_STREAMS=1

# ---------------------------------------------------------------------------
# Print out the value of the variables set by this script.
# ---------------------------------------------------------------------------

echo >> $RMAN_LOG_FILE
echo   "RMAN: $RMAN" >> $RMAN_LOG_FILE
echo   "ORACLE_SID: $ORACLE_SID" >> $RMAN_LOG_FILE
echo   "ORACLE_USER: $ORACLE_USER" >> $RMAN_LOG_FILE
echo   "ORACLE_HOME: $ORACLE_HOME" >> $RMAN_LOG_FILE
echo   "NB_ORA_SCRIPTS: $NB_ORA_SCRIPTS" >> $RMAN_LOG_FILE
echo   "NB_ORA_PC_STREAMS: $NB_ORA_PC_STREAMS" >> $RMAN_LOG_FILE

# ---------------------------------------------------------------------------
# Print out the value of the variables passed from the server by bphdb.
# ---------------------------------------------------------------------------

echo >> $RMAN_LOG_FILE
echo   "NB_ORA_SERV: $NB_ORA_SERV" >> $RMAN_LOG_FILE
echo   "NB_ORA_POLICY: $NB_ORA_POLICY" >> $RMAN_LOG_FILE
echo   "NB_ORA_PC_SCHED: $NB_ORA_PC_SCHED" >> $RMAN_LOG_FILE

# ---------------------------------------------------------------------------
# This script assumes that the database is properly opened. If desired,
# this would be the place to verify that.
# ---------------------------------------------------------------------------

echo >> $RMAN_LOG_FILE
 
# ---------------------------------------------------------------------------
# Call Recovery Manager to initiate the backup. This example does not use a
# Recovery Catalog. If you choose to use one, replace the option 'nocatalog'
# from the rman command line below and with the
# 'rcvcat <userid>/<passwd>@<tns alias>' statement.
#
# Use the send command on the command line to send NBU policy, schedule name 
# and the number of the backup streams to be used in the database proxy backup. 
# ---------------------------------------------------------------------------
#
#  Backs up the whole database using proxy copy feature.
#
#  For proxy backups the number of parallel jobs is controlled by
#  the variable, NB_ORA_STREAMS, specified earlier in this example.
#
#  Note that the controlfiles and archivelogs are not backed up using proxy
#  copy method. Rman will initiate non-proxy copy sessions to backup the
#  controlfile and archivelogs.
#
#
#  The scenario assumes:
#     o you want to backup datafiles using proxy copy method.
#     o you wish to include offline datafiles, and read-only tablespaces,
#       in the backup
#     o you want the backup to continue if any files are inaccessible.
#     o you are not using a Recovery Catalog
#     o you are explicitly backing up the control file.  Since you are 
#       specifying nocatalog, the controlfile backup that occurs 
#       automatically as the result of backing up the system file is 
#       not sufficient; it will not contain records for the backup that
#       is currently in progress.
#     o you want to archive the current log, back up all the
#       archive logs using two channels, putting a maximum of 20 logs
#       in a backup set, and deleting them once the backup is complete.
#
#  Note that the format string is constructed to guarantee uniqueness and
#  to enhance NetBackup for Oracle backup and restore performance.
#
#  NOTE WHEN USING TNS ALIAS: When connecting to a database
#  using a TNS alias, you must use a send command or a parms operand to 
#  specify environment variables.  In other words, when accessing a database
#  through a listener, the environment variables set at the system level are not 
#  visible when RMAN is running.  For more information on the environment
#  variables, please refer to the NetBackup for Oracle Admin. Guide.
#
# ---------------------------------------------------------------------------

CMD_STR1="
ORACLE_HOME=$ORACLE_HOME
export ORACLE_HOME
ORACLE_SID=$ORACLE_SID
export ORACLE_SID
$RMAN target $TARGET_CONNECT_STR nocatalog send \"'NB_ORA_POLICY=$NB_ORA_POLICY, NB_ORA_PC_SCHED=$NB_ORA_PC_SCHED, NB_ORA_PC_STREAMS=$NB_ORA_PC_STREAMS'\"  msglog $RMAN_LOG_FILE append << EOF
RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
BACKUP
    #PROXY
    SKIP INACCESSIBLE
    TAG hot_db_bk_proxy
    # recommended format
    FORMAT 'TIAEEG_dbf_%s_%p_%t'
    DATABASE;
    sql 'alter system archive log current';
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
}
EOF
"

CMD_STR2="
ORACLE_HOME=$ORACLE_HOME
export ORACLE_HOME
ORACLE_SID=$ORACLE_SID
export ORACLE_SID
$RMAN target $TARGET_CONNECT_STR nocatalog send \"'NB_ORA_POLICY=$NB_ORA_POLICY, NB_ORA_PC_SCHED=$NB_ORA_PC_SCHED, NB_ORA_PC_STREAMS=$NB_ORA_PC_STREAMS'\"  msglog $RMAN_LOG_FILE append << EOF
RUN {
# CROSSCHECK ARCHIVELOG ALL;
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
BACKUP
   FILESPERSET 20
   FORMAT 'TIAEEG_ArchiveLog_%s_%p_%t'
   ARCHIVELOG ALL;
   # ARCHIVELOG ALL DELETE INPUT;
   DELETE NOPROMPT COPY OF ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-1';
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
# Backup Controlfile
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
BACKUP
    # recommended format
    FORMAT 'TIAEEG_cntrl_%s_%p_%t'
    CURRENT CONTROLFILE;
    sql 'alter database backup controlfile to trace';
RELEASE CHANNEL ch00;
}
EOF
"

# Initiate the command string
 
if [ "$CUSER" = "root" ]
then
    su - $ORACLE_USER -c "$CMD_STR1" >> $RMAN_LOG_FILE
    su - $ORACLE_USER -c "$CMD_STR2" >> $RMAN_LOG_FILE
    RSTAT=$?
else
    /usr/bin/sh -c "$CMD_STR1" >> $RMAN_LOG_FILE
    /usr/bin/sh -c "$CMD_STR2" >> $RMAN_LOG_FILE
    RSTAT=$?
fi
 
# ---------------------------------------------------------------------------
# Log the completion of this script.
# ---------------------------------------------------------------------------
 
if [ "$RSTAT" = "0" ]
then
    LOGMSG="ended successfully"
else
    LOGMSG="ended in error"
fi
 
echo >> $RMAN_LOG_FILE
echo Script $0 >> $RMAN_LOG_FILE
echo ==== $LOGMSG on `date` ==== >> $RMAN_LOG_FILE
echo >> $RMAN_LOG_FILE
 
exit $RSTAT