Configure NetWorker NMDA Backup for Oracle RAC using Oracle SCAN

Single Client Access Name (SCAN), a feature used in Oracle Real Application Clusters (RAC) Environments, provides a single name for clients to access any Oracle Database running in a cluster. The benefit is that the client’s connect information does not need to change if nodes or databases are added to or removed from the cluster.

In this Knowledge Sharing article, (Arthur) Zhuang-Song Jiang outlines how SCAN can be utilized when configuring NetWorker NMDA backup to back up multimode Oracle RAC active-active databases to provide some great benefits. One example is having a single name to access the cluster to connect to databases in this cluster enables NetWorker scheduled backup jobs to access any databases running in the cluster in mode of load-balanced managed automatically by the Oracle RAC. This is done independently of the number of databases or servers running in the cluster and regardless of which server(s) in the cluster the requested database is actually active.

It will store the backup data under the index of a NetWoker client named after the SCAN name of Oracle RAC. This greatly facilitates recovery because it is no longer necessary to remember which node backed up what data.

Arthur uses an actual work example to showcase how to configure NetWorker NMDA 1.2 to back up a multi-node Oracle RAC using the Oracle SCAN feature.

Read the full article.