Scheduling RMAN

[manasa]

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

[davey23uk]

through the windows scheduler or through your backup software if you use one

cron for unix

[manasa]

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?

[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

[manasa]

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

[sambavan]

You don't have to call the entire rman scripts that you had stored in the catalog.

say for example.

you catalog may contain

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

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

[manasa]

Sambavan, thanks for your lucid details.

-Manasa