Use Windows Task Scheduler to implement regular Oracle backups _oracle

Write a batch file first, give an example.

Copy Code code as follows:

Set rq=%date:~0,10%
Exp System/system password @ Local Service name file=d:\backup\bak%rq% Full=yes log=d:\backup\bak%rq% buffer=65536
C:\progra~1\winrar\rar.exe A-DF d:\backup\bak%rq% D:\backup\
move/y D:\backup\*.rar D:\databasebackup

The first one is to set the date string, followed by the backup file name to use it, file=d:\backup\bak%rq% is the backup file name of the exported database, Full=yes, representing all exports. C:\progra~1\winrar\rar.exe a-df d:\backup\bak%rq% D:\backup\ is a compressed file, and the last one is to move the compressed file to the D:\databasebackupd:\ The Databasebackup directory.

You may be unfamiliar with the parameters after exp, you can enter the exp help=y at the command prompt to understand these parameters.