ServiceGuard Maintenance Flag for Oracle DBA

[Global Server Operation]

Our DBA would like to perform maintenance for the database. They shutdown the database and it halts the packages. The DBA would like to still have their mountpoints available. Is their a maintenance FLAG in service guard we can toggle on/off when they do maintenance to allow this to happen?

All replies are appreciated.

[A. Clay Stephenson]

The package scripts and monitors are as wimmpy or as powerful or as feature-rich as you design them to be. The typical method is to look for the presence of a file, if the file is not found the monitor does its normal duty and screams bloody murder; if the file is found then it ignores the "failed" package.

[PeterWolfe · Accepted solution]

Take a look in /opt/cmcluster/toolkit/oracle
directory for the example single-instance Oracle failover scripts. These scripts
are part of the Enterprise Cluster Master
Toolkit (ECMT) which is included with the
Mission Critical operating environment
(along with Serviceguard).

If your Oracle scripts are based on these
scripts then:

- the MAINTENANCE_FLAG variable has
to be set to "yes" to have maintenance
mode enabled (and I think you
have to restart the package if this
is not already enabled
- When maintenance mode is enabled,
touch /oracle.debug
to enter maintenance mode. At this point,
the monitor ignores the status
of Oracle and it can be stopped/started
without causing the package to fail.
You have to make sure Oracle is
back up and running when you remove
the oracle.debug file.

If you aren't using these ECMT scripts,
you have to look at your failover
scripts to see if you have coded
this sort of feature.

[Global Server Operation]

Thank you all for the replies. Much appreciated.