Oracle 备份还原

1、备份

     在Oracle服务端服务器上，dos命令下下命令

expdp biz_cmcp_backstage_test/Admin1234@orcl dumpfile=biz_cmcp_backstage_test201401219.dmp

备份的路径为：app\Administrator\admin\orcl\dpdump，还原也是一样的道理，确保该路径下有对应的文件

 

2、在另外一台Oracle服务端上还原

    在PLSQL中下命令先创建用户

-- Create the user 

create user biz_cmcp_backstage_test
identified by "Admin1234"
default tablespace USERS
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to biz_cmcp_backstage_test;
grant ctxapp to biz_cmcp_backstage_test;
grant dba to biz_cmcp_backstage_test;
grant exp_full_database to biz_cmcp_backstage_test;
-- Grant/Revoke system privileges
grant alter any index to biz_cmcp_backstage_test;
grant alter any table to biz_cmcp_backstage_test;
grant create any index to biz_cmcp_backstage_test;
grant create any table to biz_cmcp_backstage_test;
grant create session to biz_cmcp_backstage_test;
grant drop any index to biz_cmcp_backstage_test;
grant drop any table to biz_cmcp_backstage_test;
grant select any table to biz_cmcp_backstage_test;
grant unlimited tablespace to biz_cmcp_backstage_test;

 　　再在Oracle服务端服务器上还原数据库，dos命令下下命令

impdp biz_cmcp_backstage_test/Admin1234@orcl dumpfile = biz_cmcp_backstage_test20141219.dmp 

如果有的schema是改过的，那么就要这么写了

impdp biz_cmcp_backstage_test/Admin1234@orcl dumpfile = biz_cmcp_backstage_test20141219.dmp remap_schema=Biz_Embank:biz_cmcp_backstage_test