Execute RMAN script on only one host (Failover VIP is not available and backup is not load balanced)

[Symctec]

Hello,

As per NetBackup Oracle admin guide on page 190

"Example RAC configuration: Failover VIP is not available and backup is not load balanced"

In this configuration, hostname1 or vipname1 and hostname2 or vipname2 allow connections to the respective hosts in the cluster. You need a special configuration to ensure that the backup script executes on at least one of the hosts but not on both hosts. Otherwise, a backup may not occur if the specified instance is down, or a redundant backup occurs if both of the specified instances are active.

I am trying to setup this type of backup but the document does not mention how the special configuration can be done? Has anybody configured this before and get me a heads up.

Thanks very much...

[Marianne · Accepted solution]

.... but the document does not mention how the special configuration can be done?

Actually it does....

The configuration is as follows:

■ The policy specifies client names for both hosts, either hostname1 and

hostname2, or vipname1 and vipname2 to ensure that the backup is attempted

on a host which is currently operational.

■ The backup script must be accessible to both hosts in the cluster, the clustered

file system makes a good location.

■ The backup script should be customized so that it starts RMAN on exactly one

of the clients. If executed on the primary, then start RMAN and perform the

backup. If executed on the secondary and the primary is up, then exit with

status 0 so that the NetBackup scheduler does not retry this client. If executed

on the secondary and the primary is down, then start RMAN and perform the

backup. You can build the script customization around a tnsping to the primary

or even a query of the database to see if the other instance is open and able to

perform the backup.
....
....

[Symctec]

Hello Marianne,

Thanks for the info, actually what you mentioed in the third pointis what I am looking for. Is there a sample script that can shows how to perform the script customization around tnsping? Unfortunately the DBA is not very familiar with scripting, nor am I.

Thanks :)

[Will_Restore]

Really a DB function and probably better asked on Oracle forum. 

( if anyone here does have a script hopefully they can post it )