Oracle timed Backup ____oracle

Source: Internet
Author: User

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
.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.