impdp用NETWORK_LINK从远程库导入到本地库,导入表的速度还正常,导入索引的速度特别慢。2个小时才导1300个索引。
使用imp的格式:
impdp vebackup/abc DIRECTORY=DATABAK_DIR NETWORK_LINK=primarydb_link SCHEMAS=veasms TABLE_EXISTS_ACTION=REPLACE REMAP_SCHEMA=veasms:veasms logfile=impdpstan.log
原来库里面做了N个日志文件,每个大小50M。不知道这影不影响性能。
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/opt/ora10/oradata/vedb/redo03.log
/opt/ora10/oradata/vedb/redo02.log
/opt/ora10/oradata/vedb/redo01.log
/opt/ora10/oradata/vedb/redo04.log
/opt/ora10/oradata/vedb/redo05.log
/opt/ora10/oradata/vedb/redo06.log
/opt/ora10/oradata/vedb/redo07.log
/opt/ora10/oradata/vedb/redo08.log
/opt/ora10/oradata/vedb/redo09.log
/opt/ora10/oradata/vedb/redo10.log
/opt/ora10/oradata/vedb/redo11.log
MEMBER
--------------------------------------------------------------------------------
/opt/ora10/oradata/vedb/redo12.log
/opt/ora10/oradata/vedb/redo13.log
/opt/ora10/oradata/vedb/redo14.log
/opt/ora10/oradata/vedb/redo15.log
/opt/ora10/oradata/vedb/redo16.log
/opt/ora10/oradata/vedb/redo17.log
/opt/ora10/oradata/vedb/redo18.log
/opt/ora10/oradata/vedb/redo19.log
/opt/ora10/oradata/vedb/redo20.log
/opt/ora10/oradata/vedb/redo21.log
/opt/ora10/oradata/vedb/redo22.log
MEMBER
--------------------------------------------------------------------------------
/opt/ora10/oradata/vedb/redo23.log
/opt/ora10/oradata/vedb/redo24.log
/opt/ora10/oradata/vedb/redo25.log
/opt/ora10/oradata/vedb/redo26.log
26 rows selected.