记一次生产库的impdp恢复演练

最新推荐文章于 2021-04-03 10:03:43 发布

cperrkg97932

最新推荐文章于 2021-04-03 10:03:43 发布

阅读量116

点赞数

源库：aix 10.0.2

目标库：win server 11.0.2.0

(1)创建表空间

1、create tablespace EAS_D_EAS522_GOLD_STANDARD logging datafile 'D:\app\Administrator\oradata\renhe\EAS_D_EAS522_GOLD_STANDARD.dbf' size 15g autoextend on extent management local;

(2)创建临时表空间

create temporary tablespace EAS_D_RHGF_TEMP1 tempfile 'D:\app\Administrator\oradata\renhe\EAS_D_RHGF_TEMP1.dbf' size 5g autoextend on extent management local;

(3)创建用户(rhpdm,rhjtoa rhbs rhgf)

create user rhgf identified by xxx default temporary tablespace EAS_D_RHGF_TEMP1;

create user rhpdm identified by xx

create user rhjtoa identified by xx

create user rhbs identified by xx

（4）创建目录

create directory RH_DUMP as 'D:\ProgSETUP\RHGF20170603' （路径是存放备份文件的路径）

（5）给用户授权

grant read,write on directory RH_DUMP to rhgf;

grant connect,resource,dba to rhgf

(6)还原备份

impdp rhgf/xx directory=RH_DUMP dumpfile=RHGF_U_20170603.dmp (table_exists_action=replace;这个参数在重复执行时候使用第一次恢复时不需要用)

注意事项

(1) ora-01653 EAS_D_EAS522_GOLD_STANDARD表空间无法扩展解决方法如下建多个数据文件

ALTER TABLESPACE EAS_D_EAS522_GOLD_STANDARD ADD DATAFILE 'D:\app\Administrator\oradata\renhe\EAS_D_EAS522_GOLD_STANDARD_2.dbf' SIZE 500m AUTOEXTEND ON NEXT 500m MAXSIZE UNLIMITED;

(2):数据库字符集要一致最好是用utf8

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29438041/viewspace-2140428/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29438041/viewspace-2140428/