RHN prep.sh

#!/bin/sh

# This script prepares an embedded Oracle database to be able to use RMAN. It
# only ever needs to be run once for a particular database, however running it
# multiple times is safe.

# Matthew Booth <mbooth@redhat.com> 22/09/2006

# Make sure we're root
# Could just be Oracle, but root is simpler for administrators
if [ `id -u` -ne 0 ]; then
    echo This script must be executed as root
    exit 1
fi

# Check the rhn database isn't already running
if service rhn-database status; then
    echo You must stop the rhn-database service before running this script
    exit 1
fi

# Become the oracle user
su - oracle -c "/bin/bash -s" <<-'ORACLE'
    export ORACLE_SID=rhnsat

    # Enable archive log on the database
    sqlplus "/ as sysdba" <<-'EOF'
        startup nomount;
        alter database mount exclusive;
        alter database archivelog;
        shutdown immediate;
    EOF

    # Configure the rman retention policy
    rman target / nocatalog <<-'EOF'
        startup;
        configure retention policy to redundancy 2;
        shutdown;
    EOF
ORACLE

# vim: ts=4 sw=4 smartindent noexpandtab