关于EASCloud8.6 Demo账套(oracle)恢复说明

栏目:eas cloud知识作者:金蝶来源:金蝶云社区发布:2024-09-16浏览:1

关于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)恢复说明

几经摸索试验,终于搞定了!借鉴了8.5账套的恢复说明https://wenku.my7c.com/article/43437547444568202?channel_level=kdclub,非常感...
点击下载文档
分享:
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息