由于磁盘空间的客观原因,不能采用rman和expdp方式生成落地文件进行恢复或导入操作,所以最终还是决定采用impdp采用network_link方式进行数据导入,这个方式真的非常不错,并且由于impdp可以直接在服务器端后台运行,所以可以无人值守,第二天只需要检查logfile即可
此处略去创建dblink这个步骤。
Oracle$ impdp system/oracle network_link=expdplogfile=impdpXZBLOB20120331.log directory=expdp schemas=XZBLOBparallel=8
Import: Release 10.2.0.5.0 - 64bit Production on 星期六, 31 3月,2012 16:26:55
Copyright (c) 2003, 2007, Oracle.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, Data Mining andReal Application Testing options
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_02":
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 232.3 GB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object typeSCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
. . imported"XZBLOB"."ACF_SYS_BULEX_ACFFILE"
. . imported"XZBLOB"."AQSIQ_WS_FILE"
. . imported"XZBLOB"."ACF_SYS_OPINION_ATTACH"
. . imported"XZBLOB"."BJYC_ISO_ATTACH"