一、新建目录
connect / as sysdba
create directory dump as 'f:\dump'; --必须创建此目录 f:\dump
drop directory dump;--删除
exit;
二、源数据库上准备传输集
rman>
transport tablespace "OCP"
tablespace destination 'f:\dump'
auxiliary destination 'f:\dump'
datapump directory "dump"
dump file "ocp.dmp"
import script "impocpscript.sql"
export log "expocplog.log";
此时需要关闭sqlplus中其它终端回话.
-------------------------------------------常见错误
错误1:
使用 SID='sqcx' 创建自动实例
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: =================