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