一、oracle数据库备份
$expdp \"\/ as sysdba\" schemas=HPRPRD001 directory=easback dumpfile=easexpdp20140811AM.dmp logfile=easexpdp20140811AM.log
二、数据库的恢复
1、sqlplus执行创建用户、文件控件、tmp空间create tablespace "EAS_D_HPRTST140811_STANDARD" datafile '/oradata1/oradata/EAS_D_HPRTST140811_STANDARD.ORA' size 2000M autoextend on;
create temporary tablespace "EAS_T_HPRTST140811_STANDARD" tempfile '/oradata1/oradata/EAS_T_HPRTST140811_STANDARD.DBF' size 500M autoextend on;
create user HPRTST140811 identified by kingdee default tablespace EAS_D_HPRTST140811_STANDARD temporary tablespace EAS_T_HPRTST140811_STANDARD;
grant create session,create table,create procedure,create sequence,create trigger,create view,SELECT ANY DICTIONARY,CREATE MATERIALIZED VIEW,alter profile
to HPRTST140811;
2、导入备份出来的数据库文件
oracle用户下执行: