UNIX Shell Script

Set Database ARCHIVELOG Mode

Updated : 29-July-1998
Version : 1.0

Description

Shut database down and sets the database in Archive Log Mode. This script uses the assumes you've copied the shutdown database script as shutdown_db.ksh.

Parameters

$1 (MANDATORY) - ORACLE_SID of the database to set ARCHIVELOG mode.

Shell Source

#!/bin/ksh

DATABASE=$1

# Check that we have a database
if [ -z "${DATABASE}" ]
then
   echo
   echo "No Database Specified !"
   echo
   echo "Usage : set_archivelog.ksh <ORACLE_SID>"
   echo
   echo "where ORACLE_SID (Mandatory) - SID of database to start"
   echo
   echo " e.g.  $ set_archivelog.ksh PROD" 
   echo
   exit 1
fi

# Get the ORACLE_HOME from the oratab file
ORACLE_HOME=`cat /etc/oratab | grep $DATABASE | awk -F: '{print $2}'`
if [ ! -d "${ORACLE_HOME}" ]
then
  echo
  echo "$ORACLE_HOME does not exist !"
  echo
  exit 1
fi

ORACLE_SID=$DATABASE
export ORACLE_SID
PATH=.:$ORACLE_HOME/bin:$PATH; export PATH

# See if we can find svrmgrl, if not use sqldba instead
if [ -x "${ORACLE_HOME}/bin/svrmgrl" ]
then
    SVR="svrmgrl"
else
    SVR="sqldba lmode=y"
fi

 ./shutdown_db.ksh "${DATABASE}" "NORMAL"

$SVR << EOF
connect internal
startup mount exclusive;
alter database archivelog;
alter database open;
archive log start
archive log list
exit
EOF

exit 0