RMAN BACKUP SCRIPT

# set environment

. $HOME/.bash_profile

export ORACLE_SID=TWINTMP

export ORAENV_ASK=NO

. $ORACLE_HOME/bin/oraenv

export USER=dbadmin

export PASSWD=brownbag6

export RMAN_HOME=/backup/TWINTMP

export RMAN_LIST_SFX=`date '+_%y%m%d_%H%M%S'`.log

export BACKUP_DEST=/backup/TWINTMP

######################################################################

# Backup database to disk backup set (rman).

######################################################################

 echo running rman TARGET $USER/$PASSWD LOG $RMAN_HOME/rman_data_bkup_$RMAN_LIST_SFX

$ORACLE_HOME/bin/rman TARGET $USER/$PASSWD LOG $RMAN_HOME/rman_data_bkup_$RMAN_LIST_SFX  <<EOF

show all;

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT = '$RMAN_HOME/rman_bkup_TWINTMP%U' MAXPIECESIZE 2G;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '$RMAN_HOME/rman_bkup_TWINTMP%F';

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '$RMAN_HOME/snapcf_TWINTMP.f';

LIST BACKUP;

DELETE NOPROMPT BACKUP TAG TWINTMP_weekly_bkup_test;

CROSSCHECK BACKUP;

BACKUP DATABASE TAG TWINTMP_weekly_bkup_test;

REPORT SCHEMA;

LIST BACKUP;

EOF