Scheduling Oracle database backup through Batch file

As per day to day business transactions  saved in a database (Here ref is oracle) . The database
backup in large/small organization is prime importance, follows example depicts how to take backup in routine by using batch file scheduling in windows environment.


Syntax:
EXP userid=`userid/password@sid owner=`schemaowner`
File=`path with filename.dmp `
log=`logfile path with dmp`

Here User ID might be SYSTEM,MANAGER with its password
-sid means  The Oracle System ID (SID) is used to uniquely identify a particular database on a system.


Exporting the Whole schema

Save this 4 lines of code and name the file BUP_NEW_BACKUP.bat

EXP  USERID=SYSTEM/yourpassword@G_PPMS
FILE=D:\backup.dmp OWNER=TRUSTGA(User Name)
LOG=D:\backup.LOG
COPY D:\backup.DMP  \\compname\backup

After saving this file, need to schedule a task in windows environment

To open Scheduled Tasks, click Start, click All Programs, point to Accessories, point to System Tools, and then click Scheduled Tasks.

To schedule a new task:

1. Double-click Add Scheduled Task to start the Scheduled Task Wizard, and then click Next in the first dialog box.
2. The next dialog box displays a list of programs that are installed on your computer, either as part of the Windows XP operating system, or as a result of software installation.
   
   Use one of the following procedures:
   • If the program that you want to run is listed, click the program, and then click Next.
   • If you want to run a program, script, or document that is not listed, click Browse, click the folder and file that you want to schedule, and then click Open.
3. Type a name for the task, and then choose one of the following options:
   • Daily
   • Weekly
   • Monthly
   • One time only
   • When my computer starts (before a user logs on)
   • When I log on (only after the current user logs on)
4. Click Next, specify the information about the day and time to run the task, and then click Next.
   
   Note that the information about the day and time to run the task vary depending on the selection that you made in the previous wizard dialog box. For example, if you chose Weekly, you must indicate the day of the week, the time, and if the task should run every week, every 2 weeks, every 3 weeks, and so on.
5. Type the name and password of the user who is associated with this task. Make sure that you choose a user with sufficient permissions to run the program. By default, the wizard selects the name of the user who is currently logged on.
6. Click Next, and then click Finish after you verify the choices that you have made.

 That it! your database backup regularly saved at specified
 location what you write in batch file. Just track that file
 in a daliy basis means rename it manully and check .dmp
 file size for ensuring backup is going right way.