Results 1 to 3 of 3

Thread: Oracle

  1. #1
    Join Date
    Jun 2003
    Posts
    45

    Unanswered: Oracle

    Hi Experts,
    Please explain how to schedule a backup using crontab unix file.

    Please explain with sample codes

    sincerely
    sudheer

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1

    Re: Oracle

    Originally posted by sudheer_ics
    Hi Experts,
    Please explain how to schedule a backup using crontab unix file.

    Please explain with sample codes

    sincerely
    sudheer

    crontab
    01 00 * * * do_oracle_backup
    Ctl-D

    will invoke the script do_oracle_backup daily at 0001

  3. #3
    Join Date
    Apr 2003
    Location
    Los Alamos/Santa Fe, NM
    Posts
    69

    Crontab

    Create the script you would like to run from your crontab. A crontab is a list of commands, one per line, that will execute automatically at a given time. Numbers are supplied before each command to specify the execution time. The numbers appear in five fields, as follows:

    Minute 0-59
    Hour 0-23
    Day of month 1-31
    Month 1-12
    Day of week 0-6, with 0=Sunday

    Use a comma between multiple values, a hyphen to indicate a range, and an asterisk to indicate all possible values. For example:

    59 3 * * 5 find / -print | backup_program

    This command backs up system files every friday at 3:59am.

    0 0 1,15 * * echo "Timesheets due" | mail_user
    This command mails a reminder on the 1st and 15th of the month at midnight.

    Contab options are:
    -e to edit
    -l to list
    -r Delete the user's file in the crontab directory

    If you cannot access crontab, contact you system admin. They can set you up.
    Michellea Southern-David

Posting Permissions

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