NetWorker configuration using NMO in Oracle RAC

Question

We are using NetWorker 7.4.4 and NMO 5.0 to backup an Oracle database running on a 2 node cluster. Currently we are simply backing up a single instance (node A).

This seems to work fine, however the NMO manual vaguely covers a configuration of all nodes suggesting that a backup can be load balanced and run in parallel against all the nodes in the cluster simultaneously.

I assume this would be preferable if possible for obvious reasons. I am not clear on how the indexing is handled however and would like to hear some comments from people who have experience with this configuration on the best practices for backup and restoration.

Thanks in advance.

ble1 · Answer

We always use single node for backup od database (name that we should use no matter where instance is running) and for archive logs we use all nodes separatelly.

jmorton2 · Answer

What is the reasoning behind this? Also, is connecting to an od instance versus using the service name going to be an issue when restoring to another node?

ble1 · Answer

In old environment they do not use load balancing... so specifying service name doesn't give us much. We simply allocate channels per nodes. In new environment we are going for geo-RAC and there probably we will use different setup there (currently building up). That kind of stuff is really DBA decision and most of the time they build their own RMAN scripts which we just call for backup. Restore is also something they handle most of the time. I once read their paper on how they do it and at that time it made sense... but that was few years ago...

NetWorker

NetWorker configuration using NMO in Oracle RAC

Was this post helpful?