dmp还原oracle linux,linux下的Oracle备份与还原

su oralce用户下，system用户进入sqlplus操作：

--创建表空间

CREATE TABLESPACE "EAS_D_HAIYA_STANDARD" DATAFILE  '/kingdee/oradata/oradata/HY/EAS_D_HAIYA_STANDARD.ora' SIZE 5000M;

ALTER DATABASE DATAFILE '/kingdee/oradata/oradata/HY/EAS_D_HAIYA_STANDARD.ora' AUTOEXTEND ON;

--创建临时表空间

CREATE TEMPORARY TABLESPACE "EAS_T_HAIYA_STANDARD" TEMPFILE '/kingdee/oradata/oradata/HY/EAS_T_HAIYA_STANDARD.DBF' SIZE 1000M;

ALTER DATABASE TEMPFILE '/kingdee/oradata/oradata/HY/EAS_T_HAIYA_STANDARD.DBF' AUTOEXTEND ON;

--创建用户

CREATE USER HY0728 IDENTIFIED BY kingdee DEFAULT TABLESPACE EAS_D_HAIYA_STANDARD TEMPORARY TABLESPACE EAS_T_HAIYA_STANDARD;

--用户赋权

grant dba to HY0728;

--用户赋予密码

alter user HY0728 identified by kingdee;

su oralce用户下操作：

--备份正式数据库

exp kingdee1/lsjygs@oral file='D:/20101210x.dmp'  log='D:/20101210x.log' statistics=none full=y

statistics=none的作用是去掉报统计错误

--导入DMP格式的备份文件，不用上传100727x.log文件imp HY0728/kingdee fromuser=haiya touser=HY0728 file='/kingdee/100727x.dmp' log='/kingdee/100727x.log' ignore=y