schedule export backup of oracle

satyamurthy · #1 (**permalink**) 03-05-09, 03:41

I want to take an export dump by scheduling the time.

example: if want run oracle exp command at midnight 12 clock.
how do i do it. it is very urgent.

advance thanks .

satya murthy

n_i · #2 (**permalink**) 03-05-09, 11:16

That would certainly depend on your operating system, which you chose not to share with us.

satyamurthy · #3 (**permalink**) 03-11-09, 08:14

I want to take an export dump by scheduling the time. Operating System solaris 5.9

example: if want run oracle exp command at midnight 12 clock.
how do i do it. it is very urgent.

advance thanks .

satya murthy

n_i · #4 (**permalink**) 03-11-09, 10:06

Read the manual pages for cron.

rushtotiku · #5 (**permalink**) 03-04-10, 00:59

i want to take back up for the Oracle Back up at every 12 am midnight on windows 2003 server

pdreyer · #6 (**permalink**) 03-04-10, 03:07

Do Win2003 have the at command?

Code:

C:\>at /?
The AT command schedules commands and programs to run on a computer at
a specified time and date. The Schedule service must be running to use
the AT command.

AT [\\computername] [ [id] [/DELETE] | /DELETE [/YES]]
AT [\\computername] time [/INTERACTIVE]
    [ /EVERY:date[,...] | /NEXT:date[,...]] "command"

\\computername     Specifies a remote computer. Commands are scheduled on the
                   local computer if this parameter is omitted.
id                 Is an identification number assigned to a scheduled
                   command.
/delete            Cancels a scheduled command. If id is omitted, all the
                   scheduled commands on the computer are canceled.
/yes               Used with cancel all jobs command when no further
                   confirmation is desired.
time               Specifies the time when command is to run.
/interactive       Allows the job to interact with the desktop of the user
                   who is logged on at the time the job runs.
/every:date[,...]  Runs the command on each specified day(s) of the week or
                   month. If date is omitted, the current day of the month
                   is assumed.
/next:date[,...]   Runs the specified command on the next occurrence of the
                   day (for example, next Thursday).  If date is omitted, the
                   current day of the month is assumed.
"command"          Is the Windows NT command, or batch program to be run.

kitaman · #7 (**permalink**) 03-04-10, 09:57

Write a script "oracle.unload.script" that will unload the database.This script must create its own environment, so make sure it has a PATH defined and any other environment variables that may be required. If any input is required, it must be redirected from a text file.
Any output should be redirected to a log file.

Add a line like the following to /usr/spool/cron/crontabs/root (assuming job will be run by root)

Code:

01 * * * oracle.unload.script

Do this by either copying the current file, adding this line to the copy, and using 'crontab' to copy the file back over the original. Or just edit the original file and then re-boot the machine.

If you make changes to the unload script, you have to restart the cron manager, for the changes to take effect.

kitaman · #8 (**permalink**) 03-04-10, 10:12

If I had waited until tomorrow, it would have been exactly one year.

Internet Services

Web Development

Digital Marketing

Consumer Tech