topic Re: How to schedule database backup from a barlist in Operating System - HP-UX

How to schedule database backup from a barlist

Printaporn_1 — Mon, 23 Apr 2001 09:12:35 GMT

Hi,

I have 2 databases , I schedule the first backup in omniback and after the first finish I want to backup the second database.
then I put
/opt/omni/bin/omnib -oracle8_list < List name> - barmode

after the first finish It call post-exec and the second backup was queuing.
but It will queue forever with error "waiting for device to get free" , because I use same device with first backup.
How can I solve this problem. or other workaround ?

thanks in advance,

Re: How to schedule database backup from a barlist

Vincenzo Restuccia — Mon, 23 Apr 2001 09:27:21 GMT

Try with sleep in post-exec.

Re: How to schedule database backup from a barlist

Joseph T. Wyckoff — Tue, 24 Apr 2001 00:09:53 GMT

You really should not chain backups by spawning them in post exec.

I suppose you could do something like an AT NOW OMNIB...

Look at your backup job run time (say 1.5-2.5 hours.)

Schedule your second job to start at a reasonable time - in my example two hours after the first. Omniback will queue the job... for a while, waiting for the tape drive to free. I think the default wait is up to 30 minutes.

Given that - if your backup job, for example a LOG backup, varies from 5 minutes to 20 minutes... and assuming one job MUST run after the other, then schedule the jobs 15 minutes apart.

Good Luck.