Managing Serviceguard Extension for SAP on Integrity Linux, December 2005

Step by Step Installation of SGeSAP on Integrity Linux for SAP WAS Central Instances
Application Configuration
Chapter 2 81
# Startup the database without changing the ARCHIVELOG state
#
echo "connect / as sysdba;" > $SRVMGRDBA_CMD_FILE
echo "connect internal;" > $SRVMGRDBA_CMD_FILE
echo "startup;" >> $SRVMGRDBA_CMD_FILE
echo "exit;" >> $SRVMGRDBA_CMD_FILE
eval $SRVMGRDBA command=@$SRVMGRDBA_CMD_FILE >> $LOG 2>&1
The sample replacement code for ORACLE 9 releases can be found in the
file /opt/cmcluster/sap/SID/startdb.sqlplus (SuSE) or
/usr/local/cmcluster/sap/SID/startdb.sqlplus (Red Hat).
#
# Startup the database without changing the ARCHIVELOG state
# alter datafile 'end backup' when instance crashed during
# backup
echo "connect internal/ as sysdba;" > $SRVMGRDBA_CMD_FILE
echo "startup mount;" >> $SRVMGRDBA_CMD_FILE
echo "spool endbackup.log" >> $SRVMGRDBA_CMD_FILE
echo "select 'alter database datafile '''||f.name||''' end
backup;'">>$SRVMGRDBA_CMD_FILE
echo "from v\$datafile f, v\$backup b" >> $SRVMGRDBA_CMD_FILE
echo "where b.file# = f.file# and b.status = 'ACTIVE'" >>
$SRVMGRDBA_CMD_FILE
echo "/" >> $SRVMGRDBA_CMD_FILE
echo "spool off" >> $SRVMGRDBA_CMD_FILE
echo "!grep '^alter' endbackup.log >endbackup.sql" >>
$SRVMGRDBA_CMD_FILE
echo "@endbackup.sql" >> $SRVMGRDBA_CMD_FILE
echo "!rm endbackup.*" >> $SRVMGRDBA_CMD_FILE
echo "alter database open;" >> $SRVMGRDBA_CMD_FILE
echo "exit;" >> $SRVMGRDBA_CMD_FILE
eval $SRVMGRDBA command=@$SRVMGRDBA_CMD_FILE >> $LOG 2>&1