-
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
-
through the windows scheduler or through your backup software if you use one
cron for unix
-
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?
-
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!
-
 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
-
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 03:37 PM.
Thanx
Sam
Life is a journey, not a destination!
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|