Scheduling RMAN
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Scheduling RMAN

  1. #1
    Join Date
    Jan 2006
    Location
    Bangalore,IND
    Posts
    47

    Scheduling RMAN

    I am new to RMAN, excuse me if i ask very basic.

    I have been using Export/import for quite a long time and my job requires me to implement RMAN and I recently configured RMAN to take backup. I was successfull in executing it in command line.

    But how should i do schedule the RMAN backup which needs to be done at midnight 1am.

    Can anyone take time to explain me how should i do?

    My environment is Oracle 9i on Windows 2000 and solaris.

    thanks in advance.

    ---------------
    Manasa

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    through the windows scheduler or through your backup software if you use one

    cron for unix

  3. #3
    Join Date
    Jan 2006
    Location
    Bangalore,IND
    Posts
    47
    hi Davey23uk,

    Either in Windows scheduler or Cron, i have the RMAN scripts as stored in the catalog database for various backups.

    should i need to create as batch file and run them in scheduler and the same way store the RMAN scripts as file and execute through cron.

    Is that the right way?

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    You can come up with a wrapper script that would connect to rman and invoke the perticular backup operation. Then from your scheduler invoke this wrapper at the specified time.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Jan 2006
    Location
    Bangalore,IND
    Posts
    47
    Quote Originally Posted by sambavan
    You can come up with a wrapper script that would connect to rman and invoke the perticular backup operation. Then from your scheduler invoke this wrapper at the specified time.

    Sam
    Is that the same what i said above, if not can you detail the steps to put the model you suggested into action?

    thanks

  6. #6
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    You don't have to call the entire rman scripts that you had stored in the catalog.

    say for example.

    you catalog may contain

    Code:
    replace script lterm_whole_db_backup_disk {
    #
    execute script log_switch_chkpt;
    execute script archive_log_current;
    execute script backup_cf_to_disk;
    execute script allocate_2_disks;
    backup
     full
    #skip offline
    #skip readonly
     skip inaccessible
     tag lterm_disk
     filesperset 2
     format '/backup/%d/df_%d_t%t_s%s_p%p_lterm_disk'
     database plus archivelog keep until time "TO_DATE(SYSDATE+(365*7))" LOGS;
    execute script release_2_disks;
    execute script log_switch_chkpt;
    execute script archive_log_current;
    in your warpper script all you have to do is

    Code:
    rman 
    connect target user/password@db
    connect catalog user/password@catalogdb
    run {
    execute script lterm_whole_db_backup_disk;
    }
    check for errors and send mail if it fails
    Then in your scheduler invoke the wrapper script.

    This was what I meant.

    Sam
    Last edited by sambavan; 01-05-2006 at 02:37 PM.
    Thanx
    Sam



    Life is a journey, not a destination!


  7. #7
    Join Date
    Jan 2006
    Location
    Bangalore,IND
    Posts
    47
    Sambavan, thanks for your lucid details.

    -Manasa

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