1.創(chuàng)建asm導(dǎo)出數(shù)據(jù)目錄
sql>select name,total_mb,free_mb from v$asm_diskgroup;
確認集群asm磁盤組環(huán)境
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.導(dǎo)出數(shù)據(jù)
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
取消導(dǎo)出
select job_name,state from dba_datapump_jobs;
expdp \'/ as sysdba\' attach=SYS_EXPORT_SCHENA_02
stop_job
kill_job
3.asm到asm
asmcmd>cd +data/orcl/dpbak
asmcmd>ls -l
分別在源端與目標(biāo)端授予sys用戶sysasm權(quán)限
sql>grant sysasm to sys;
拷貝前檢查目標(biāo)端監(jiān)聽，是否監(jiān)聽了ASM實例
檢查目標(biāo)端磁盤組空間
sql>select name,total_mb,free_mb from v$asm_diskgroup;
asmcmd>cp +data/oracl/dpbak/dmpfile sys@目標(biāo)端ip.+ASM:+data/orcl/dpbak/dmpfile