Oracle数据库的自动备份脚本

@echo off
echo ================================================
echo Windows环境下Oracle数据库的自动备份脚本
echo 1. 使用当前日期命名备份文件。
echo 2. 自动删除之前的备份。
echo ================================================
set curdate=%date:~0,4%%date:~5,2%%date:~8,2%
set backuppath=D:\backup\data
md %backuppath%
::备份前先删除之前备份文件
del %backuppath%\*.* /F /S /Q
if not exist "D:\backup\data" mkdir D:\backup\data
exp scmdba/scm_321@192.168.1.13/shnsscmora file=%backuppath%\%curdate%.dmp owner(scott) log=%backuppath%\%curdate%.log

转载于:https://www.cnblogs.com/yangpeng-jingjing/p/8391061.html