Oracle Database automatic backup script under Windows

1. Automatically generate Oracle backup files based on date

@echo off

Echo is backing up the Oracle database, please wait a moment ...

Exp userid= ' username/password @sid ' file=d:\bak\res_%date:~0,4%%date:~5,2%%date:~8,2%.dmp log=d:\bak\res_%date:~0,4%%date:~ 5,2%%date:~8,2%.log Owner=res

The echo task is complete!

2. Automatically generate Oracle backup files based on date time and seconds

@echo off

Echo is backing up the Oracle database, please wait a moment ...

Exp userid= ' username/password @sid ' file=d:\bak\res_%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%.dmp Log=d:\bak\res_%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%.log

The echo task is complete!

3. Auto-Exit After end of backup with exit:

@echo off

Echo ================================================

Automated backup scripts for Oracle databases in the Echo Windows environment

Echo 1. Use the current date to name the backup file.

Echo 2. Automatically delete backups up to 7 days ago.

Echo ================================================

:: Remove the current time in "YYYYMMDD" format.

Set backupdate=%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%

:: Create a backup directory.

If not exist "D:\backup\data" mkdir D:\backup\data

If not exist "D:\backup\log" mkdir D:\backup\log

Set Datadir=d:\backup\data

Set Logdir=d:\backup\log

Exp userid= ' username/password @sid ' file=%datadir%\data_%backupdate%.dmp log=%logdir%\log_%backupdate%.log

:: Delete the backup 7 days ago.

forfiles/p "%datadir%"/s/m * */d-7/C "cmd/c del @path"

forfiles/p "%logdir%"/s/m * */d-7/C "cmd/c del @path"

Exit

Note: If sometimes we write bat script execution flash past, cannot be wrong, then I can add a pause at the end of the script (such as the above script can change exit to pause), after the end of the pause, you will be prompted to press any key to continue or exit, so I can know what error.

This article is from "Operation and maintenance record Mei Ling" blog, please be sure to keep this source http://meiling.blog.51cto.com/6220221/1573848

Oracle Database automatic backup script under Windows