Oracle Rman and Service Guard

[Morris Makuch]

Hi. I would like to run Rman to backup up a Oracle database that is running in noarchive mode. I will be using Grid Control to create the job. This Oracle database is in a 2 node Service Guard cluster. My concern is for Rman to backup the database, it will have to shutdown it down to do a cold backup because it runs noarchive mode. So once Rman issues a shutdown immediate, then the package will probably try to fail over to the alternate node. Changing the database to archive mode is not a option. How do I accomplish what I am trying to do?

[Duncan Edmonstone · Accepted solution]

Morris,

If you are using a relatively recent version of the Enterprise Cluster Master Toolkit (ECMT) with Serviceguard and Oracle, then you can touch a file called 'oracle.debug' in the package directory under /etc/cmcluster to suspend monitoring whilst you do this sort of work.

So are you sing the ECMT?

HTH

Duncan

[Morris Makuch]

Hi Duncan. Yes I am using ECMT version B.02.20. So how does this file work and how do I implement it?

[Duncan Edmonstone]

Morris,

Not sure it was implemented in such an old version of the toolkit (I have v4.00 on my system), but see if you have a file called haoracle.conf in your package directory in /etc/cmcluster. Look in there for the entry MAINTENANCE_FLAG - theres a description there that should make it pretty clear.

HTH

Duncan