Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, mustafa.

Asked: December 18, 2018 - 2:15 pm UTC

Last updated: December 20, 2018 - 7:30 am UTC

Version: 11G R2

Viewed 1000+ times

You Asked

Schedule “backup Oracle database” as following:
1- Saturday backup incremental 0 at 22 :15
2- Rest of the week incremental 1 at 23:00

and Connor said...

Why not just use cron for this ?

15 22 * * 6  backup.sh 0
00 23 * * 0,1,2,3,4,5 backup.sh 1


where backup.sh just runs RMAN with the passed parameter, eg

#!/bin/ksh
print "backup incremental level $1 database" | rman target /


Obviously you'd add more logging and appropriate environment setup in your script, but you get the idea

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

mustafa alasfar, December 19, 2018 - 10:39 am UTC

my OS is WIN7
Connor McDonald
December 20, 2018 - 7:30 am UTC

Task Scheduler and a CMD file.

More to Explore

Backup/Recovery

Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.