完美的Oracle定时备份

cd..
set dump_bak=F:/JJTDATA_BAK
set BKFILE=%Date:~0,4%%Date:~5,2%%Date:~8,2%
set HHMMSS=%time:~0,2%%time:~3,2%%time:~6,2%
set FilePrefix=jjtdata
set UserName=jjt123
set Password=jjt123
set NetServer=ORAPOP
set ORA_HOME=F:/oracle数据库定时备份
cd %ORA_HOME%
exp %UserName%/%Password%@%NetServer% file=%dump_bak%/%FilePrefix%_%BKFILE%_%HHMMSS%.dmp

 

 

 

exp kingdee09/kingdee@ora file='F:/OracleBack/201012151840.dmp'  log='F:/OracleBack/201012151840.log' statistics=none full=y

 

CREATE TABLESPACE "EAS_D_LSERP_STANDARD" DATAFILE  '/u01/EAS_D_LSERP_STANDARD.ora' SIZE 6000M;

CREATE TEMPORARY TABLESPACE "EAS_T_LSERP_STANDARD" TEMPFILE '/u01/EAS_T_LSERP_STANDARD.DBF' SIZE 2000M;

CREATE USER kingdee09 IDENTIFIED BY kingdee DEFAULT TABLESPACE EAS_D_LSERP_STANDARD TEMPORARY TABLESPACE EAS_T_LSERP_STANDARD;

CREATE USER EASADMIN IDENTIFIED BY kingdee DEFAULT TABLESPACE EAS_D_LSERP_STANDARD TEMPORARY TABLESPACE EAS_T_LSERP_STANDARD;

grant dba to kingdee09;

imp kingdee09/kingdee@ora fromuser=kingdee1 touser=kingdee09 file='F:/OracleBack/201012111827.dmp' ignore=y