Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2009
    Posts
    2

    Unanswered: schedule export backup of oracle

    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

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    That would certainly depend on your operating system, which you chose not to share with us.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Mar 2009
    Posts
    2

    Oralce Export backup schedule.

    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

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Read the manual pages for cron.
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Sep 2004
    Posts
    1

    Red face Oracle Back up

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

  6. #6
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    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.

  7. #7
    Join Date
    Sep 2009
    Location
    Ontario
    Posts
    1,057
    Provided Answers: 1
    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.

  8. #8
    Join Date
    Sep 2009
    Location
    Ontario
    Posts
    1,057
    Provided Answers: 1
    If I had waited until tomorrow, it would have been exactly one year.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •