上面脚本的意思,大概就是备份一个 dmp文件出来,备份的模式是DBO 模式,并删除7天前的备份。
@echo off
echo author:xuekai
echo 2022/11/11
rem 设置环境变量
set user_schema=DBO
set NLS_DATE_FORMAT=yyyy-mm-dd hh24:mi:ss
set currenttime=%date:~0,4%%date:~5,2%%date:~8,2%
set logtime=%date:~0,4%_%date:~5,2%_%date:~8,2%_%time:~0,2%_%time:~3,2%_%time:~6,2%
rem 其他可能用到的命令
rem sc start DmAPService
md D:\dmdbms\data\dmbak
cd /d D:\dmdbms\bin
dexp.exe SYSDBA/SYSDBA SCHEMAS=%user_schema% file=D:\dmdbms\data\dmbak\%user_schema%_%currenttime%.dmp log=D:\dmdbms\data\dmbak\%logtime%.log
rem delete 7 days files
forfiles /p "D:\dmdbms\data\dmbak" /d -7 /c "cmd /c echo deleting @file ... && del /f @path"
pause