数据泵备份

create directory expdpbak as '/rman/expdp/';

grant read,write on directory expdpbak to ncc; 给备份用户授权

vi expdp_ncc.par
 
userid="/ as sysdba" 
directory=EXPDPBAK 
dumpfile=expdp_ncc_%U.dmp
logfile=expdp_ncc.log 
parallel=2
schemas=NCC 

expdp parfile=expdp_ncc.par > expdp_ncc.par.out

恢复abc

1.查看abc用户所包含的表空间， 创建所需要的表空间

select username,default_tablespace from dba_users where username='ABC';

USERNAME               DEFAULT_TABLESPACE
------------------------------ ------------------------------
ABC                   ABC_DATA

create tablespace ABC_DATA datafile '/oradata/qms/abc_data01.dbf'
size 1024M AUTOEXTEND ON
2.创建用户

CREATE USER ABC IDENTIFIED BY ABC#12345 DEFAULT TABLESPACE ABC_DATA;

grant connect,resource to abc;
3.创建directories

create or replace directory EXPDP as '/oradata/backup';
4.导入脚本 vi impdp_abc.par

USERID=' / AS SYSDBA'
DIRECTORY=EXPDP
DUMPFILE=abc.dmp-202002242300
LOGFILE=abc.log
SCHEMAS=abc
CONTENT= ALL
impdp parfile=impdp_abc.par > impdp_abc.par.out