Enterprise Workloads Editions: ✅ Business | ✅ Enterprise | ✅ Elite
Druva provides template shell scripts for Linux and Solaris RMAN hosts that you can use to back up databases. The scripts are:
phoenix_get_mount_details.sh: This script provides the details of the backup mount and the Phoenix Backup Store. Use this script to get the location of the backup mount so that you can map it to the RMAN host.oracle_rman_data_backup.sh: This script runs RMAN commands that perform incremental merge backup of databases, archive log backups, and store the backup on the backup mount. You can modify the script to modify RMAN parameters.oracle_rman_archivelog_backup.sh: This script runs RMAN commands that back up archived log files on Linux RMAN hosts, create an Oracle RMAN backup for archived logs, and store it on the backup mount. You can modify the script to modify RMAN parameters.oracle_rman_data_backup_solaris: This script runs RMAN commands that back up data files on Solaris RMAN hosts, create an Oracle RMAN backup, and store it on the backup mount. You can modify the script to modify RMAN parameters.oracle_rman_archivelog_backup_solaris: This script runs RMAN commands that back up archived log files on Solaris RMAN hosts, create an Oracle RMAN backup for archived logs, and store it on the backup mount. You can modify the script to modify RMAN parameters.
Druva provides the following scripts to enhance the backup performance and also provides extended recovery windows locally on PBS:
oracle_rman_data_full_merge_weekly_backup.sh: This script recovers and applies incremental backup set copies to the full image base copies of the backup. You can schedule this script to run on crontab based on the recovery window. For example, if the recovery window is set to 7 days, this script can be scheduled to run every week and the incremental backup pieces will be applied to the full image copies once every week.oracle_rman_data_incremental_daily_backup.sh: This script backs up only incremental backups without performing recovery operations. You can schedule this script to run daily and ensure a recovery window from local PBS up to 7 days or based on the rman retention set for recovery window.📝 Note
The recovery window resets once the full merge script is run and hence you cannot recover your database from PBS to older backups that were backed up in the previous week.
The following sections provide the contents of the shell scripts. You can edit these scripts to suit your requirements.
Template scripts for Phoenix Backup Store with version 4.9.1 or later
❗ Important
Druva requires you to use the following template scripts for Phoenix Backup Store with version 4.9.1 or later.
phoenix_get_mount_details.sh
#!/bin/bash
if [ "$#" -ne 2 ]; then
echo ""
echo "Usage: $0 <backup_store_IP> <backup_mount_name>"
echo ""
echo " <backup_store_IP> : IP address of the Phoenix Backup Store"
echo " <backup_mount_name> : Name of the backup mount configured in Phoenix, e.g. mount1"
exit 1
fi
BACKUP_STORE_IP=$1
BACKUP_MOUNT=$2
res=$(curl -X POST http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/backup 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to start phoenix backup failed... exiting"
echo "Response from Phoenix Backup Store: "$res
exit 1
fi
# Sample output format
# {"error_code":4295622665,"error_msg":"Backup mount does not exist on Export Service.","result":{"mount_name":"mount4","mount_path":""}}
ERROR_CODE=$(echo $res|awk -F "error_code" '{print $2}' | cut -d ':' -f2|cut -d ',' -f1)
if [ $ERROR_CODE -ne 0 ];
then
echo "Response from Phoenix Backup Store: "$res
echo "Error getting mount details... exiting"
exit 1
fi
REMOTE_MOUNTPOINT=$BACKUP_STORE_IP:$(echo $res|awk -F "mount_path" '{print $2}'|cut -d '"' -f3)
echo ""
echo "Remote mountpath is $REMOTE_MOUNTPOINT"
MOUNT_OPTS=$(echo $res|awk -F "mount_params" '{print $2}'|cut -d '{' -f2|cut -d '}' -f1)
echo "Mount options : rw,user,$MOUNT_OPTS"
oracle_rman_data_backup.sh
#!/bin/bash
if [ "$#" -ne 2 ]; then
echo ""
echo "Usage: $0 <backup_store_IP> <backup_mount_name>"
echo ""
echo " <backup_store_IP> : IP address of the Phoenix Backup Store"
echo " <backup_mount_name> : Name of the backup mount configured in Phoenix, e.g. mount1"
exit 1
fi
BACKUP_STORE_IP=$1
BACKUP_MOUNT=$2
PARALLELISM=1
if [[ -z "${ORACLE_HOME}" ]];
then
echo "Environment variable ORACLE_HOME not set... exiting"
exit 1
fi
if [[ -z "${ORACLE_SID}" ]];
then
echo "Environment variable ORACLE_SID not set... exiting"
exit 1
fi
SID=${ORACLE_SID}
echo "Validating backup request"
validate_resp=$(curl -X GET http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/1.2/backup 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to validate phoenix backup failed... exiting"
echo "Response from Phoenix Backup Store: "$validate_resp
exit 1
fi
VALIDATE_ERROR_CODE=$(echo $validate_resp|awk -F "error_code" '{print $2}' | cut -d ':' -f2|cut -d ',' -f1)
if [ $VALIDATE_ERROR_CODE -ne 0 ];
then
echo "Response from Phoenix Backup Store: "$validate_resp
echo "Request to validate Phoenix backup failed... exiting"
exit 1
fi
# Sample output format
# {"error_code":0,"error_msg":"","result":{"is_reached_max_snapshots":false,"mount_name":"m2"}}
IS_REACHED_MAX_SNAPSHOTS=$(echo $validate_resp|awk -F "is_reached_max_snapshots" '{print $2}'|cut -d ',' -f1 |cut -d ':' -f2)
if [ $IS_REACHED_MAX_SNAPSHOTS == "false" ];
then
echo "Validation for phoenix backup succeeded"
else
echo "Response from Phoenix Backup Store: "$validate_resp
echo "Validation for phoenix backup failed... exiting"
exit 1
fi
echo "Notifying Phoenix to start backup - Phoenix Backup Store=$BACKUP_STORE_IP mount name=$BACKUP_MOUNT"
#res=$(curl -X POST http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/$SID/full/backup 2> /dev/null)
res=$(curl -X POST http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/backup 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to start phoenix backup failed... exiting"
echo "Response from Phoenix Backup Store: "$res
exit 1
fi
# Sample output format
# {"error_code":4295622665,"error_msg":"Backup mount does not exist on Export Service.","result":{"mount_name":"mount4","mount_path":""}}
ERROR_CODE=$(echo $res|awk -F "error_code" '{print $2}' | cut -d ':' -f2|cut -d ',' -f1)
if [ $ERROR_CODE -ne 0 ];
then
echo "Response from Phoenix Backup Store: "$res
echo "Request to start Phoenix backup failed... exiting"
exit 1
fi
REMOTE_MOUNTPOINT=$BACKUP_STORE_IP:$(echo $res|awk -F "mount_path" '{print $2}'|cut -d '"' -f3)
RMANBACKUP_MOUNTPOINT=$(grep "^$REMOTE_MOUNTPOINT" /etc/fstab| sed 's/\s\+/ /g' |cut -d ' ' -f2)
if [ -z "$RMANBACKUP_MOUNTPOINT" ];
then
echo "Entry for Phoenix Backup Store mount not found in /etc/fstab... exiting"
exit 1
fi
ACTUAL_MOUNTPOINT=$(mount|grep "^$REMOTE_MOUNTPOINT"|sed 's/\s\+/ /g' |cut -d " " -f3 2> /dev/null)
if [ -z "$ACTUAL_MOUNTPOINT" ];
then
mount $RMANBACKUP_MOUNTPOINT 2> /dev/null
if [ $? -ne 0 ];
then
echo "Unable to mount $RMANBACKUP_MOUNTPOINT... exiting"
exit 1
fi
else
RMANBACKUP_MOUNTPOINT=$ACTUAL_MOUNTPOINT
fi
export PATH=$ORACLE_HOME/bin:$PATH
full_backup () {
echo "Creating Dir $RMANBACKUP_MOUNTPOINT/$SID'/full'"
if [ ! -e $RMANBACKUP_MOUNTPOINT/$SID'/full' ]
then
mkdir -p $RMANBACKUP_MOUNTPOINT/$SID'/full'
if [ $? -eq 0 ];
then
echo "Created directory for full backup $RMANBACKUP_MOUNTPOINT/$SID/full"
else
echo "Oracle user does not have permission for $RMANBACKUP_MOUNTPOINT directory... exiting"
exit 1
fi
elif [ ! -d $RMANBACKUP_MOUNTPOINT/${SID}'/full' ];
then
echo "$RMANBACKUP_MOUNTPOINT is not a directory... exiting"
exit 1
fi
#Creating Archivelog Directory
if [ ! -e $RMANBACKUP_MOUNTPOINT/${SID}'/archivelogs' ]
then
mkdir -p $RMANBACKUP_MOUNTPOINT/${SID}'/archivelogs'
if [ $? -eq 0 ];
then
echo "Created directory for archivelogs backup $RMANBACKUP_MOUNTPOINT/$SID/archivelogs"
else
echo "Oracle user does not have permission for $RMANBACKUP_MOUNTPOINT directory... exiting"
exit 1
fi
elif [ ! -d $RMANBACKUP_MOUNTPOINT/${SID}'/archivelogs' ];
then
echo "$RMANBACKUP_MOUNTPOINT is not a directory... exiting"
exit 1
fi
LOG_FILE_DIR=$RMANBACKUP_MOUNTPOINT/'_workspace/RMAN_Logs'
echo "Creating Log File Dir: =$RMANBACKUP_MOUNTPOINT'/_workspace/RMAN_Logs'"
if [ ! -e $LOG_FILE_DIR ]
then
mkdir -p $LOG_FILE_DIR
if [ $? -eq 0 ];
then
echo "Created log directory for oracle backup $LOG_FILE_DIR"
else
echo "Oracle user does not have permission for $LOG_FILE_DIR directory... exiting"
exit 1
fi
fi
RMANBACKUP_MOUNTPOINT_FULL=$RMANBACKUP_MOUNTPOINT/$SID
#echo -n >$LOG_FILE_DIR'/rman_full_backup_'${SNAPSHOT_NAME}'.log'
touch $RMANBACKUP_MOUNTPOINT/_workspace/
if [ $? -ne 0 ];
then
echo "$RMANBACKUP_MOUNTPOINT directory is not writable.. exiting"
exit 1
fi
#Checking if any .lock file is present and deleting the same if the PID is NOT running.
is_lock_file_present=`find ${RMANBACKUP_MOUNTPOINT} -type f -name ".RMAN_FULL_lock_*"|wc -l `
if [[ ${is_lock_file_present} -ne 0 ]]
then
for _lock_file in `find ${RMANBACKUP_MOUNTPOINT} -type f -name ".RMAN_FULL_lock_*" | xargs `
do
_pid=`echo ${_lock_file}|cut -d"_" -f4`
is_pid_proc_running=`ps -ef|grep ${_pid}|grep -v grep | wc -l`
if [[ ${is_pid_proc_running} -ne 0 ]]
then
echo "[INFO] Full backup Lock File: ${_lock_file} is present and PID is active"
else
echo "[INFO] Full backup Lock File: ${_lock_file} is present and PID is NOT active"
echo "Deleting ${_lock_file}"
rm ${_lock_file}
if [ -e ${_lock_file} ]
then
echo "ERROR deleting file ${_lock_file}"
fi
fi
done
fi
# Creating a .lock file to represnt current active full/diff backup.
export file_stamp=`date | sed -e 's/ /_/g'`
PID=`echo $$`
LOCK_FILE=`echo ${RMANBACKUP_MOUNTPOINT}/.RMAN_FULL_lock_${PID}_${file_stamp}`
echo -n > ${LOCK_FILE}
if [ -e ${LOCK_FILE} ]
then
echo "[INFO] Lock file created: ${LOCK_FILE}"
else
echo "Error creating lock file: ${LOCK_FILE}"
echo "[ERROR] Backup will now stop"
exit -3
fi
echo "Starting with RMAN backup"
#Calling Start RMAN Backup
res_rmanbackup=$(curl -X POST http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/${SID}/full/rmanbackup 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to start phoenix backup failed... exiting"
echo "Response from Phoenix Backup Store: "$res_rmanbackup
exit 1
fi
echo "Response RMAN Backup: ${res_rmanbackup}"
SNAPSHOT_NAME=`echo $res_rmanbackup|awk -F "snap_name" '{print $2}'|cut -d '"' -f3`
if [ -z "$SNAPSHOT_NAME" ];
then
echo "Failed to get Snapshot name. Exiting. Please check Export Service Logs in PBS"
exit 1
fi
echo "Snapshot to be created ${SNAPSHOT_NAME}"
echo -n >$LOG_FILE_DIR'/rman_full_backup_'${SNAPSHOT_NAME}_${ORACLE_SID}'.log'
RMAN_LOGFILE=$LOG_FILE_DIR'/rman_full_backup_'${SNAPSHOT_NAME}_${ORACLE_SID}'.log'
echo "RMAN Logfile: ${RMAN_LOGFILE}"
rman log=$LOG_FILE_DIR'/rman_full_backup_'${SNAPSHOT_NAME}_${ORACLE_SID}'.log' 2> /dev/null << EOF
connect target /
set echo on;
configure backup optimization on;
configure controlfile autobackup on;
configure device type disk parallelism $PARALLELISM BACKUP TYPE TO COPY;
configure datafile backup copies for device type disk to 1;
configure archivelog backup copies for device type disk to 1;
configure channel device type disk format '${RMANBACKUP_MOUNTPOINT_FULL}/full/datafile_%U.bkp';
configure controlfile autobackup format for device type disk to '${RMANBACKUP_MOUNTPOINT_FULL}/full/full_controlfile_%d_%F.bkp';
run
{
sql 'alter system archive log current';
backup incremental level 1 for recover of copy with tag 'phoenix_oracle_backup' database;
recover copy of database with tag 'phoenix_oracle_backup';
sql 'alter system archive log current';
backup as backupset format '${RMANBACKUP_MOUNTPOINT_FULL}/archivelogs/%d_%h_%e_%s_%t.arc' archivelog all not backed up;
#Force is to ignore I/O errors
delete noprompt obsolete device type disk;
delete force NOPROMPT expired copy;
delete force NOPROMPT expired backup;
crosscheck backup;
crosscheck copy;
}
configure backup optimization clear;
configure controlfile autobackup clear;
exit
EOF
RMAN_EXIT_STATUS=$?
if [ $RMAN_EXIT_STATUS -ne 0 ];
then
echo ""
echo "rman failed with status $RMAN_EXIT_STATUS.. exiting"
rm ${LOCK_FILE}
if [ -e ${LOCK_FILE} ]
then
echo "[ERROR] Could NOT delete Lock file: ${LOCK_FILE}"
else
dt=`date | sed -e 's/ /_/g'`
echo "[INFO] Lock file deleted: ${LOCK_FILE} at ${dt} "
fi
exit 1
fi
echo "RMAN log location: $LOG_FILE_DIR/rman_full_backup_${SNAPSHOT_NAME}_${ORACLE_SID}.log"
echo "Notifying Phoenix to upload RMAN Logs"
rman_uploadlog_res=$(curl -X POST -H "Content-Type: multipart/form-data" -F "file=@$LOG_FILE_DIR/rman_full_backup_${SNAPSHOT_NAME}_${ORACLE_SID}.log" -F mountpoint=$RMANBACKUP_MOUNTPOINT -F platform=linux http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/uploadlog 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to send RMAN Logs failed..."
echo "Response from Phoenix Backup Store: "$rman_uploadlog_res
fi
rm ${LOCK_FILE}
if [ -e ${LOCK_FILE} ]
then
echo "[ERROR] Could NOT delete Lock file: ${LOCK_FILE}"
else
dt=`date | sed -e 's/ /_/g'`
echo "[INFO] Lock file deleted: ${LOCK_FILE} at ${dt} "
fi
echo "Notifying Phoenix to end backup"
final_res=$(curl -X PUT http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/backup 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to end phoenix backup failed... exiting"
echo "Response from Phoenix Backup Store: "$final_res
rm ${LOCK_FILE}
if [ -e ${LOCK_FILE} ]
then
echo "[ERROR] Could NOT delete Lock file: ${LOCK_FILE}"
else
dt=`date | sed -e 's/ /_/g'`
echo "[INFO] Lock file deleted: ${LOCK_FILE} at ${dt} "
fi
exit 1
fi
ERROR_CODE=$(echo $final_res|awk -F "error_code" '{print $2}' | cut -d ':' -f2|cut -d ',' -f1)
if [ $ERROR_CODE -ne 0 ];
then
echo "Response from Phoenix Backup Store: "$final_res
echo "Request to End Phoenix backup failed... exiting"
fi
echo $final_res
echo "Exiting with successful status"
}
# Main
full_backup
oracle_rman_archivelog_backup.sh
#!/bin/bash
if [ "$#" -ne 2 ]; then
echo ""
echo "Usage: $0 <backup_store_IP> <backup_mount_name>"
echo ""
echo " <backup_store_IP> : IP address of the Phoenix Backup Store"
echo " <backup_mount_name> : Name of the backup mount configured in Phoenix, e.g. mount1"
exit 1
fi
BACKUP_STORE_IP=$1
BACKUP_MOUNT=$2
PARALLELISM=1
if [[ -z "${ORACLE_HOME}" ]];
then
echo "Environment variable ORACLE_HOME not set... exiting"
exit 1
fi
if [[ -z "${ORACLE_SID}" ]];
then
echo "Environment variable ORACLE_SID not set... exiting"
exit 1
fi
SID=${ORACLE_SID}
echo "Validating backup request"
validate_resp=$(curl -X GET http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/1.2/backup 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to validate phoenix backup failed... exiting"
echo "Response from Phoenix Backup Store: "$validate_resp
exit 1
fi
VALIDATE_ERROR_CODE=$(echo $validate_resp|awk -F "error_code" '{print $2}' | cut -d ':' -f2|cut -d ',' -f1)
if [ $VALIDATE_ERROR_CODE -ne 0 ];
then
echo "Response from Phoenix Backup Store: "$validate_resp
echo "Request to validate Phoenix backup failed... exiting"
exit 1
fi
# Sample output format
# {"error_code":0,"error_msg":"","result":{"is_reached_max_snapshots":false,"mount_name":"m2"}}
IS_REACHED_MAX_SNAPSHOTS=$(echo $validate_resp|awk -F "is_reached_max_snapshots" '{print $2}'|cut -d ',' -f1 |cut -d ':' -f2)
if [ $IS_REACHED_MAX_SNAPSHOTS == "false" ];
then
echo "Validation for phoenix backup succeeded"
else
echo "Response from Phoenix Backup Store: "$validate_resp
echo "Validation for phoenix backup failed... exiting"
exit 1
fi
echo "Notifying Phoenix to start backup - Phoenix Backup Store=$BACKUP_STORE_IP mount name=$BACKUP_MOUNT"
res=$(curl -X POST http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/backup 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to start phoenix backup failed... exiting"
echo "Response from Phoenix Backup Store: "$res
exit 1
fi
# Sample output format
# {"error_code":4295622665,"error_msg":"Backup mount does not exist on Export Service.","result":{"mount_name":"mount4","mount_path":""}}
ERROR_CODE=$(echo $res|awk -F "error_code" '{print $2}' | cut -d ':' -f2|cut -d ',' -f1)
if [ $ERROR_CODE -ne 0 ];
then
echo "Response from Phoenix Backup Store: "$res
echo "Request to start Phoenix backup failed... exiting"
exit 1
fi
REMOTE_MOUNTPOINT=$BACKUP_STORE_IP:$(echo $res|awk -F "mount_path" '{print $2}'|cut -d '"' -f3)
RMANBACKUP_MOUNTPOINT=$(grep "^$REMOTE_MOUNTPOINT" /etc/fstab| sed 's/\s\+/ /g' |cut -d ' ' -f2)
if [ -z "$RMANBACKUP_MOUNTPOINT" ];
then
echo "Entry for Phoenix Backup Store mount not found in /etc/fstab... exiting"
exit 1
fi
ACTUAL_MOUNTPOINT=$(mount|grep "^$REMOTE_MOUNTPOINT"|sed 's/\s\+/ /g' |cut -d " " -f3 2> /dev/null)
if [ -z "$ACTUAL_MOUNTPOINT" ];
then
mount $RMANBACKUP_MOUNTPOINT 2> /dev/null
if [ $? -ne 0 ];
then
echo "Unable to mount $RMANBACKUP_MOUNTPOINT... exiting"
exit 1
fi
else
RMANBACKUP_MOUNTPOINT=$ACTUAL_MOUNTPOINT
fi
export PATH=$ORACLE_HOME/bin:$PATH
arch_backup () {
if [ ! -e $RMANBACKUP_MOUNTPOINT/$SID'/archivelogs' ]
then
mkdir -p $RMANBACKUP_MOUNTPOINT/$SID'/archivelogs'
if [ $? -eq 0 ];
then
echo "Created directory for archivelogs backup $RMANBACKUP_MOUNTPOINT/$SID/archivelogs"
else
echo "Oracle user does not have permission for $RMANBACKUP_MOUNTPOINT/$SID directory... exiting"
exit 1
fi
elif [ ! -d $RMANBACKUP_MOUNTPOINT/$SID'/archivelogs' ];
then
echo "$RMANBACKUP_MOUNTPOINT/$SID is not a directory... exiting"
fi
LOG_FILE_DIR=$RMANBACKUP_MOUNTPOINT/'_workspace/RMAN_Logs'
echo "Creating Log File Dir: =$RMANBACKUP_MOUNTPOINT'/_workspace/RMAN_Logs'"
if [ ! -e $LOG_FILE_DIR ]
then
mkdir -p $LOG_FILE_DIR
if [ $? -eq 0 ];
then
echo "Created log directory for oracle backup $LOG_FILE_DIR"
else
echo "Oracle user does not have permission for $LOG_FILE_DIR directory... exiting"
exit 1
fi
fi
echo -n >$LOG_FILE_DIR'/archivelogs_backup.log'
touch $RMANBACKUP_MOUNTPOINT/_workspace/
if [ $? -ne 0 ];
then
echo "$RMANBACKUP_MOUNTPOINT directory is not writable.. exiting"
exit 1
fi
# Checking if any of the Full/Diff backup is currently running and PID is active.
# In this case, we will fail/skip the current Log backup.
# Next trigger (external) of this script will retry log backup.
#LOCK_FILE=`echo ${RMANBACKUP_MOUNTPOINT}/.RMAN_FULL_lock_${PID}_${file_stamp}`
is_lock_file_present=`find ${RMANBACKUP_MOUNTPOINT} -type f -name ".RMAN_FULL_lock_*"|wc -l `
export BKP_CONTINUE=0
if [[ ${is_lock_file_present} -ne 0 ]]
then
for _lock_file in `find ${RMANBACKUP_MOUNTPOINT} -type f -name ".RMAN_FULL_lock_*" | xargs `
do
_pid=`echo ${_lock_file}|cut -d"_" -f4`
is_pid_proc_running=`ps -ef|grep ${_pid}|grep -v grep | wc -l`
if [[ ${is_pid_proc_running} -ne 0 ]]
then
echo "[INFO] Full backup Lock File: ${_lock_file} is present and PID is active"
export BKP_CONTINUE=1
else
echo "[INFO] Full backup Lock File: ${_lock_file} is present and PID is NOT active"
echo "Deleting ${_lock_file}"
rm ${_lock_file}
if [ -e ${_lock_file} ]
then
echo "ERROR deleting file ${_lock_file}"
echo "Exiting Log backup"
export BKP_CONTINUE=1
fi
fi
done
if [[ ${BKP_CONTINUE} -eq 1 ]]
then
echo "[WARNING] There is full backup running or the lock file for Full/diff backup is present"
echo "[ERROR] Exiting the current Log backup"
exit 5
fi
fi
echo "Starting with RMAN backup"
RMANBACKUP_MOUNTPOINT_FULL=$RMANBACKUP_MOUNTPOINT/$SID
#Calling Start RMAN Backup
res_rmanbackup=$(curl -X POST http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/${SID}/archivelog/rmanbackup 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to start phoenix backup failed... exiting"
echo "Response from Phoenix Backup Store: "$res_rmanbackup
exit 1
fi
echo "Response RMAN Backup: ${res_rmanbackup}"
SNAPSHOT_NAME=`echo $res_rmanbackup|awk -F "snap_name" '{print $2}'|cut -d '"' -f3`
if [ -z "$SNAPSHOT_NAME" ];
then
echo "Failed to get Snapshot name. Exiting. Please check Export Service Logs in PBS"
exit 1
fi
echo "Snapshot to be created ${SNAPSHOT_NAME}"
echo -n >$LOG_FILE_DIR'/rman_archivelog_backup_'${SNAPSHOT_NAME}_${ORACLE_SID}'.log'
RMAN_LOGFILE=$LOG_FILE_DIR'/rman_archivelog_backup_'${SNAPSHOT_NAME}_${ORACLE_SID}'.log'
echo "RMAN Logfile: ${RMAN_LOGFILE}"
rman log=$LOG_FILE_DIR'/rman_archivelog_backup_'${SNAPSHOT_NAME}_${ORACLE_SID}'.log' 2> /dev/null << EOF
connect target /
set echo on;
configure backup optimization on;
configure controlfile autobackup on;
configure device type disk parallelism ${PARALLELISM} BACKUP TYPE TO COPY;
configure datafile backup copies for device type disk to 1;
configure archivelog backup copies for device type disk to 1;
configure controlfile autobackup format for device type disk to '${RMANBACKUP_MOUNTPOINT_FULL}/archivelogs/arch_controlfile_%d_%F.bkp';
run
{
sql 'alter system archive log current';
backup as backupset format '${RMANBACKUP_MOUNTPOINT_FULL}/archivelogs/%d_%h_%e_%s_%t.arc' archivelog all not backed up;
#Force is to ignore I/O errors
delete noprompt obsolete device type disk;
delete force NOPROMPT expired copy;
delete force NOPROMPT expired backup;
crosscheck backup;
crosscheck copy;
}
configure backup optimization clear;
configure controlfile autobackup clear;
exit
EOF
RMAN_EXIT_STATUS=$?
if [ $RMAN_EXIT_STATUS -ne 0 ];
then
echo ""
echo "rman failed with status $RMAN_EXIT_STATUS.. exiting"
exit 1
fi
echo ""
echo "Notifying Phoenix to upload RMAN Logs"
rman_uploadlog_res=$(curl -X POST -H "Content-Type: multipart/form-data" -F "file=@$LOG_FILE_DIR/rman_archivelog_backup_${SNAPSHOT_NAME}_${ORACLE_SID}.log" -F mountpoint=$RMANBACKUP_MOUNTPOINT -F platform=linux http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/uploadlog 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to send RMAN Logs failed..."
echo "Response from Phoenix Backup Store: "$rman_uploadlog_res
fi
echo "Notifying Phoenix to end backup"
final_res=$(curl -X PUT http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/backup 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to end phoenix backup failed... exiting"
echo "Response from Phoenix Backup Store: "$final_res
exit 1
fi
ERROR_CODE=$(echo $final_res|awk -F "error_code" '{print $2}' | cut -d ':' -f2|cut -d ',' -f1)
if [ $ERROR_CODE -ne 0 ];
then
echo "Response from Phoenix Backup Store: "$final_res
echo "Request to start Phoenix backup failed... exiting"
fi
echo $final_res
echo "Exiting with successful status"
}
# Main
arch_backup
oracle_rman_data_backup_Solaris.sh
#!/bin/bash
if [ "$#" -ne 2 ]; then
echo ""
echo "Usage: $0 <backup_store_IP> <backup_mount_name>"
echo ""
echo " <backup_store_IP> : IP address of the Phoenix Backup Store"
echo " <backup_mount_name> : Name of the backup mount configured in Phoenix, e.g. mount1"
exit 1
fi
BACKUP_STORE_IP=$1
BACKUP_MOUNT=$2
PARALLELISM=1
if [[ -z "${ORACLE_HOME}" ]];
then
echo "Environment variable ORACLE_HOME not set... exiting"
exit 1
fi
if [[ -z "${ORACLE_SID}" ]];
then
echo "Environment variable ORACLE_SID not set... exiting"
exit 1
fi
SID=${ORACLE_SID}
echo "Validating backup request"
validate_resp=$(curl -X GET http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/1.2/backup 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to validate phoenix backup failed... exiting"
echo "Response from Phoenix Backup Store: "$validate_resp
exit 1
fi
VALIDATE_ERROR_CODE=$(echo $validate_resp|/usr/xpg4/bin/awk -F "error_code" '{print $2}' | cut -d ':' -f2|cut -d ',' -f1)
if [ $VALIDATE_ERROR_CODE -ne 0 ];
then
echo "Response from Phoenix Backup Store: "$validate_resp
echo "Request to validate Phoenix backup failed... exiting"
exit 1
fi
# Sample output format
# {"error_code":0,"error_msg":"","result":{"is_reached_max_snapshots":false,"mount_name":"m2"}}
IS_REACHED_MAX_SNAPSHOTS=$(echo $validate_resp|/usr/xpg4/bin/awk -F "is_reached_max_snapshots" '{print $2}'|cut -d ',' -f1 |cut -d ':' -f2)
if [ $IS_REACHED_MAX_SNAPSHOTS == "false" ];
then
echo "Validation for phoenix backup succeeded"
else
echo "Response from Phoenix Backup Store: "$validate_resp
echo "Validation for phoenix backup failed... exiting"
exit 1
fi
echo "Notifying Phoenix to start backup - Phoenix Backup Store=$BACKUP_STORE_IP mount name=$BACKUP_MOUNT"
res=$(curl -X POST http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/backup 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to start phoenix backup failed... exiting"
echo "Response from Phoenix Backup Store: "$res
exit 1
fi
# Sample output format
# {"error_code":4295622665,"error_msg":"Backup mount does not exist on Export Service.","result":{"mount_name":"mount4","mount_path":""}}
ERROR_CODE=$(echo $res|/usr/xpg4/bin/awk -F "error_code" '{print $2}' | cut -d ':' -f2|cut -d ',' -f1)
if [ $ERROR_CODE -ne 0 ];
then
echo "Response from Phoenix Backup Store: "$res
echo "Request to start Phoenix backup failed... exiting"
exit 1
fi
REMOTE_MOUNTPOINT=$BACKUP_STORE_IP:$(echo $res|/usr/xpg4/bin/awk -F "mount_path" '{print $2}'|cut -d '"' -f3)
RMANBACKUP_MOUNTPOINT=$(grep "^$REMOTE_MOUNTPOINT" /etc/vfstab| sed 's/\s\+/ /g' |cut -d ' ' -f3)
if [ -z "$RMANBACKUP_MOUNTPOINT" ];
then
echo "Entry for Phoenix Backup Store mount not found in /etc/vfstab... exiting"
exit 1
fi
ACTUAL_MOUNTPOINT=$(mount|grep -w "$REMOTE_MOUNTPOINT"| cut -d" " -f1 |head -1|sed 's/\s\+/ /g' 2>/dev/null)
if [ -z "$ACTUAL_MOUNTPOINT" ];
then
mount $RMANBACKUP_MOUNTPOINT 2> /dev/null
if [ $? -ne 0 ];
then
echo "Unable to mount $RMANBACKUP_MOUNTPOINT... exiting"
exit 1
fi
else
RMANBACKUP_MOUNTPOINT=$ACTUAL_MOUNTPOINT
fi
export PATH=$ORACLE_HOME/bin:$PATH
full_backup () {
#Creating full backup directory
echo "Creating Dir $RMANBACKUP_MOUNTPOINT/$SID'/full'"
if [ ! -e $RMANBACKUP_MOUNTPOINT/$SID'/full' ]
then
mkdir -p $RMANBACKUP_MOUNTPOINT/$SID'/full'
if [ $? -eq 0 ];
then
echo "Created directory for full backup $RMANBACKUP_MOUNTPOINT/$SID/full"
else
echo "Oracle user does not have permission for $RMANBACKUP_MOUNTPOINT directory... exiting"
exit 1
fi
elif [ ! -d $RMANBACKUP_MOUNTPOINT/${SID}'/full' ];
then
echo "$RMANBACKUP_MOUNTPOINT is not a directory... exiting"
exit 1
fi
#Creating Archivelog Directory
if [ ! -e $RMANBACKUP_MOUNTPOINT/${SID}'/archivelogs' ]
then
mkdir -p $RMANBACKUP_MOUNTPOINT/${SID}'/archivelogs'
if [ $? -eq 0 ];
then
echo "Created directory for archivelogs backup $RMANBACKUP_MOUNTPOINT/$SID/archivelogs"
else
echo "Oracle user does not have permission for $RMANBACKUP_MOUNTPOINT directory... exiting"
exit 1
fi
elif [ ! -d $RMANBACKUP_MOUNTPOINT/${SID}'/archivelogs' ];
then
echo "$RMANBACKUP_MOUNTPOINT is not a directory... exiting"
exit 1
fi
LOG_FILE_DIR=$RMANBACKUP_MOUNTPOINT/'_workspace/RMAN_Logs'
echo "Creating Log File Dir: =$RMANBACKUP_MOUNTPOINT'/_workspace/RMAN_Logs'"
if [ ! -e $LOG_FILE_DIR ]
then
mkdir -p $LOG_FILE_DIR
if [ $? -eq 0 ];
then
echo "Created log directory for oracle backup $LOG_FILE_DIR"
else
echo "Oracle user does not have permission for $LOG_FILE_DIR directory... exiting"
exit 1
fi
fi
echo -n >$LOG_FILE_DIR'/rman_full_backup_${ORACLE_SID}.log'
touch $RMANBACKUP_MOUNTPOINT/_workspace/
if [ $? -ne 0 ];
then
echo "$RMANBACKUP_MOUNTPOINT directory is not writable.. exiting"
exit 1
fi
#Checking if any .lock file is present and deleting the same if the PID is NOT running.
is_lock_file_present=`find ${RMANBACKUP_MOUNTPOINT} -type f -name ".RMAN_FULL_lock_*"|wc -l `
if [[ ${is_lock_file_present} -ne 0 ]]
then
for _lock_file in `find ${RMANBACKUP_MOUNTPOINT} -type f -name ".RMAN_FULL_lock_*" | xargs `
do
_pid=`echo ${_lock_file}|cut -d"_" -f4`
is_pid_proc_running=`ps -ef|grep ${_pid}|grep -v grep | wc -l`
if [[ ${is_pid_proc_running} -ne 0 ]]
then
echo "[INFO] Full backup Lock File: ${_lock_file} is present and PID is active."
echo "[ERROR] One Full backup is already in progress with process ${_pid}. Exiting current backup"
exit 1
else
echo "[INFO] Full backup Lock File: ${_lock_file} is present and PID is NOT active"
echo "Deleting ${_lock_file}"
rm ${_lock_file}
if [ -e ${_lock_file} ]
then
echo "ERROR deleting file ${_lock_file}"
fi
fi
done
fi
# Creating a .lock file to represnt current active full/diff backup.
export file_stamp=`date | sed -e 's/ /_/g'`
PID=`echo $$`
LOCK_FILE=`echo ${RMANBACKUP_MOUNTPOINT}/.RMAN_FULL_lock_${PID}_${file_stamp}`
echo -n > ${LOCK_FILE}
if [ -e ${LOCK_FILE} ]
then
echo "[INFO] Lock file created: ${LOCK_FILE}"
else
echo "Error creating lock file: ${LOCK_FILE}"
echo "[ERROR] Backup will now stop"
exit -3
fi
echo "Starting with RMAN backup"
RMANBACKUP_MOUNTPOINT_FULL=$RMANBACKUP_MOUNTPOINT/$SID
#Calling Start RMAN Backup
res_rmanbackup=$(curl -X POST http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/${SID}/full/rmanbackup 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to start phoenix backup failed... exiting"
echo "Response from Phoenix Backup Store: "$res_rmanbackup
exit 1
fi
echo "Response RMAN Backup: ${res_rmanbackup}"
SNAPSHOT_NAME=`echo $res_rmanbackup|/usr/xpg4/bin/awk -F "snap_name" '{print $2}'|cut -d '"' -f3`
if [ -z "$SNAPSHOT_NAME" ];
then
echo "Failed to get Snapshot name. Exiting. Please check Export Service Logs in PBS"
exit 1
fi
echo "Snapshot to be created ${SNAPSHOT_NAME}"
echo -n >$LOG_FILE_DIR'/rman_full_backup_'${SNAPSHOT_NAME}_${ORACLE_SID}'.log'
RMAN_LOGFILE=$LOG_FILE_DIR'/rman_full_backup_'${SNAPSHOT_NAME}_${ORACLE_SID}'.log'
echo "RMAN Logfile: ${RMAN_LOGFILE}"
rman log=$LOG_FILE_DIR'/rman_full_backup_'${SNAPSHOT_NAME}_${ORACLE_SID}'.log' 2> /dev/null << EOF
connect target /
set echo on;
configure backup optimization on;
configure controlfile autobackup on;
configure device type disk parallelism $PARALLELISM BACKUP TYPE TO COPY;
configure datafile backup copies for device type disk to 1;
configure archivelog backup copies for device type disk to 1;
configure channel device type disk format '$RMANBACKUP_MOUNTPOINT_FULL/full/datafile_%U.bkp';
configure controlfile autobackup format for device type disk to '$RMANBACKUP_MOUNTPOINT_FULL/full/full_controlfile_%d_%F';
run
{
sql 'alter system archive log current';
backup incremental level 1 for recover of copy with tag 'phoenix_oracle_backup' database;
recover copy of database with tag 'phoenix_oracle_backup';
sql 'alter system archive log current';
backup as backupset format '${RMANBACKUP_MOUNTPOINT_FULL}/archivelogs/%d_%h_%e_%s_%t.arc' archivelog all not backed up;
#Force is to ignore I/O errors
delete noprompt obsolete device type disk;
delete force NOPROMPT expired copy;
delete force NOPROMPT expired backup;
crosscheck backup;
crosscheck copy;
}
configure backup optimization clear;
configure controlfile autobackup clear;
exit
EOF
RMAN_EXIT_STATUS=$?
if [ $RMAN_EXIT_STATUS -ne 0 ];
then
echo ""
echo "rman failed with status $RMAN_EXIT_STATUS.. exiting"
rm ${LOCK_FILE}
if [ -e ${LOCK_FILE} ]
then
echo "[ERROR] Could NOT delete Lock file: ${LOCK_FILE}"
else
dt=`date | sed -e 's/ /_/g'`
echo "[INFO] Lock file deleted: ${LOCK_FILE} at ${dt} "
fi
exit 1
fi
echo ""
echo "Notifying Phoenix to upload RMAN Logs"
rman_uploadlog_res=$(curl -X POST -H "Content-Type: multipart/form-data" -F "file=@$LOG_FILE_DIR/rman_full_backup_${SNAPSHOT_NAME}_${ORACLE_SID}.log" -F mountpoint=$RMANBACKUP_MOUNTPOINT -F platform=linux http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/uploadlog 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to send RMAN Logs failed..."
echo "Response from Phoenix Backup Store: "$rman_uploadlog_res
fi
rm ${LOCK_FILE}
if [ -e ${LOCK_FILE} ]
then
echo "[ERROR] Could NOT delete Lock file: ${LOCK_FILE}"
else
dt=`date | sed -e 's/ /_/g'`
echo "[INFO] Lock file deleted: ${LOCK_FILE} at ${dt} "
fi
echo "Notifying Phoenix to end backup"
final_res=$(curl -X PUT http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/backup 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to end phoenix backup failed... exiting"
echo "Response from Phoenix Backup Store: "$final_res
rm ${LOCK_FILE}
if [ -e ${LOCK_FILE} ]
then
echo "[ERROR] Could NOT delete Lock file: ${LOCK_FILE}"
else
dt=`date | sed -e 's/ /_/g'`
echo "[INFO] Lock file deleted: ${LOCK_FILE} at ${dt} "
fi
exit 1
fi
ERROR_CODE=$(echo $final_res|/usr/xpg4/bin/awk -F "error_code" '{print $2}' | cut -d ':' -f2|cut -d ',' -f1)
if [ $ERROR_CODE -ne 0 ];
then
echo "Response from Phoenix Backup Store: "$final_res
echo "Request to start Phoenix backup failed... exiting"
fi
echo $final_res
echo "Exiting with successful status"
}
# Main
full_backup
oracle_rman_archivelog_backup_Solaris.sh
#!/bin/bash
if [ "$#" -ne 2 ]; then
echo ""
echo "Usage: $0 <backup_store_IP> <backup_mount_name>"
echo ""
echo " <backup_store_IP> : IP address of the Phoenix Backup Store"
echo " <backup_mount_name> : Name of the backup mount configured in Phoenix, e.g. mount1"
exit 1
fi
BACKUP_STORE_IP=$1
BACKUP_MOUNT=$2
PARALLELISM=1
if [[ -z "${ORACLE_HOME}" ]];
then
echo "Environment variable ORACLE_HOME not set... exiting"
exit 1
fi
if [[ -z "${ORACLE_SID}" ]];
then
echo "Environment variable ORACLE_SID not set... exiting"
exit 1
fi
SID=${ORACLE_SID}
echo "Validating backup request"
validate_resp=$(curl -X GET http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/1.2/backup 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to validate phoenix backup failed... exiting"
echo "Response from Phoenix Backup Store: "$validate_resp
exit 1
fi
VALIDATE_ERROR_CODE=$(echo $validate_resp|/usr/xpg4/bin/awk -F "error_code" '{print $2}' | cut -d ':' -f2|cut -d ',' -f1)
if [ $VALIDATE_ERROR_CODE -ne 0 ];
then
echo "Response from Phoenix Backup Store: "$validate_resp
echo "Request to validate Phoenix backup failed... exiting"
exit 1
fi
# Sample output format
# {"error_code":0,"error_msg":"","result":{"is_reached_max_snapshots":false,"mount_name":"m2"}}
IS_REACHED_MAX_SNAPSHOTS=$(echo $validate_resp|/usr/xpg4/bin/awk -F "is_reached_max_snapshots" '{print $2}'|cut -d ',' -f1 |cut -d ':' -f2)
if [ $IS_REACHED_MAX_SNAPSHOTS == "false" ];
then
echo "Validation for phoenix backup succeeded"
else
echo "Response from Phoenix Backup Store: "$validate_resp
echo "Validation for phoenix backup failed... exiting"
exit 1
fi
echo "Notifying Phoenix to start backup - Phoenix Backup Store=$BACKUP_STORE_IP mount name=$BACKUP_MOUNT"
res=$(curl -X POST http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/backup 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to start phoenix backup failed... exiting"
echo "Response from Phoenix Backup Store: "$res
exit 1
fi
# Sample output format
# {"error_code":4295622665,"error_msg":"Backup mount does not exist on Export Service.","result":{"mount_name":"mount4","mount_path":""}}
ERROR_CODE=$(echo $res|/usr/xpg4/bin/awk -F "error_code" '{print $2}' | cut -d ':' -f2|cut -d ',' -f1)
if [ $ERROR_CODE -ne 0 ];
then
echo "Response from Phoenix Backup Store: "$res
echo "Request to start Phoenix backup failed... exiting"
exit 1
fi
REMOTE_MOUNTPOINT=$BACKUP_STORE_IP:$(echo $res|/usr/xpg4/bin/awk -F "mount_path" '{print $2}'|cut -d '"' -f3)
RMANBACKUP_MOUNTPOINT=$(grep "^$REMOTE_MOUNTPOINT" /etc/vfstab| sed 's/\s\+/ /g' |cut -d ' ' -f3)
if [ -z "$RMANBACKUP_MOUNTPOINT" ];
then
echo "Entry for Phoenix Backup Store mount not found in /etc/vfstab... exiting"
exit 1
fi
ACTUAL_MOUNTPOINT=$(mount|grep -w "$REMOTE_MOUNTPOINT"| cut -d" " -f1 |head -1|sed 's/\s\+/ /g' 2>/dev/null)
if [ -z "$ACTUAL_MOUNTPOINT" ];
then
mount $RMANBACKUP_MOUNTPOINT 2> /dev/null
if [ $? -ne 0 ];
then
echo "Unable to mount $RMANBACKUP_MOUNTPOINT... exiting"
exit 1
fi
else
RMANBACKUP_MOUNTPOINT=$ACTUAL_MOUNTPOINT
fi
export PATH=$ORACLE_HOME/bin:$PATH
arch_backup () {
if [ ! -e $RMANBACKUP_MOUNTPOINT/$SID'/archivelogs' ]
then
mkdir -p $RMANBACKUP_MOUNTPOINT/$SID'/archivelogs'
if [ $? -eq 0 ];
then
echo "Created directory for archivelogs backup $RMANBACKUP_MOUNTPOINT/$SID/archivelogs"
else
echo "Oracle user does not have permission for $RMANBACKUP_MOUNTPOINT/$SID directory... exiting"
exit 1
fi
elif [ ! -d $RMANBACKUP_MOUNTPOINT/$SID'/archivelogs' ];
then
echo "$RMANBACKUP_MOUNTPOINT/$SID is not a directory... exiting"
fi
LOG_FILE_DIR=$RMANBACKUP_MOUNTPOINT/'_workspace/RMAN_Logs'
echo "Creating Log File Dir: =$RMANBACKUP_MOUNTPOINT'/_workspace/RMAN_Logs'"
if [ ! -e $LOG_FILE_DIR ]
then
mkdir -p $LOG_FILE_DIR
if [ $? -eq 0 ];
then
echo "Created log directory for oracle backup $LOG_FILE_DIR"
else
echo "Oracle user does not have permission for $LOG_FILE_DIR directory... exiting"
exit 1
fi
fi
echo -n >$LOG_FILE_DIR'/archivelogs_backup_${ORACLE_SID}.log'
touch $RMANBACKUP_MOUNTPOINT/_workspace/
if [ $? -ne 0 ];
then
echo "$RMANBACKUP_MOUNTPOINT directory is not writable.. exiting"
exit 1
fi
# Checking if any of the Full/Diff backup is currently running and PID is active.
# In this case, we will fail/skip the current Log backup.
# Next trigger (external) of this script will retry log backup.
#LOCK_FILE=`echo ${RMANBACKUP_MOUNTPOINT}/.RMAN_FULL_lock_${PID}_${file_stamp}`
is_lock_file_present=`find ${RMANBACKUP_MOUNTPOINT} -type f -name ".RMAN_FULL_lock_*"|wc -l `
export BKP_CONTINUE=0
if [[ ${is_lock_file_present} -ne 0 ]]
then
for _lock_file in `find ${RMANBACKUP_MOUNTPOINT} -type f -name ".RMAN_FULL_lock_*" | xargs `
do
_pid=`echo ${_lock_file}|cut -d"_" -f4`
is_pid_proc_running=`ps -ef|grep ${_pid}|grep -v grep | wc -l`
if [[ ${is_pid_proc_running} -ne 0 ]]
then
echo "[INFO] Full backup Lock File: ${_lock_file} is present and PID is active"
export BKP_CONTINUE=1
else
echo "[INFO] Full backup Lock File: ${_lock_file} is present and PID is NOT active"
echo "Deleting ${_lock_file}"
rm ${_lock_file}
if [ -e ${_lock_file} ]
then
echo "ERROR deleting file ${_lock_file}"
echo "Exiting Log backup"
export BKP_CONTINUE=1
fi
fi
done
if [[ ${BKP_CONTINUE} -eq 1 ]]
then
echo "[WARNING] There is full backup running or the lock file for Full/diff backup is present"
echo "[ERROR] Exiting the current Log backup"
exit 5
fi
fi
echo "Starting with RMAN backup"
RMANBACKUP_MOUNTPOINT_FULL=$RMANBACKUP_MOUNTPOINT/$SID
#Calling Start RMAN Backup
res_rmanbackup=$(curl -X POST http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/${SID}/archivelog/rmanbackup 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to start phoenix backup failed... exiting"
echo "Response from Phoenix Backup Store: "$res_rmanbackup
exit 1
fi
echo "Response RMAN Backup: ${res_rmanbackup}"
SNAPSHOT_NAME=`echo $res_rmanbackup|/usr/xpg4/bin/awk -F "snap_name" '{print $2}'|cut -d '"' -f3`
if [ -z "$SNAPSHOT_NAME" ];
then
echo "Failed to get Snapshot name. Exiting. Please check Export Service Logs in PBS"
exit 1
fi
echo "Snapshot to be created ${SNAPSHOT_NAME}"
echo -n >$LOG_FILE_DIR'/rman_archivelog_backup_'${SNAPSHOT_NAME}_${ORACLE_SID}'.log'
RMAN_LOGFILE=$LOG_FILE_DIR'/rman_archivelog_backup_'${SNAPSHOT_NAME}_${ORACLE_SID}'.log'
echo "RMAN Logfile: ${RMAN_LOGFILE}"
rman log=$LOG_FILE_DIR'/rman_archivelog_backup_'${SNAPSHOT_NAME}_${ORACLE_SID}'.log' 2> /dev/null << EOF
connect target /
set echo on;
configure backup optimization on;
configure controlfile autobackup on;
configure device type disk parallelism ${PARALLELISM} BACKUP TYPE TO COPY;
configure datafile backup copies for device type disk to 1;
configure archivelog backup copies for device type disk to 1;
configure controlfile autobackup format for device type disk to '${RMANBACKUP_MOUNTPOINT_FULL}/archivelogs/arch_controlfile_%d_%F.bkp';
run
{
sql 'alter system archive log current';
backup as backupset format '${RMANBACKUP_MOUNTPOINT_FULL}/archivelogs/%d_%h_%e_%s_%t.arc' archivelog all not backed up;
#Force is to ignore I/O errors
delete noprompt obsolete device type disk;
delete force NOPROMPT expired copy;
delete force NOPROMPT expired backup;
crosscheck backup;
crosscheck copy;
}
configure backup optimization clear;
configure controlfile autobackup clear;
exit
EOF
RMAN_EXIT_STATUS=$?
if [ $RMAN_EXIT_STATUS -ne 0 ];
then
echo ""
echo "rman failed with status $RMAN_EXIT_STATUS.. exiting"
exit 1
fi
echo ""
echo "Notifying Phoenix to upload RMAN Logs"
rman_uploadlog_res=$(curl -X POST -H "Content-Type: multipart/form-data" -F "file=@$LOG_FILE_DIR/rman_archivelog_backup_${SNAPSHOT_NAME}_${ORACLE_SID}.log" -F mountpoint=$RMANBACKUP_MOUNTPOINT -F platform=linux http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/uploadlog 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to send RMAN Logs failed..."
echo "Response from Phoenix Backup Store: "$rman_uploadlog_res
fi
echo "Notifying Phoenix to end backup"
final_res=$(curl -X PUT http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/backup 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to end phoenix backup failed... exiting"
echo "Response from Phoenix Backup Store: "$final_res
exit 1
fi
ERROR_CODE=$(echo $final_res|/usr/xpg4/bin/awk -F "error_code" '{print $2}' | cut -d ':' -f2|cut -d ',' -f1)
if [ $ERROR_CODE -ne 0 ];
then
echo "Response from Phoenix Backup Store: "$final_res
echo "Request to start Phoenix backup failed... exiting"
fi
echo $final_res
echo "Exiting with successful status"
}
# Main
arch_backup
oracle_rman_data_full_merge_weekly_backup.sh
#!/bin/bash
if [ "$#" -ne 2 ]; then
echo ""
echo "Usage: $0 <backup_store_IP> <backup_mount_name>"
echo ""
echo " <backup_store_IP> : IP address of the Phoenix Backup Store"
echo " <backup_mount_name> : Name of the backup mount configured in Phoenix, e.g. mount1"
exit 1
fi
BACKUP_STORE_IP=$1
BACKUP_MOUNT=$2
PARALLELISM=1
if [[ -z "${ORACLE_HOME}" ]];
then
echo "Environment variable ORACLE_HOME not set... exiting"
exit 1
fi
if [[ -z "${ORACLE_SID}" ]];
then
echo "Environment variable ORACLE_SID not set... exiting"
exit 1
fi
SID=${ORACLE_SID}
echo "Validating backup request"
validate_resp=$(curl -X GET http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/1.2/backup 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to validate phoenix backup failed... exiting"
echo "Response from Phoenix Backup Store: "$validate_resp
exit 1
fi
VALIDATE_ERROR_CODE=$(echo $validate_resp|awk -F "error_code" '{print $2}' | cut -d ':' -f2|cut -d ',' -f1)
if [ $VALIDATE_ERROR_CODE -ne 0 ];
then
echo "Response from Phoenix Backup Store: "$validate_resp
echo "Request to validate Phoenix backup failed... exiting"
exit 1
fi
# Sample output format
# {"error_code":0,"error_msg":"","result":{"is_reached_max_snapshots":false,"mount_name":"m2"}}
IS_REACHED_MAX_SNAPSHOTS=$(echo $validate_resp|awk -F "is_reached_max_snapshots" '{print $2}'|cut -d ',' -f1 |cut -d ':' -f2)
if [ $IS_REACHED_MAX_SNAPSHOTS == "false" ];
then
echo "Validation for phoenix backup succeeded"
else
echo "Response from Phoenix Backup Store: "$validate_resp
echo "Validation for phoenix backup failed... exiting"
exit 1
fi
echo "Notifying Phoenix to start backup - Phoenix Backup Store=$BACKUP_STORE_IP mount name=$BACKUP_MOUNT"
#res=$(curl -X POST http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/$SID/full/backup 2> /dev/null)
res=$(curl -X POST http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/backup 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to start phoenix backup failed... exiting"
echo "Response from Phoenix Backup Store: "$res
exit 1
fi
# Sample output format
# {"error_code":4295622665,"error_msg":"Backup mount does not exist on Export Service.","result":{"mount_name":"mount4","mount_path":""}}
ERROR_CODE=$(echo $res|awk -F "error_code" '{print $2}' | cut -d ':' -f2|cut -d ',' -f1)
if [ $ERROR_CODE -ne 0 ];
then
echo "Response from Phoenix Backup Store: "$res
echo "Request to start Phoenix backup failed... exiting"
exit 1
fi
REMOTE_MOUNTPOINT=$BACKUP_STORE_IP:$(echo $res|awk -F "mount_path" '{print $2}'|cut -d '"' -f3)
RMANBACKUP_MOUNTPOINT=$(grep "^$REMOTE_MOUNTPOINT" /etc/fstab| sed 's/\s\+/ /g' |cut -d ' ' -f2)
if [ -z "$RMANBACKUP_MOUNTPOINT" ];
then
echo "Entry for Phoenix Backup Store mount not found in /etc/fstab... exiting"
exit 1
fi
ACTUAL_MOUNTPOINT=$(mount|grep "^$REMOTE_MOUNTPOINT"|sed 's/\s\+/ /g' |cut -d " " -f3 2> /dev/null)
if [ -z "$ACTUAL_MOUNTPOINT" ];
then
mount $RMANBACKUP_MOUNTPOINT 2> /dev/null
if [ $? -ne 0 ];
then
echo "Unable to mount $RMANBACKUP_MOUNTPOINT... exiting"
exit 1
fi
else
RMANBACKUP_MOUNTPOINT=$ACTUAL_MOUNTPOINT
fi
export PATH=$ORACLE_HOME/bin:$PATH
full_backup () {
echo "Creating Dir $RMANBACKUP_MOUNTPOINT/$SID'/full'"
if [ ! -e $RMANBACKUP_MOUNTPOINT/$SID'/full' ]
then
mkdir -p $RMANBACKUP_MOUNTPOINT/$SID'/full'
if [ $? -eq 0 ];
then
echo "Created directory for full backup $RMANBACKUP_MOUNTPOINT/$SID/full"
else
echo "Oracle user does not have permission for $RMANBACKUP_MOUNTPOINT directory... exiting"
exit 1
fi
elif [ ! -d $RMANBACKUP_MOUNTPOINT/${SID}'/full' ];
then
echo "$RMANBACKUP_MOUNTPOINT is not a directory... exiting"
exit 1
fi
#Creating Archivelog Directory
if [ ! -e $RMANBACKUP_MOUNTPOINT/${SID}'/archivelogs' ]
then
mkdir -p $RMANBACKUP_MOUNTPOINT/${SID}'/archivelogs'
if [ $? -eq 0 ];
then
echo "Created directory for archivelogs backup $RMANBACKUP_MOUNTPOINT/$SID/archivelogs"
else
echo "Oracle user does not have permission for $RMANBACKUP_MOUNTPOINT directory... exiting"
exit 1
fi
elif [ ! -d $RMANBACKUP_MOUNTPOINT/${SID}'/archivelogs' ];
then
echo "$RMANBACKUP_MOUNTPOINT is not a directory... exiting"
exit 1
fi
LOG_FILE_DIR=$RMANBACKUP_MOUNTPOINT/'_workspace/RMAN_Logs'
echo "Creating Log File Dir: =$RMANBACKUP_MOUNTPOINT'/_workspace/RMAN_Logs'"
if [ ! -e $LOG_FILE_DIR ]
then
mkdir -p $LOG_FILE_DIR
if [ $? -eq 0 ];
then
echo "Created log directory for oracle backup $LOG_FILE_DIR"
else
echo "Oracle user does not have permission for $LOG_FILE_DIR directory... exiting"
exit 1
fi
fi
RMANBACKUP_MOUNTPOINT_FULL=$RMANBACKUP_MOUNTPOINT/$SID
#echo -n >$LOG_FILE_DIR'/rman_full_backup_'${SNAPSHOT_NAME}'.log'
touch $RMANBACKUP_MOUNTPOINT/_workspace/
if [ $? -ne 0 ];
then
echo "$RMANBACKUP_MOUNTPOINT directory is not writable.. exiting"
exit 1
fi
#Checking if any .lock file is present and deleting the same if the PID is NOT running.
is_lock_file_present=`find ${RMANBACKUP_MOUNTPOINT} -type f -name ".RMAN_FULL_lock_*"|wc -l `
if [[ ${is_lock_file_present} -ne 0 ]]
then
for _lock_file in `find ${RMANBACKUP_MOUNTPOINT} -type f -name ".RMAN_FULL_lock_*" | xargs `
do
_pid=`echo ${_lock_file}|cut -d"_" -f4`
is_pid_proc_running=`ps -ef|grep ${_pid}|grep -v grep | wc -l`
if [[ ${is_pid_proc_running} -ne 0 ]]
then
echo "[INFO] Full backup Lock File: ${_lock_file} is present and PID is active"
else
echo "[INFO] Full backup Lock File: ${_lock_file} is present and PID is NOT active"
echo "Deleting ${_lock_file}"
rm ${_lock_file}
if [ -e ${_lock_file} ]
then
echo "ERROR deleting file ${_lock_file}"
fi
fi
done
fi
# Creating a .lock file to represnt current active full/diff backup.
export file_stamp=`date | sed -e 's/ /_/g'`
PID=`echo $$`
LOCK_FILE=`echo ${RMANBACKUP_MOUNTPOINT}/.RMAN_FULL_lock_${PID}_${file_stamp}`
echo -n > ${LOCK_FILE}
if [ -e ${LOCK_FILE} ]
then
echo "[INFO] Lock file created: ${LOCK_FILE}"
else
echo "Error creating lock file: ${LOCK_FILE}"
echo "[ERROR] Backup will now stop"
exit -3
fi
echo "Starting with RMAN backup"
#Calling Start RMAN Backup
res_rmanbackup=$(curl -X POST http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/${SID}/full/rmanbackup 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to start phoenix backup failed... exiting"
echo "Response from Phoenix Backup Store: "$res_rmanbackup
exit 1
fi
echo "Response RMAN Backup: ${res_rmanbackup}"
SNAPSHOT_NAME=`echo $res_rmanbackup|awk -F "snap_name" '{print $2}'|cut -d '"' -f3`
if [ -z "$SNAPSHOT_NAME" ];
then
echo "Failed to get Snapshot name. Exiting. Please check Export Service Logs in PBS"
exit 1
fi
echo "Snapshot to be created ${SNAPSHOT_NAME}"
echo -n >$LOG_FILE_DIR'/rman_full_backup_'${SNAPSHOT_NAME}_${ORACLE_SID}'.log'
RMAN_LOGFILE=$LOG_FILE_DIR'/rman_full_backup_'${SNAPSHOT_NAME}_${ORACLE_SID}'.log'
echo "RMAN Logfile: ${RMAN_LOGFILE}"
rman log=$LOG_FILE_DIR'/rman_full_backup_'${SNAPSHOT_NAME}_${ORACLE_SID}'.log' 2> /dev/null << EOF
connect target /
set echo on;
configure backup optimization on;
configure controlfile autobackup on;
configure device type disk parallelism $PARALLELISM BACKUP TYPE TO COPY;
configure datafile backup copies for device type disk to 1;
configure archivelog backup copies for device type disk to 1;
configure channel device type disk format '${RMANBACKUP_MOUNTPOINT_FULL}/full/datafile_%U.bkp';
configure controlfile autobackup format for device type disk to '${RMANBACKUP_MOUNTPOINT_FULL}/full/full_controlfile_%d_%F.bkp';
run
{
sql 'alter system archive log current';
recover copy of database with tag 'phoenix_oracle_backup';
backup incremental level 1 for recover of copy with tag 'phoenix_oracle_backup' database;
sql 'alter system archive log current';
backup as backupset format '${RMANBACKUP_MOUNTPOINT_FULL}/archivelogs/%d_%h_%e_%s_%t.arc' archivelog all not backed up;
#Force is to ignore I/O errors
delete noprompt obsolete device type disk;
delete force NOPROMPT expired copy;
delete force NOPROMPT expired backup;
crosscheck backup;
crosscheck copy;
}
configure backup optimization clear;
configure controlfile autobackup clear;
exit
EOF
RMAN_EXIT_STATUS=$?
if [ $RMAN_EXIT_STATUS -ne 0 ];
then
echo ""
echo "rman failed with status $RMAN_EXIT_STATUS.. exiting"
rm ${LOCK_FILE}
if [ -e ${LOCK_FILE} ]
then
echo "[ERROR] Could NOT delete Lock file: ${LOCK_FILE}"
else
dt=`date | sed -e 's/ /_/g'`
echo "[INFO] Lock file deleted: ${LOCK_FILE} at ${dt} "
fi
exit 1
fi
echo "RMAN log location: $LOG_FILE_DIR/rman_full_backup_${SNAPSHOT_NAME}_${ORACLE_SID}.log"
echo "Notifying Phoenix to upload RMAN Logs"
rman_uploadlog_res=$(curl -X POST -H "Content-Type: multipart/form-data" -F "file=@$LOG_FILE_DIR/rman_full_backup_${SNAPSHOT_NAME}_${ORACLE_SID}.log" -F mountpoint=$RMANBACKUP_MOUNTPOINT -F platform=linux http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/uploadlog 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to send RMAN Logs failed..."
echo "Response from Phoenix Backup Store: "$rman_uploadlog_res
fi
rm ${LOCK_FILE}
if [ -e ${LOCK_FILE} ]
then
echo "[ERROR] Could NOT delete Lock file: ${LOCK_FILE}"
else
dt=`date | sed -e 's/ /_/g'`
echo "[INFO] Lock file deleted: ${LOCK_FILE} at ${dt} "
fi
echo "Notifying Phoenix to end backup"
final_res=$(curl -X PUT http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/backup 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to end phoenix backup failed... exiting"
echo "Response from Phoenix Backup Store: "$final_res
rm ${LOCK_FILE}
if [ -e ${LOCK_FILE} ]
then
echo "[ERROR] Could NOT delete Lock file: ${LOCK_FILE}"
else
dt=`date | sed -e 's/ /_/g'`
echo "[INFO] Lock file deleted: ${LOCK_FILE} at ${dt} "
fi
exit 1
fi
ERROR_CODE=$(echo $final_res|awk -F "error_code" '{print $2}' | cut -d ':' -f2|cut -d ',' -f1)
if [ $ERROR_CODE -ne 0 ];
then
echo "Response from Phoenix Backup Store: "$final_res
echo "Request to End Phoenix backup failed... exiting"
fi
echo $final_res
echo "Exiting with successful status"
}
# Main
full_backup
oracle_rman_data_incremental_daily_backup.sh
#!/bin/bash
if [ "$#" -ne 2 ]; then
echo ""
echo "Usage: $0 <backup_store_IP> <backup_mount_name>"
echo ""
echo " <backup_store_IP> : IP address of the Phoenix Backup Store"
echo " <backup_mount_name> : Name of the backup mount configured in Phoenix, e.g. mount1"
exit 1
fi
BACKUP_STORE_IP=$1
BACKUP_MOUNT=$2
PARALLELISM=1
if [[ -z "${ORACLE_HOME}" ]];
then
echo "Environment variable ORACLE_HOME not set... exiting"
exit 1
fi
if [[ -z "${ORACLE_SID}" ]];
then
echo "Environment variable ORACLE_SID not set... exiting"
exit 1
fi
SID=${ORACLE_SID}
echo "Validating backup request"
validate_resp=$(curl -X GET http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/1.2/backup 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to validate phoenix backup failed... exiting"
echo "Response from Phoenix Backup Store: "$validate_resp
exit 1
fi
VALIDATE_ERROR_CODE=$(echo $validate_resp|awk -F "error_code" '{print $2}' | cut -d ':' -f2|cut -d ',' -f1)
if [ $VALIDATE_ERROR_CODE -ne 0 ];
then
echo "Response from Phoenix Backup Store: "$validate_resp
echo "Request to validate Phoenix backup failed... exiting"
exit 1
fi
# Sample output format
# {"error_code":0,"error_msg":"","result":{"is_reached_max_snapshots":false,"mount_name":"m2"}}
IS_REACHED_MAX_SNAPSHOTS=$(echo $validate_resp|awk -F "is_reached_max_snapshots" '{print $2}'|cut -d ',' -f1 |cut -d ':' -f2)
if [ $IS_REACHED_MAX_SNAPSHOTS == "false" ];
then
echo "Validation for phoenix backup succeeded"
else
echo "Response from Phoenix Backup Store: "$validate_resp
echo "Validation for phoenix backup failed... exiting"
exit 1
fi
echo "Notifying Phoenix to start backup - Phoenix Backup Store=$BACKUP_STORE_IP mount name=$BACKUP_MOUNT"
#res=$(curl -X POST http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/$SID/full/backup 2> /dev/null)
res=$(curl -X POST http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/backup 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to start phoenix backup failed... exiting"
echo "Response from Phoenix Backup Store: "$res
exit 1
fi
# Sample output format
# {"error_code":4295622665,"error_msg":"Backup mount does not exist on Export Service.","result":{"mount_name":"mount4","mount_path":""}}
ERROR_CODE=$(echo $res|awk -F "error_code" '{print $2}' | cut -d ':' -f2|cut -d ',' -f1)
if [ $ERROR_CODE -ne 0 ];
then
echo "Response from Phoenix Backup Store: "$res
echo "Request to start Phoenix backup failed... exiting"
exit 1
fi
REMOTE_MOUNTPOINT=$BACKUP_STORE_IP:$(echo $res|awk -F "mount_path" '{print $2}'|cut -d '"' -f3)
RMANBACKUP_MOUNTPOINT=$(grep "^$REMOTE_MOUNTPOINT" /etc/fstab| sed 's/\s\+/ /g' |cut -d ' ' -f2)
if [ -z "$RMANBACKUP_MOUNTPOINT" ];
then
echo "Entry for Phoenix Backup Store mount not found in /etc/fstab... exiting"
exit 1
fi
ACTUAL_MOUNTPOINT=$(mount|grep "^$REMOTE_MOUNTPOINT"|sed 's/\s\+/ /g' |cut -d " " -f3 2> /dev/null)
if [ -z "$ACTUAL_MOUNTPOINT" ];
then
mount $RMANBACKUP_MOUNTPOINT 2> /dev/null
if [ $? -ne 0 ];
then
echo "Unable to mount $RMANBACKUP_MOUNTPOINT... exiting"
exit 1
fi
else
RMANBACKUP_MOUNTPOINT=$ACTUAL_MOUNTPOINT
fi
export PATH=$ORACLE_HOME/bin:$PATH
full_backup () {
echo "Creating Dir $RMANBACKUP_MOUNTPOINT/$SID'/full'"
if [ ! -e $RMANBACKUP_MOUNTPOINT/$SID'/full' ]
then
mkdir -p $RMANBACKUP_MOUNTPOINT/$SID'/full'
if [ $? -eq 0 ];
then
echo "Created directory for full backup $RMANBACKUP_MOUNTPOINT/$SID/full"
else
echo "Oracle user does not have permission for $RMANBACKUP_MOUNTPOINT directory... exiting"
exit 1
fi
elif [ ! -d $RMANBACKUP_MOUNTPOINT/${SID}'/full' ];
then
echo "$RMANBACKUP_MOUNTPOINT is not a directory... exiting"
exit 1
fi
#Creating Archivelog Directory
if [ ! -e $RMANBACKUP_MOUNTPOINT/${SID}'/archivelogs' ]
then
mkdir -p $RMANBACKUP_MOUNTPOINT/${SID}'/archivelogs'
if [ $? -eq 0 ];
then
echo "Created directory for archivelogs backup $RMANBACKUP_MOUNTPOINT/$SID/archivelogs"
else
echo "Oracle user does not have permission for $RMANBACKUP_MOUNTPOINT directory... exiting"
exit 1
fi
elif [ ! -d $RMANBACKUP_MOUNTPOINT/${SID}'/archivelogs' ];
then
echo "$RMANBACKUP_MOUNTPOINT is not a directory... exiting"
exit 1
fi
LOG_FILE_DIR=$RMANBACKUP_MOUNTPOINT/'_workspace/RMAN_Logs'
echo "Creating Log File Dir: =$RMANBACKUP_MOUNTPOINT'/_workspace/RMAN_Logs'"
if [ ! -e $LOG_FILE_DIR ]
then
mkdir -p $LOG_FILE_DIR
if [ $? -eq 0 ];
then
echo "Created log directory for oracle backup $LOG_FILE_DIR"
else
echo "Oracle user does not have permission for $LOG_FILE_DIR directory... exiting"
exit 1
fi
fi
RMANBACKUP_MOUNTPOINT_FULL=$RMANBACKUP_MOUNTPOINT/$SID
#echo -n >$LOG_FILE_DIR'/rman_full_backup_'${SNAPSHOT_NAME}'.log'
touch $RMANBACKUP_MOUNTPOINT/_workspace/
if [ $? -ne 0 ];
then
echo "$RMANBACKUP_MOUNTPOINT directory is not writable.. exiting"
exit 1
fi
#Checking if any .lock file is present and deleting the same if the PID is NOT running.
is_lock_file_present=`find ${RMANBACKUP_MOUNTPOINT} -type f -name ".RMAN_FULL_lock_*"|wc -l `
if [[ ${is_lock_file_present} -ne 0 ]]
then
for _lock_file in `find ${RMANBACKUP_MOUNTPOINT} -type f -name ".RMAN_FULL_lock_*" | xargs `
do
_pid=`echo ${_lock_file}|cut -d"_" -f4`
is_pid_proc_running=`ps -ef|grep ${_pid}|grep -v grep | wc -l`
if [[ ${is_pid_proc_running} -ne 0 ]]
then
echo "[INFO] Full backup Lock File: ${_lock_file} is present and PID is active"
else
echo "[INFO] Full backup Lock File: ${_lock_file} is present and PID is NOT active"
echo "Deleting ${_lock_file}"
rm ${_lock_file}
if [ -e ${_lock_file} ]
then
echo "ERROR deleting file ${_lock_file}"
fi
fi
done
fi
# Creating a .lock file to represnt current active full/diff backup.
export file_stamp=`date | sed -e 's/ /_/g'`
PID=`echo $$`
LOCK_FILE=`echo ${RMANBACKUP_MOUNTPOINT}/.RMAN_FULL_lock_${PID}_${file_stamp}`
echo -n > ${LOCK_FILE}
if [ -e ${LOCK_FILE} ]
then
echo "[INFO] Lock file created: ${LOCK_FILE}"
else
echo "Error creating lock file: ${LOCK_FILE}"
echo "[ERROR] Backup will now stop"
exit -3
fi
echo "Starting with RMAN backup"
#Calling Start RMAN Backup
res_rmanbackup=$(curl -X POST http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/${SID}/full/rmanbackup 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to start phoenix backup failed... exiting"
echo "Response from Phoenix Backup Store: "$res_rmanbackup
exit 1
fi
echo "Response RMAN Backup: ${res_rmanbackup}"
SNAPSHOT_NAME=`echo $res_rmanbackup|awk -F "snap_name" '{print $2}'|cut -d '"' -f3`
if [ -z "$SNAPSHOT_NAME" ];
then
echo "Failed to get Snapshot name. Exiting. Please check Export Service Logs in PBS"
exit 1
fi
echo "Snapshot to be created ${SNAPSHOT_NAME}"
echo -n >$LOG_FILE_DIR'/rman_full_backup_'${SNAPSHOT_NAME}_${ORACLE_SID}'.log'
RMAN_LOGFILE=$LOG_FILE_DIR'/rman_full_backup_'${SNAPSHOT_NAME}_${ORACLE_SID}'.log'
echo "RMAN Logfile: ${RMAN_LOGFILE}"
rman log=$LOG_FILE_DIR'/rman_full_backup_'${SNAPSHOT_NAME}_${ORACLE_SID}'.log' 2> /dev/null << EOF
connect target /
set echo on;
configure backup optimization on;
configure controlfile autobackup on;
configure device type disk parallelism $PARALLELISM BACKUP TYPE TO COPY;
configure datafile backup copies for device type disk to 1;
configure archivelog backup copies for device type disk to 1;
configure channel device type disk format '${RMANBACKUP_MOUNTPOINT_FULL}/full/datafile_%U.bkp';
configure controlfile autobackup format for device type disk to '${RMANBACKUP_MOUNTPOINT_FULL}/full/full_controlfile_%d_%F.bkp';
run
{
sql 'alter system archive log current';
backup incremental level 1 for recover of copy with tag 'phoenix_oracle_backup' database;
sql 'alter system archive log current';
backup as backupset format '${RMANBACKUP_MOUNTPOINT_FULL}/archivelogs/%d_%h_%e_%s_%t.arc' archivelog all not backed up;
#Force is to ignore I/O errors
delete noprompt obsolete device type disk;
delete force NOPROMPT expired copy;
delete force NOPROMPT expired backup;
crosscheck backup;
crosscheck copy;
}
configure backup optimization clear;
configure controlfile autobackup clear;
exit
EOF
RMAN_EXIT_STATUS=$?
if [ $RMAN_EXIT_STATUS -ne 0 ];
then
echo ""
echo "rman failed with status $RMAN_EXIT_STATUS.. exiting"
rm ${LOCK_FILE}
if [ -e ${LOCK_FILE} ]
then
echo "[ERROR] Could NOT delete Lock file: ${LOCK_FILE}"
else
dt=`date | sed -e 's/ /_/g'`
echo "[INFO] Lock file deleted: ${LOCK_FILE} at ${dt} "
fi
exit 1
fi
echo "RMAN log location: $LOG_FILE_DIR/rman_full_backup_${SNAPSHOT_NAME}_${ORACLE_SID}.log"
echo "Notifying Phoenix to upload RMAN Logs"
rman_uploadlog_res=$(curl -X POST -H "Content-Type: multipart/form-data" -F "file=@$LOG_FILE_DIR/rman_full_backup_${SNAPSHOT_NAME}_${ORACLE_SID}.log" -F mountpoint=$RMANBACKUP_MOUNTPOINT -F platform=linux http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/uploadlog 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to send RMAN Logs failed..."
echo "Response from Phoenix Backup Store: "$rman_uploadlog_res
fi
rm ${LOCK_FILE}
if [ -e ${LOCK_FILE} ]
then
echo "[ERROR] Could NOT delete Lock file: ${LOCK_FILE}"
else
dt=`date | sed -e 's/ /_/g'`
echo "[INFO] Lock file deleted: ${LOCK_FILE} at ${dt} "
fi
echo "Notifying Phoenix to end backup"
final_res=$(curl -X PUT http://$BACKUP_STORE_IP:9090/druva-phoenix/v1/mounts/$BACKUP_MOUNT/backup 2> /dev/null)
if [ $? -ne 0 ];
then
echo "Request to end phoenix backup failed... exiting"
echo "Response from Phoenix Backup Store: "$final_res
rm ${LOCK_FILE}
if [ -e ${LOCK_FILE} ]
then
echo "[ERROR] Could NOT delete Lock file: ${LOCK_FILE}"
else
dt=`date | sed -e 's/ /_/g'`
echo "[INFO] Lock file deleted: ${LOCK_FILE} at ${dt} "
fi
exit 1
fi
ERROR_CODE=$(echo $final_res|awk -F "error_code" '{print $2}' | cut -d ':' -f2|cut -d ',' -f1)
if [ $ERROR_CODE -ne 0 ];
then
echo "Response from Phoenix Backup Store: "$final_res
echo "Request to End Phoenix backup failed... exiting"
fi
echo $final_res
echo "Exiting with successful status"
}
# Main
full_backup
You can download the following zip file for the above scripts: