How to Use Oracle Data Pump with Oracle RAC

How to Use Oracle Data Pump with Oracle RAC📚

Using Oracle Data Pump in an Oracle Real Application Clusters (Oracle RAC) environment requires you to perform a few checks to ensure that you are making cluster member nodes available.

📙To use Oracle Data Pump or external tables in an Oracle RAC configuration, you must ensure that the directory object path is on a cluster-wide file system.

The directory object must point to shared physical storage that is visible to, and accessible from, all instances where Oracle Data Pump or external tables processes (or both) can run.

📘The default Oracle Data Pump behavior is that child processes can run on any instance in an Oracle RAC configuration. 

Therefore, child processes on those Oracle RAC instances must have physical access to the location defined by the directory object, such as shared storage media. 

If the configuration does not have shared storage for this purpose, but you still require parallelism, then you can use the CLUSTER=NO parameter to constrain all child processes to the instance where the Oracle Data Pump job was started.

📗Under certain circumstances, Oracle Data Pump uses parallel query child processes to load or unload data. 

In an Oracle RAC environment, Data Pump does not control where these child processes run. 

Therefore, these child processes can run on other cluster member nodes in the cluster, regardless of which instance is specified for CLUSTER and SERVICE_NAME for the Oracle Data Pump job. 

Controls for parallel query operations are independent of Oracle Data Pump. 

When parallel query child processes run on other instances as part of an Oracle Data Pump job, they also require access to the physical storage of the dump file set.

How to limit pump process in specific node on RAC env?

Consider using these options:

- Use service for data pump

- PARALLEL_INSTANCE_GROUP

- Impdp/expdp cluster=no

- set parallel_force_local=TRUE SID='ORCL1';

- Adjusting Resources manager