提供一个windows备份oralce数据库的bat脚本
时间: 2024-05-28 16:02:41 浏览: 141
以下是一个简单的Windows备份Oracle数据库的BAT脚本:
@echo off
set ORACLE_SID=your_sid
set ORACLE_HOME=your_oracle_home
set BACKUP_DIR=C:\backup
set BACKUP_FILE=%BACKUP_DIR%\db_backup_%date:~10,4%%date:~4,2%%date:~7,2%.dmp
echo backing up database to %BACKUP_FILE%
expdp username/password@%ORACLE_SID% directory=data_pump_dir dumpfile=%BACKUP_FILE% full=y
echo backup completed successfully.
阅读全文