Implement regular Oracle backup using Windows Task Plan

First, write a batch processing file and give an example. CopyCodeThe Code is as follows: Set RQ = % Date :~ 0, 10%
Exp system/system's 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 and use it later in the backup file name. File = D: \ backup \ Bak % RQ % is the backup file name of the exported database, full = Yes, indicates that all data is exported. C: \ progra ~ 1 \ WinRAR \ rar.exe A-df d: \ backup \ Bak % RQ % d: \ backup \ is the compressed file. The last one is to move the compressed file to D: \ databasebackupd: \ databasebackup directory.

You may be unfamiliar with parameters after exp. You can enter exp help = y at a command prompt to learn about these parameters.