Oracle, Troubleshooting

Why parallel expdp gives unable to write error DATAPUMP With PARALLEL > 1 ON 11.2 RAC

hello, Problem:

Datapump on 11.2 RAC with PARALLEL > 1  hits the following errors.

ORA-31693: Table data object “IIR_USER”.”IDS_00_INUSE” failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file “/export/expıırdb_04.dmp” for write
ORA-19505: failed to identify file “/export/expıırdb_04.dmp”
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

 

Cause

From 11.2, Datapump new parameter CLUSTER is introduced.

CLUSTER : Default=Y

Purpose :
Determines whether Data Pump can use Oracle Real Application Clusters (RAC)
resources and start workers on other Oracle RAC instances.

Syntax and Description : CLUSTER=[Y | N]

Solution

To force Data Pump to use only the instance where the job is started and to replicate pre-Oracle Database 11g release 2 (11.2) behavior, specify CLUSTER=N.

export scripts :

[oracle@jery scripts]$ cat expIIRDB.sh
expdp userid=\”/ as sysdba\” DIRECTORY=EXP01 full=Y DUMPFILE=expıırdb_%U.dmp LOGFILE=expıırdb.log parallel=4 compression=all CLUSTER=N
[oracle@jery scripts]$

 

Br. Erman.

Advertisements
Standard

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s