When performing backup testing, you want to start a script, grab some food and some drinks, pretent to be busy and gather results when the script is done.
In this post I will share the script I use to perform backup testing. You can/should change this script so it alligns with your environment. You can specify the channels being used etc. Understand the script before you use it 🙂
#!/bin/bash
DB="YOUR_DB_HERE"
looptimes=1 # how many times to run a backup
MOUNT_POINT="YOUR_MOUNT_POINT_HERE"
. bdenv -d $DB
export TNS_ADMIN=<do this if you need to>
export NLS_DATE_FORMAT="DD.MM.YYYY HH24:MI:SS"
RMAN_TMP_FILE="rman_stmt.temp"
LOGFILE="log/rman_backuplog.$$.log"
RESULT_CSV="test_results.csv"
function setup_config(){
echo "\
run {
sql 'alter system archive log current';
sql 'alter system set \"_backup_disk_bufcnt\"=64 scope=memory';
sql 'alter system set \"_backup_file_bufcnt\"=64 scope=memory';
sql 'alter system set \"_backup_disk_bufsz\"=1048576 scope=memory';
sql 'alter system set \"_backup_file_bufsz\"=1048576 scope=memory';\
" >> $RMAN_TMP_FILE
}
function configure_channels(){
echo "\
allocate channel bck_chan1 type disk format '${MOUNT_POINT}/channel1/${DB}/inst_1_1_Lev_zero_%Y%M%D_%U';
allocate channel bck_chan2 type disk format '${MOUNT_POINT}/channel2/${DB}/inst_1_1_Lev_zero_%Y%M%D_%U';
allocate channel bck_chan3 type disk format '${MOUNT_POINT}/channel3/${DB}/inst_1_1_Lev_zero_%Y%M%D_%U';
allocate channel bck_chan4 type disk format '${MOUNT_POINT}/channel4/${DB}/inst_1_1_Lev_zero_%Y%M%D_%U';
allocate channel bck_chan5 type disk format '${MOUNT_POINT}/channel5/${DB}/inst_1_1_Lev_zero_%Y%M%D_%U';
allocate channel bck_chan6 type disk format '${MOUNT_POINT}/channel6/${DB}/inst_1_1_Lev_zero_%Y%M%D_%U';
allocate channel bck_chan7 type disk format '${MOUNT_POINT}/channel7/${DB}/inst_1_1_Lev_zero_%Y%M%D_%U';
allocate channel bck_chan8 type disk format '${MOUNT_POINT}/channel8/${DB}/inst_1_1_Lev_zero_%Y%M%D_%U';
allocate channel bck_chan9 type disk format '${MOUNT_POINT}/channel9/${DB}/inst_1_1_Lev_zero_%Y%M%D_%U';
allocate channel bck_chan10 type disk format '${MOUNT_POINT}/channel10/${DB}/inst_1_1_Lev_zero_%Y%M%D_%U';
allocate channel bck_chan11 type disk format '${MOUNT_POINT}/channel11/${DB}/inst_1_1_Lev_zero_%Y%M%D_%U';
allocate channel bck_chan12 type disk format '${MOUNT_POINT}/channel12/${DB}/inst_1_1_Lev_zero_%Y%M%D_%U';
allocate channel bck_chan13 type disk format '${MOUNT_POINT}/channel13/${DB}/inst_1_1_Lev_zero_%Y%M%D_%U';
allocate channel bck_chan14 type disk format '${MOUNT_POINT}/channel14/${DB}/inst_1_1_Lev_zero_%Y%M%D_%U';
allocate channel bck_chan15 type disk format '${MOUNT_POINT}/channel15/${DB}/inst_1_1_Lev_zero_%Y%M%D_%U';
allocate channel bck_chan16 type disk format '${MOUNT_POINT}/channel16/${DB}/inst_1_1_Lev_zero_%Y%M%D_%U';\
" >> $RMAN_TMP_FILE
}
function add_backup_statement(){
echo "\
backup incremental level 0 section size 32g database filesperset 1 tag 'RMAN_level_zero' plus archivelog not backed up 2 times tag 'RMAN_level_zero_Archivelog';
backup current controlfile format '${MOUNT_POINT}/channel1/${DB}/control01_%Y_%M_%D_%U.ctl';
backup spfile format '${MOUNT_POINT}/channel1/${DB}/spfile_%Y_%M_%D_%U.ora';\
" >> $RMAN_TMP_FILE
}
function release_channels(){
echo "\
release channel bck_chan1;
release channel bck_chan2;
release channel bck_chan3;
release channel bck_chan4;
release channel bck_chan5;
release channel bck_chan6;
release channel bck_chan7;
release channel bck_chan8;
release channel bck_chan9;
release channel bck_chan10;
release channel bck_chan11;
release channel bck_chan12;
release channel bck_chan13;
release channel bck_chan14;
release channel bck_chan15;
release channel bck_chan16;\
" >> $RMAN_TMP_FILE
}
function add_maintenance(){
echo "\
crosscheck backup;
crosscheck archivelog all;
delete noprompt expired backup;
delete noprompt expired archivelog all;
delete noprompt backupset completed before 'sysdate-28';
delete noprompt archivelog all completed before 'sysdate-31';\
" >> $RMAN_TMP_FILE
}
function execute_rman(){
echo "}" >> $RMAN_TMP_FILE
rman log=${LOGFILE} << EOF
connect target /
show all;
@${RMAN_TMP_FILE}
exit
EOF
}
function main(){
rm -f $RMAN_TMP_FILE
touch $RMAN_TMP_FILE
setup_config
configure_channels
add_backup_statement
release_channels
execute_rman
}
function remove_all_backups(){
rm -f $RMAN_TMP_FILE
touch $RMAN_TMP_FILE
echo "run{
" >> $RMAN_TMP_FILE
configure_channels
echo "delete noprompt backup;" >> $RMAN_TMP_FILE
execute_rman
}
rm -f $LOGFILE
rm -f $RESULT_CSV
touch $LOGFILE
touch $RESULT_CSV
printf "\n==================================================================\n" | tee -a $LOGFILE
printf "Start: $$\nLogfile: $LOGFILE \nRMANFILE: $RMAN_TMP_FILE\n" | tee -a $LOGFILE
printf "==================================================================\n\n" | tee -a $LOGFILE
remove_all_backups
echo "BACKUP_RUN,BACKUP_INSTANCES,CHANNELS_PER_INSTANCE,NFS_VERS,DATABASE_SIZE,START_TIMESTAMP,START_EPOCH,END_TIMESTAMP,END_EPOCH,RUN_TIME_MINUTES" >> ${RESULT_CSV}
for ((i=1; i<=looptimes; i++)); do
printf "\n=======================================================\n" >> $LOGFILE
echo "Start backup run: $i" >> $LOGFILE
echo "Start backup: $(date)" >> $LOGFILE
printf "=======================================================\n" >> $LOGFILE
START_TIME=$(date +%s)
START_STAMP=$(date +"%d-%m-%Y %H:%M:%S")
main
END_TIME=$(date +%s)
END_STAMP=$(date +"%d-%m-%Y %H:%M:%S")
RUN_TIME=$(($END_TIME - $START_TIME))
MINUTES=$(( (RUN_TIME % 3600) / 60 ))
echo "${i},<INSTANCES>,<CHANNELS>,<NFS_VERS>,<YOUR GB>,${START_STAMP},${START_TIME},${END_STAMP},${END_TIME},${MINUTES}" >> ${RESULT_CSV}
printf "\n=======================================================\n" >> $LOGFILE
echo "End backup run: $i" >> $LOGFILE
printf "=======================================================\n" >> $LOGFILE
remove_all_backups
done
echo ""
printf "\n==================================================================\n" | tee -a $LOGFILE
printf "Logfile: $LOGFILE \nRMANFILE: $RMAN_TMP_FILE\n" | tee -a $LOGFILE
printf "==================================================================\n\n" | tee -a $LOGFILE