Skip to main content

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
# 

Labels:

Comments

Post a Comment

Popular posts from this blog

P2V using dd for KVM-QEMU guest

Preface: I have certainly not exhaustively tested this process.  I had a specific need and found a specific solution that worked. Situation:  I was issued a shiny new laptop running Red Hat Enterprise Linux 7 (with Corp VPN, certs, Authentication configuration, etc...)  The image was great, but I needed more flexibility on my bare metal.  So, my goal was to P2V the corporate image so I could just run it as a VM. * Remove corporate drive and install new SSD * install corp drive in external USB-3 case * Install RHEL 7 on new SSD * dd old drive to a disk-image file in a temp location which will be an image which is the same size as your actual drive (unless you have enough space in your destination to contain a temp and converted image) * convert the raw disk-image to a qcow file while pushing it to the final location - this step should reduce the disk size - however, I believe it will only reduce/collapse zero-byte blocks (not just free space - i.e. if you de...
1 comment
Read more

Extending SNMP to run arbitrary shell script

Why are we here... This is not likely something I would have pursued under normal circumstances.  I happen to be working for a customer/client who is not afforded a lot of flexibility to accomplish their goals.  In this case, the rigor is justified.  They have to sometimes be fairly creative with how they solve problems. In this case they would like to utilize an existing snmp implementation to execute a command (or shell script) on a remote system.  They came to me with the idea of using Net-SNMP extend. https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Linux/6/html/Deployment_Guide/sect-System_Monitoring_Tools-Net-SNMP-Extending.html NOTE:  This is NOT a good implementation strategy in the "real world"  it will simply allow you to test the functionality.  There are a TON of security implications which would need to be taken in to consideration. Implementation Steps: [root@rh7tst01 ~]# yum -y install net-snmp net-snmp-utils ...
Post a Comment
Read more

RHN Satellite Server (spacewalk) repomd.xml not found

"repomd.xml not found" If you add a channel, or if your RHN cache gets corrupted, and one of your guests complains that it cannot find repomd.xml for jb-ews-2-x86_64-server-5-rpm (for example) - you need to rebuild your repodata cache. Normally this is an automated job - which is exemplified by the fact that you have obviously built out your entire Satellite environment and never had to do any of the steps you are about to do. So - some prep work: Open 3 terminals to your Satellite Server and run: # Term 1 cd /var/cache/rhn watch "ls -l | wc -l" # Term 2 pwd cd /var/log/rhn tail -f rhn_taskomatic_daemon.log # Term 3 satellite-sync --channel=jb-ews-2-x86_64-server-5-rpm Once the satellite-sync has completed, you >should< see the count increment by one.  If you are unlucky (like me) you will not. You then need to login to the Satellite WebUI as the satellite admin user. Click on the Admin tab (at the top) Task Schedules (on the left) fin...
Post a Comment
Read more