做网站需要什么框架,哈尔滨网站建设方案服务,无锡谷歌优化,珠宝网站设计文案单实例数据库10.2.0.4#xff0c;目标数据库11.2.0.3 rac#xff0c;目标准备将单实例上的数据导入到rac数据库。在导入过程中报错如下#xff1a;Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA. . imported LBSBUS.T_MSG_SEND_DETAIL …单实例数据库10.2.0.4目标数据库11.2.0.3 rac目标准备将单实例上的数据导入到rac数据库。在导入过程中报错如下Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA. . imported LBSBUS.T_MSG_SEND_DETAIL 401.5 MB 1726271 rows. . imported LBSBUS.T_GISROADQUERY 87.84 MB 1982744 rowsORA-31693: Table data object LBSBUS.T_LOG failed to load/unload and is being skipped due to error:ORA-31640: unable to open dump file /home/oracle/gejie/ngis140227.dmp for readORA-19505: failed to identify file /home/oracle/gejie/ngis140227.dmpORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directory奇怪为什么有的表能导进有的表不能导进查找文件目录权限都没问题。2.1 因为报的错误是不可以读dump文件,仔细检查了文件及其目录的访问权限,发现没有任何问题.2.2 在metalink上搜索,找到了ID1071373.1的文章,知道了真正的原因.原来11g R2的IMPDP 增加了一个参数设置:CLUSTER,在设置了parallel参数1的情况下, 可以支持多个节点的同时导入工作.这边实际的情况是,另外一个节点无法访问到dump文件,我也是只想从一个节点导入数据,所以需要关闭这个选项.三. 问题解决修改导入的命令,设置clusterN,再次进行导入$nohup impdp lbsbus/lbsbus directorya1 dumpfilengis0816.dmp logfilengis.log TABLE_EXISTS_ACTIONappend EXCLUDESTATISTICS parallel5 clustern;数据库数据可以正常导入到11g rac的数据库中问题解决.附件: metalink doc id1071373.1的文章的主要内容:SymptomsDataPump on 11.2 RAC with PARALLEL 1 still hits the following errors though the unpublished Bug 8415620 is fixed into 11.2:ORA-31693: Table data object TITAN.TN_TICKET:TN01_2006_02 failed to load/unload and is being skipped due to error:ORA-29913: error in executing ODCIEXTTABLEOPEN calloutORA-31640: unable to open dump file /oracle/xfertest/titan_01.dmp for readORA-19505: failed to identify file /oracle/xfertest/titan_01.dmpORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3Unpublished Bug 8415620 DATA PUMP DOES NOT HONOR THE BOUNDARIES OF THE CONNECTED SERVICE ON RACDataPump RAC support is provided in 11.2. Prior to 11.2, once you use a service to make the initial connection to the database,an instance is selected, and the master process and all worker processes run on that instance.CauseFrom 11.2, DataPump new parameter CLUSTER is introduced.CLUSTER : DefaultYPurpose :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]SolutionTo force DataPump to use only the instance where the job is started and to replicate pre-Oracle Database 11g release 2 (11.2) behavior, specify CLUSTERN.Example:# expdp lbsbus/lbsbus DIRECTORYdpump_dir1 DUMPFILEgis*.dmp CLUSTERN PARALLEL3来自 “ ITPUB博客 ” 链接http://blog.itpub.net/22969361/viewspace-1102454/如需转载请注明出处否则将追究法律责任。
