*******************************************************************************************
************* Set Date, Log, Folders with Variable Names *****************************
*******************************************************************************************
#!/bin/bash
DD=(date +%d%m%Y)
BACKUP_BASE_DIR=”/backup_immam/RMAN_DB_BACKUP”
BACKUP_DIR=”$BACKUP_BASE_DIR/DB_$DD”
mkdir -p $BACKUP_DIR
date > $BACKUP_DIR/RmanStarttime.txt
LOG_FILE=”$BACKUP_DIR/RMAN_DB_BACKUP_$(date +%d%m%Y).log”
*******************************************************************************************
**************************** Starting Log File ******************************************
*******************************************************************************************
echo ==== started on date ==== >> $LOG_FILE”
*******************************************************************************************
**************************** Starting RMAN BACKUP ***********************************
*******************************************************************************************
rman target / msglog $LOG_FILE << EOF
RUN {
ALLOCATE CHANNEL ch1 DEVICE TYPE disk FORMAT ‘$BACKUP_DIR/backup_%u_%s_%p_%T’;
BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;
RELEASE CHANNEL ch1;
BACKUP AS COPY CURRENT CONTROLFILE FORMAT ‘$BACKUP_DIR/controlfile_%u_%s_%p_%T’;
}
exit;
EOF
*******************************************************************************************
**************************** Ending RMAN BACKUP ***********************************
*******************************************************************************************
echo ==== Online Backup Ends on date ==== >> $LOG_FILE
date > $BACKUP_DIR/RmanStoptime.txt
*******************************************************************************************
**************************** Ending Log File ********************************************
*******************************************************************************************
exit
Comments
Tags: #woesofdba, DBAimmam, ImmamDBA, RMAN Backup, RMAN SCRIPT, RMAN SCRIPT TO MAKE BACKUP WITH DATES, woesOfDba