RE: Creating Grid backup jobs through a script

From: John Hallas <>
Date: Thu, 5 Mar 2009 14:40:16 +0000
Message-ID: <>

Using EM and from within Job Activity I cannot 'create like' or 'copy to library' from a backup creating using the 'Schedule Backup' wizard.

However I can create a new library job using the 'create library job, RMAN script' drop down menu. I save that as a library job and from there I can use that as a template to create other library jobs.

Whilst this is quicker than having to use the schedule backup wizard I thought that there might be a better and more efficient way to create backups for existing databases. Moving forward it is easy to add backups for each new database.

I think we will end up using Grid to manage our backups as it does seem a central point of reference and whilst crontab is very reliable it is a matter of logging onto each server individually to check/change settings whereas all the relevant information can be gathered form the OMS repository once the backups are created.

-----Original Message-----
From: [] On Behalf Of Rich Jesse Sent: 03 March 2009 15:14
Subject: Re: Creating Grid backup jobs through a script

Hey Ian,

I think we may be talking two different types of backup jobs.

Manually created jobs from the Job Library screen are fully manageable. Ones created from the "Schedule Backup" wizard on a database target's Maintenance tab are not.

Wm Morrison Supermarkets Plc is registered in England with number 358949. The registered office of the company is situated at Gain Lane, Bradford, West Yorkshire BD3 7DL. This email and any attachments are intended for the addressee(s) only and may be confidential.

If you are not the intended recipient, please inform the sender by replying to the email that you have received in error and then destroy the email. If you are not the intended recipient, you must not use, disclose, copy or rely on the email or its attachments in any way.

Wm Morrison Supermarkets PLC accepts no liability or responsibility for anything said in the email or its attachments and gives no warranty as to accuracy. It is the policy of Wm Morrison Supermarkets PLC not to enter into any contractual or other obligations by email.

Although we have taken steps to ensure the email and its attachments are virus-free, we cannot guarantee this or accept any responsibility, and it is the responsibility of recipients to carry out their own virus checks.

Received on Thu Mar 05 2009 - 08:40:16 CST

Original text of this message