Halting the database service alone in a SG package

[Sajith V Mannadiar]

Hello there,

We have a SG package configured for our database HA in a metro cluster environment.

We want to shutdown the database (using shutdown immediate) and then take the backup and then start the database again, all using automated scripts.

We can't halt the package as it is doing a 'shutdown abort' and also it halts the package completely.

Is it OK to,
01) Kill the database monitoring process - ".sh monitor"
02) Shutdown the database using ".sh shutdown"
03. Take the backup
04. Start the database using ".sh start"
05. Start the monitoring process using ".sh monitor"

Please advice..

Thanks,
Sajith

[Duncan Edmonstone]

Sajith

The answer is 'it depends'

It depends on the contents of your .sh file. I'm assuming this is a standard Enterprise Cluster Master Toolkit script. If it is the first few lines will read something similar to this:

#!/usr/bin/sh
# VERSION="@(#)B5139DA (11.x):"
# "@(#) B.01.08 $Revision: 2.00 $ $Date: 02/02/21 10:18:02 $"
# *****************************************************************************
# ******** Startup, Shutdown and Monitor Script for ORACLE (Template) *********
# *****************************************************************************
# ********** Note: This file MUST be edited before it can be used. ************
# *****************************************************************************
#



If the script has been setup in the 'vanila' way, then shutting down oracle or killing the monitor script will cause a failover.

However the script can be easily changed in the monitor section to look for a flag file to stop monitoring while you do something (like shut it down to back it up)

Have a look at the script attached to this thread by way of example:

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=115488

HTH

Duncan

[Geoff Wild · Accepted solution]

You need to setup a no monitor flag - if you kill the monitoring process - the package will fail over....

Here's something I did for lp spool...