按用户导出数据到asm磁盘组，并复制到另一个集群的asm

1.创建asm导出数据目录
sql>select name,total_mb,free_mb from v$asm_diskgroup;
确认集群asm磁盘组环境
asmcmd>cd +DGDSDB
asmcmd>mkdir dpbak
asmcmd>ls -l
sql>conn / as sysdba
create directory expdp_asm_dir as '+DGDSDB/dpbak';
create directory expdp_log_dir as '/home/oracle';
2.导出数据
cd /home/oracle
vim expdp.sh
expdp \'/ as sysdba\' directory=expdp_asm_dir dumpfile=用户_%U.dmp parallel=8 logfile=expdp_log_dir:用户.log schemas=用户 compression=all cluster=n
expdp \'/ as sysdba\' directory=expdp_asm_dir dumpfile=用户_%U.dmp parallel=8 logfile=expdp_log_dir:用户.log schemas=用户 compression=all cluster=n
nohup ./expdp.sh &>/dev/null &
tail -f 用户.log
ps -ef|grep expdp.sh
取消导出
select job_name,state from dba_datapump_jobs;
expdp \'/ as sysdba\' attach=SYS_EXPORT_SCHENA_02
s