vi tabledata_impdp.par
DIRECTORY=DPUMP_OMEGA_DIR1
DUMPFILE=DPUMP_OMEGA_DIR1:SYSFM_%U.dmp
LOGFILE=LOGFILE_OMEGA_DIR1:sysfm_tabledata.log
PARALLEL=16
SCHEMAS=SYSFM
REMAP_SCHEMA=SYSFM:SYSFM
JOB_NAME=data_Impdp
CONTENT=DATA_ONLY
> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production
on Tue May 15 20:44:06 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition
Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application
Clusters and Automatic Storage Management options
SQL> select banner from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition
Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE
11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 -
Production
NLSRTL Version 11.2.0.2.0 - Production
SQL>
While loading only oracle table’s data into
existing schema tables using Data pump gave me following error
ORA-31693: Table data
object "SYSFM"."PS_IN_DEMAND" failed to load/unload and is
being skipped due to error:
ORA-31640: unable to
open dump file "/var/backup/omega/SYSFM_05.dmp" for read
ORA-19505: failed to
identify file "/var/backup/omega/SYSFM_05.dmp"
ORA-27037: unable to
obtain file status
Linux-x86_64 Error:
2: No such file or directory
Then I realized that this is a RAC database, from 11gR2 RAC, Data pump
new parameter CLUSTER is
introduced. When parallel > 1 is
given we have to include the cluster parameter.
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]
Then I made Cluster=N to force Data Pump to use only the instance where
the job is started and ran again data pump job using below parfile, then
successfully completed
DIRECTORY=DPUMP_OMEGA_DIR1
DUMPFILE=DPUMP_OMEGA_DIR1:SYSFM_%U.dmp
LOGFILE=LOGFILE_OMEGA_DIR1:newsysfm_tabledata.log
PARALLEL=16
SCHEMAS=SYSFM
REMAP_SCHEMA=SYSFM:SYSFM
JOB_NAME=data_Impdp
CONTENT=DATA_ONLY
CLUSTER=N
Hope this helps!
