backup Satellite (embedded) database

A simple script to backup the embedded Oracle database included with Satellite 5.4.1

[root@rhnsat01 Satellite]# cat db_backup.sh 

#!/bin/bash

PRETTY_DATE=`date +%Y%m%d`

BACKUP_DIR=/rhnsat-backup/${PRETTY_DATE}

OUTPUT_LOG=/var/log/rhnsat-backup.log

mkdir ${BACKUP_DIR}

if [ ! -d ${BACKUP_DIR} ]

then

  echo "ERROR: unable to create Backup Dir: ${BACKUP_DIR}"

  exit 9

fi

# MESSAGE TO USER ON CONSOLE

echo "NOTE: you can find output at: ${OUTPUT_LOG}"

# BEGIN LOGGING OF THE SCRIPT OUTPUT

echo "Script ran at: `date +%Y%m%d-%H%M`" > ${OUTPUT_LOG}

echo "start: `date +%Y%m%d-%H%M`" >> ${OUTPUT_LOG}

# UPDATE PERMISSIONS OF THE BACKUP DIRECTORY TO ALLOW ORACLE

# TO WRITE

echo "chown -R oracle:dba /rhnsat-backup/*" >> ${OUTPUT_LOG}

chown -R oracle:dba /rhnsat-backup/* >> ${OUTPUT_LOG}

# CREATE A REPORT OF THE CURRENT ORACLE DB USAGE

echo "su - oracle -c \"/usr/bin/db-control report\"" >> ${OUTPUT_LOG}

su - oracle -c "/usr/bin/db-control report" >> ${OUTPUT_LOG}

# STOP SATELLITE SERVER (SHUTDOWN DB)

echo "/usr/sbin/rhn-satellite stop" >> ${OUTPUT_LOG}

/usr/sbin/rhn-satellite stop >> ${OUTPUT_LOG}

# RUN BACKUP VIA db-control UTILITY

echo "su - oracle -c \"/usr/bin/db-control backup $BACKUP_DIR\"" >> ${OUTPUT_LOG}

su - oracle -c "/usr/bin/db-control backup $BACKUP_DIR" >> ${OUTPUT_LOG}

# START SATELLITE SERVER

echo "/usr/sbin/rhn-satellite start" >> ${OUTPUT_LOG}

/usr/sbin/rhn-satellite start >> ${OUTPUT_LOG}

# EXAMINE DB BACKUP INTEGRITY

echo "/usr/bin/db-control examine ${BACKUP_DIR}" >> ${OUTPUT_LOG}

/usr/bin/db-control examine ${BACKUP_DIR} >> ${OUTPUT_LOG}

echo "NOTE: To examine backup fully use" >> ${OUTPUT_LOG}

echo "      su - oracle -c \"/usr/bin/db-control verify ${BACKUP_DIR}\"" >> ${OUTPUT_LOG}

echo "NOTE: To restore from this backup, use:" >> ${OUTPUT_LOG}

echo "      su - oracle -c \"/usr/bin/db-control restore ${BACKUP_DIR}\"" >> ${OUTPUT_LOG}

# INDICATE FINISH TIME IN LOG

echo "finish: `date +%Y%m%d-%H%M`" >> ${OUTPUT_LOG}

exit 0

# ***************************

# NOTES

# ***************************

# /etc/cobbler

# /var/satellite

#