源库:10.20.8.35
目的库:10.20.8.31
创建物理目录
mkdir -p /inspur/app/oracle/dumpbak
创建逻辑目录
create or replace directory dumpbak as '/inspur/app/oracle/dumpbak';
授权
grant read,write on directory dumpbak to luan;
grant all on directory dumpbak to public;
1、导出luan用户下(表结构) parallel=2 是导出文件数,可调
expdp luan/passwd dumpfile=data_pump_dir:luan_tbs_%U.dmp tablespaces=luan parallel=2 logfile=data_pump_dir:luan_tbs.log
拷贝dump文件到10.20.8.31
scp luan* root@10.20.8.31:/inspur/app/oracle/admin/orcl/dpdump
2、导出整库
expdp luan/passwd dumpfile=data_pump_dir:mydp_%U.dat nologfile=y full=y
拷贝dump整库文件到10.20.8.31
scp mydp_01.dat root@10.20.8.31:/inspur/app/oracle/admin/orcl/dpdump
目的库:10.20.8.31 数据导入
加入Oracle用户oinstall组,不然没权限
chown oracle:oinstall -R /inspur/app/oracle/admin/orcl/dpdump
导入luan用户下表空间
impdp luan/passwd dumpfile=data_pump_dir:luan_tbs_01.dmp,luan_tbs_02.dmp tablespaces=luan
导入整库
[oracle@zfb-jhdsj-sjkserver2 dpdump]$ impdp luan/passwd dumpfile=data_pump_dir:mydp_01.dat parallel =3 full = y
导入过程中报错
ORA-39171: Job is experiencing a resumable wait.
#表空间不足,扩好后回继续执行
alter tablespace luan add datafile '/inspur/app/oracle/oradata/orcl/luan02.dbf'
size 100M autoextend on next 10M maxsize 32479 M;