Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

How to schedule database backup from a barlist

Printaporn_1
Esteemed Contributor

How to schedule database backup from a barlist

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,
enjoy any little thing in my life
2 REPLIES
Vincenzo Restuccia
Honored Contributor

Re: How to schedule database backup from a barlist

Try with sleep in post-exec.
Joseph T. Wyckoff
Honored Contributor

Re: How to schedule database backup from a barlist

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.
Omniback and NT problems? double check name resolution, DNS/HOSTS...