EAS备份帐套和恢复帐套
1)导出:
expdp system/orcl@ORCL schemas=GIDEMO directory=EAS_IMPDP_DIR dumpfile=gidemo.dmp logfile=gidemo.log

2)导入(表空间映射):
create tablespace EAS_D_USER_STANDARD datafile '/home/easdb/EAS_D_USER_STANDARD.dbf' size 500m autoextend on;
create tablespace EAS_D_USER_TEMP2 datafile '/home/easdb/EAS_D_USER_TEMP2.dbf' size 100m autoextend on;
create temporary tablespace EAS_T_USER_STANDARD tempfile '/home/easdb/EAS_T_USER_STANDARD.dbf' size 100m autoextend on;
create user USER identified by USER default tablespace EAS_D_USER_STANDARD temporary tablespace EAS_T_USER_STANDARD;
create directory eas_impdp_dir as '/home/easData/';
grant read,write on directory EAS_IMPDP_DIR to system,USER;

在控制台执行:
impdp system/orcl@easdb directory=EAS_IMPDP_DIR dumpfile=gidemo_backup.dmp logfile=USER2013.log remap_schema=gidemo:USER remap_tablespace=EAS_D_GIDEMO_STANDARD:EAS_D_USER_STANDARD,EAS_T_GIDEMO_STANDARD:EAS_T_USER_STANDARD,EAS_D_GIDEMO_TEMP2:EAS_D_USER_TEMP2 parallel=2
微信扫一扫
分享
举报
您需要登录后才可以回帖 登录 | 注册