Oracle在Windows的常规备份

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

SQL> connect admin/zhaona as sysdba ;
已连接。
SQL> create directory dpdata as 'c:/temp';

SQL> grant read,write on directory dpdata to public ;

授权成功。

SQL> exit
从 Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options 断开

C:/>expdp admin/zhaona schemas=admin dumpfile=lsrt0923.dmp DIRECTORY=dpdata

--创建表空间
CREATE TABLESPACE "EAS_D_RTLS_STANDARD" DATAFILE  'D:/db/EAS_D_RTLS_STANDARD.ora' SIZE 500M;

ALTER DATABASE DATAFILE 'D:/db/EAS_D_RTLS_STANDARD.ora' AUTOEXTEND ON;
--创建临时表空间
CREATE TEMPORARY TABLESPACE "EAS_T_RTLS_STANDARD" TEMPFILE 'D:/db/EAS_T_RTLS_STANDARD.DBF' SIZE 50M;

ALTER DATABASE TEMPFILE 'D:/db/EAS_T_RTLS_STANDARD.DBF' AUTOEXTEND ON;
--创建用户
CREATE USER RTLS IDENTIFIED BY kingdee DEFAULT TABLESPACE EAS_D_RTLS_STANDARD TEMPORARY TABLESPACE EAS_T_RTLS_STANDARD;
--用户赋权
grant dba to RTLS;
--用户赋予密码
alter user RTLS identified by kingdee;

--指定路径
create directory dbpath as 'c:/db';

--运行中执行cmd,在cmd执行，导入DMP格式的备份文件
c:/>impdp RTLS/kingdee dumpfile=dbpath:LSRT0923.dmp logfile=dbpath:export.log remap_schema=ADMIN:RTLS remap_tablespace=EAS_D_ADMIN_STANDARD:EAS_D_RTLS_STANDARD,EAS_T_ADMIN_STANDARD:EAS_T_RTLS_STANDARD job_name=JB_RTLS

用户名：RT_HYJC 

EAS_D_HAIYA_STANDARD  EAS_T_HAIYA_STANDARD