Scheduling Backups in Oracle Grid Control 10g — Mon-Fri

Posted in: Technical Track

While I like a lot monitoring capabilities and extensibility of Oracle 10g Grid Control it’s lacking a lot in Web GUI usability and ease of use.

Currently we are moving from Oracle Enterprise Manager 9i to Grid Control 10g for one of our client. This client uses many features of OEM besides monitoring – job management, Data Guard and others. One of the requirements to move backups to Grid Control 10g is to be able to schedule incremental level 1 backup to run Only Monday to Friday or on certain days of a month.

The latest release of Grid Control (10.2.0.3 at the time of this writing) is only able to schedule backup jobs with simple interval based on frequency (every month, week and etc). Here is the schedule screen from Web GUI:
Oracle 10g Scheduler

So if you want to schedule incremental backup from Backup Wizard – you will have to do a trick. First create this job using the wizard and then change its schedule. When you editing the job – more options are available:
Job Schedule Editing

I remember that I wasn’t able to do that in some earlier versions — was getting error message that it cannot edit this particular job type. Actually, I think just few days ago I’ve got it in Database Control 10.2.0.3 so it seems same releases of Database Control and Grid Control do not quite share the same code base release.

What still bothers me is that I cannot copy backup job to the Job Library – getting the error Copy To Library is not supported for this job type. Another problem is that I still couldn’t really edit the RMAN script itself later – Backup wizard is not re-entrant in 10g Grid Control like it is in OEM 9i:
9i Backup Editing

Interested in working with Alex? Schedule a tech call.

About the Author

What does it take to be chief technology officer at a company of technology experts? Experience. Imagination. Passion. Alex Gorbachev has all three. He’s played a key role in taking the company global, having set up Pythian’s Asia Pacific operations. Today, the CTO office is an incubator of new services and technologies – a mini-startup inside Pythian. Most recently, Alex built a Big Data Engineering services team and established a Data Science practice. Highly sought after for his deep expertise and interest in emerging trends, Alex routinely speaks at industry events as a member of the OakTable.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *