关于EASCloud8.6 Demo账套(oracle)恢复说明
几经摸索试验,终于搞定了!借鉴了8.5账套的恢复说明https://wenku.my7c.com/article/43437547444568202?channel_level=kdclub,非常感谢该文章的作者!建议总部在客户端demo账套的路径下留下恢复说明,包括oracle数据库备份时候的用户名,如需版本号请提供版本号,不然实在是比较折腾。具体如下:
一、关于EASCloud8.6备份介质EAS860UPD20191226.DMP的说明:
Demo账套的用户名:
EAS860UPD
表空间:
① EAS_D_EAS860UPD_STANDARD
② EAS_T_EAS860UPD_TEMP
二、恢复说明:
先在本地任意路径创建一个文件夹,名称任意,比如:D:\EAS86Demo\EAS86dmp,后将EAS860UPD20191226.DMP拷贝到该文件夹下。
1、用系统管理员登录oracle按如下脚本操作
①创建目录
create directory dmpdir as 'D:\EAS86Demo\EAS86dmp';
②创建表空间
create temporary tablespace EAS_T_EAS86Demo_TEMP tempfile 'D:\EAS86Demo\EAS_T_EAS86Demo_TEMP.dbf' size 100m
autoextend on next 50m maxsize UNLIMITED extent management local;
create tablespace EAS_D_EAS86Demo_TEMP2 datafile 'D:\EAS86Demo\EAS_D_EAS86Demo_TEMP2.dbf' size 100m autoextend on
next 50m maxsize UNLIMITED extent management local;
create tablespace EAS_D_EAS86Demo_INDEX datafile 'D:\EAS86Demo\EAS_D_EAS86Demo_INDEX.dbf' size 100m autoextend on
next 50m maxsize UNLIMITED extent management local;
create tablespace EAS_D_EAS86Demo_STANDARD datafile 'D:\EAS86Demo\EAS_D_EAS86Demo_STANDARD.dbf' size 100m
autoextend on MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
③创建用户
create user EAS86 IDENTIFIED BY EAS86 DEFAULT TABLESPACE EAS_D_EAS86Demo_STANDARD TEMPORARY TABLESPACE
EAS_T_EAS86Demo_TEMP ACCOUNT UNLOCK;
④给用户授权
GRANT CONNECT,RESOURCE,DBA TO EAS86;
2、Ctrl+r 输入cmd打开命令窗口,执行如下脚本完成数据泵导入操作
impdp EAS86/EAS86@orcl directory=dmpdir dumpfile=EAS860UPD20191226.DMP table_exists_action=replace REMAP_SCHEMA=EAS860UPD:EAS86 remap_tablespace=EAS_D_EAS860UPD_STANDARD:EAS_D_EAS86DEMO_STANDARD,EAS_T_EAS860UPD_TEMP:EAS_T_EAS86DEMO_TEMP job_name=EAS86Demo_impdp exclude=statistics LOGFILE=impdp210315.log
注意结尾不要用分号";"
这个log文件备份文件里面没有,是怎么弄得
DBA登录执行
create directory dmpdir as 'C:\EAS86Demo\EAS86dmp';
create temporary tablespace EAS_T_EAS860UPD_TEMP tempfile 'C:\EAS86Demo\EAS_T_EAS860UPD_TEMP.dbf' size 100m autoextend on next 50m maxsize UNLIMITED extent management local;
create tablespace EAS_D_EAS860UPD_TEMP2 datafile 'C:\EAS86Demo\EAS_D_EAS860UPD_TEMP2.dbf' size 100m autoextend on next 50m maxsize UNLIMITED extent management local;
create tablespace EAS_D_EAS860UPD_INDEX datafile 'C:\EAS86Demo\EAS_D_EAS860UPD_INDEX.dbf' size 100m autoextend on next 50m maxsize UNLIMITED extent management local;
create tablespace EAS_D_EAS860UPD_STANDARD datafile 'C:\EAS86Demo\EAS_D_EAS860UPD_STANDARD.dbf' size 100m autoextend on MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
create user EAS860UPD IDENTIFIED BY EAS860UPD DEFAULT TABLESPACE EAS_D_EAS860UPD_STANDARD TEMPORARY TABLESPACE EAS_T_EAS860UPD_TEMP ACCOUNT UNLOCK;
GRANT CONNECT,RESOURCE,DBA TO EAS860UPD;
执行导入
impdp EAS860UPD/EAS860UPD@orcl directory=dmpdir dumpfile=EAS860UPD20191226.DMP table_exists_action=replace job_name=EAS86Demo_impdp exclude=statistics LOGFILE=impdp221012.log
关于EASCloud8.6 Demo账套(oracle)恢复说明
本文2024-09-16 22:02:31发表“eas cloud知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-eas-45558.html