Oraclebackup.bat file as follows, open with Notepad
REM Call Logicbackup.bat%dump_dir%
REM ==========================================================================================
REM This batch implements a database logical backup of the Oracle database version that supports the EXP database, as follows: Exporting data to
REM Dump_bak database directory, and then put the DMP file in the RAR format in the same day backup date named directory, easy to later press
REM is restored to date.
Rem
REM requires configuration of parameter description:
REM Bat_home: The directory in which this batch is processed;
REM Bkdir: Is the parameter dump_dir that is passed in when this batch is invoked, that is, the data file directory to be backed up.
REM Bkfile: Backup date
REM HHMMSS: Backup time
rem fileprefix: prefix of backup filename
REM UserName: User name for backup
REM Password: Password for backup
REM NetServer: NET service Name of the connection database
REM Ora_home: Directory of the execution exp file
REM Author:majy
REM time:2007-06-25
REM ==========================================================================================
REM Cd..
Set Dump_bak=f:/jjtdata_bak
Set bkfile=%date:~0,4%%date:~5,2%%date:~8,2%
Set hhmmss=%time:~0,2%%time:~3,2%%time:~6,2%
Set Fileprefix=jjtdata
Set username=jjt123
Set password=jjt123
Set Netserver=orapop
Set Ora_home=f:/oracle Database scheduled backup
CD%ora_home%
Exp%username%/%password%@%netserver% file=%dump_bak%/%fileprefix%_%bkfile%_%hhmmss%.dmp Action: 1. According to the file Oraclebackup.bat inside the Set method operation.
2. Define a scheduled task for Windows .