IMPDP encountered ora-31693&ora-31640&ora-19505&ora-27037
An error occurred while IMPDP:
Additional Information:3
. . "Hq_x1" was imported. " t_xx130901 ":" SP15 "13.99 KB 0 rows
. . "Hq_x1" was imported. " t_xx130901 ":" SP2 "13.99 KB 0 rows
ORA-31693: Table Data Object "Hq_x1". " Temp_year_month "could not be loaded/unloaded and skipped with the following error:
ORA-31640: Could not open dump file to read "/hq_x22. DMP "
ORA-19505: Unrecognized file "/hq_x22. DMP "
ORA-27037: Unable to get file status
linux-x86_64 error:2: No such file or directory
Additional Information:3
My IMPDP command:
Nohup IMPDP hq_x1/hq_x1 dumpfile=hq_x1%u.dmp transform=oid:n directory=dir1 parallel=8&
Look at the official document saying:
The cause of this problem have been identified in unpublished bug 9378256. It is caused by a RAC instance not have physical access to the dump file (as indicated by the DIRECTORY parameter) and U Sing a parallel degree > 1. The problem with this setup was that the pq/px slaves was not constrained to the RAC instance from which the IMPDP operatio N had been started, and when such a pq/px slave doesn ' t had access to the dump file, the errors is raised.
The behavior is also reported in unpublished bugs 8415620-data PUMP DOES not HONOR the boundaries of the CONNECTED Servic E on RAC
DataPump RAC support was provided in 11.2. Prior to 11.2, once "a service to make" the initial connection to the database, an instance is selected and the mast The ER process and all worker processes run on the that instance.
In 11.2, the new DataPump parameter CLUSTER is introduced:
Syntax and Description:cluster=[y | N
Cluster:default=y
Purpose:
Determines whether Data Pump can use Oracle Real application Clusters (RAC)
Resources and start workers on other Oracle RAC instances.
The issue has been a fixed in the 11.2.0.2 patchset.
Possible Workarounds for the 11.2.0.1 release is:
Use the CLUSTER or service_name parameters to constrain the IMPDP job never to run on the instance does have access to th E dump File
Configure the database parameters in such a by that pq/px slaves is never started on the instance does have access to T He dump file
Use the parallel=1 IMPDP command line parameter to disable PARALLEL functionality during import
Store all dump files on a local filesystem of one of the RAC nodes and use a parallel degree lower than the number of the dump Files and import with the cluster=n command line option
Mount the cluster filesystem on all nodes and set the parallel degree to being equal to the number of the dump files and import W ith the cluster=n command line option
Plus Cluster=n Solution:
Nohup IMPDP hq_x1/hq_x1 dumpfile=hq_x1%u.dmp transform=oid:n directory=dir1 parallel=8 cluster=n&
Compared to Exp/imp, EXPDP/IMPDP's bug seems a bit more.
IMPDP encountered ora-31693&ora-31640&ora-19505&ora-27037
