oracle定期备份的命令

老鸟们说他们不用OMS，好吧，反正我也一直安装不上OMS

写一个OracleBackup.bat，用WINDOWS的任务计划：

-----------------------------------------------------------------------

set t=%time:~0,2% set exp1=explivell/hydb-222-yelw@hysys_59.50.64.222 owner=livell file=e:\oracledb\backup\hysys_59.50.64.222_%date:~0,4%%date:~5,2%%date:~8,2%0%time:~1,1%%time:~3,2%.dmp log=e:\oracledb\backup\hysys_59.50.64.222_%date:~0,4%%date:~5,2%%date:~8,2%0%time:~1,1%%time:~3,2%.log set exp2=exp livell/hydb-222-yelw@hysys_59.50.64.222 owner=livell file=e:\oracledb\backup\hysys_59.50.64.222_%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%.dmp log=e:\oracledb\backup\hysys_59.50.64.222_%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%.log if %t% leq 9 (%exp1%) else (%exp2%)

---------------------------------------------------------------------

 

其中类似“%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%“这一部分是BAT的日期时间变量。

如果对你有帮助麻烦评论一下，谢谢