登陆数据库
sqlplus / as sysdba
创建导出数据dump用户
create user dump identified by dump;
grant dba to dump;
创建备份目录并赋予权限
mkdir /backup
create directory dump as ‘/backup’;
grant read,write on directory dump to dump;
并行导出数据库到本地
nohup expdp dump/dump directory=dump dumpfile=full_%U.dmp logfile=full.log full=yes parallel=4 &
eg:
nohup impdp dump/dump directory=dump dumpfile=full_01.dmp,full_02.dmp,full_03.dmp,full_04.dmp logfile=full1.log full=yes parallel=4 &
导入数据库
nohup impdp dump/dump directory=dump dumpfile=1,2,3,4 logfile=full1.log full=yes parallel=4 &
单独导出某个用户的表
nohup expdp dump/dump directory=dump dumpfile=full_%U.dmp logfile=full.log schemas=xxx parallel=4 &