How to automate RMAN Backup Scripts.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: How to automate RMAN Backup Scripts.

  1. #1
    Join Date
    Nov 2001
    Posts
    110

    How to automate RMAN Backup Scripts.

    I do know how to write RMAN Scripts but am not sure how to automate the running of those scripts in the Unix as well as the Windows enviornment. any help is appreciated.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    man cron

  3. #3
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Originally posted by davey23uk
    man cron
    yeah

    cron man
    I'm stmontgo and I approve of this message

  4. #4
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    or in windows you need to be where it's AT
    I'm stmontgo and I approve of this message

  5. #5
    Join Date
    Nov 2001
    Posts
    110
    What is AT

  6. #6
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    C:\Documents and Settings\sm900038\Desktop>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.


    C:\Documents and Settings\sm900038\Desktop>
    I'm stmontgo and I approve of this message

  7. #7
    Join Date
    Nov 2001
    Posts
    110
    thanks stmontgo for the detailed response. It is a lot of help!

  8. #8
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    submit the job using something like this.....

    at every 1:00 /every monday c:\backups\rman_bkp.bat
    I'm stmontgo and I approve of this message

  9. #9
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    CRON, AT :-)

    How about using PL/SQL?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  10. #10
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Can you use PL/SQL to schedule RMAN without using Java or external proc...? Dont think so!

Posting Permissions

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


Click Here to Expand Forum to Full Width