Oracle逻辑备份脚本

set nls_lang=simplified chinese_china.zhs16gbk
e:
cd E:\autobak
set day=%DATE:~8,2%
set month=%DATE:~0,4%%DATE:~5,2%
if %DATE:~5,2% EQU 01 (
set /a delyear=%DATE:~0,4%-1
set /a delmonth=%delyear%12
) else (
set /a  delyear=%DATE:~0,4%
set /a  delmonth=%month%-1
)
IF %DATE:~8,2% GTR 07 rd /q/s E:\autobak\%delmonth%\

if %DATE:~8,2% LEQ 07 (
set /a delday=%delmonth%%day%+25
) else (
set /a delmonth=%month%
set /a delday=%month%%day%-7
)
rd /q/s E:\autobak\%delmonth%\%delday%
IF NOT EXIST %month% md %month%
cd %month%
IF NOT EXIST %month%%day% md %month%%day%
exp jhzy65/jhzy65@192.168.1.13:1523/node2  file=e:/autobak/%month%/%month%%day%/%month%%day%_node2.dmp log=e:/autobak/%month%/%month%%day%/%month%%day%_node2.log