1. 登录sys用户
sqlplus /nolog
conn sys/sys@192.168.0.108/mydatabase as sysdba
2. 创建备份逻辑目录,此目录不是真实的目录
create or replace directory dump_dir as '/u01/app'
3. 让数据库sys用户对备份目录dump_dir有读写权限
grant read, write on directory dump_dir to sys;
4. 备份数据库
expdp \’sys/”sys”@10.5.28.208/symdb as sysdba\’ schemas=symbols,target directory=dump_dir dumpfile=xxx.dmp logfile=xxx.log
5. 还原数据库
impdp \’sys/”sys”@10.5.28.208/othdb as sysdba\’ fromuser=symbols,target touser=symbols,target directory=dump_dir dumpfile=aaa.dmp,bbb.dmp logfile=sys.log FULL=Y ignore=Y parallel=10;
将ignore参数设置为Y可以忽略创建错误继续进行,但是有些错误是不忽略的