Multiple jobs to same tape?

[Arkroyal]

Using BE 9.1 + Oracle Agent. I have enough of a time window to allow me to do an offline and online Oracle database backup overnight. I would like to do the offline and online backups on to ONE tape for disaster recovery purposes.

What I'm thinking is to set the time of the offline backup to say 3:00 AM and then set the time of online backup to 3:01 AM. The idea is that the online backup will start as soon as the offline has finished.

Good idea or not? Anyone have any thoughts?

 

[packdragon]

I think as long as both jobs are using the same media set and the tape has enough space, this should work. However if there are other blank tapes available in that media set, I'm not sure how it chooses which tape to grab. It may take another available tape instead (assuming you have a tape library, if not then nevermind).

- Zoe, that's ZOH-EEE, get it right please
- Just a little ol' MCP at Solien Technology
-

http://www.solien.com

 

[LaChimere]

create a new media set.
schedule your job to run on that media set.
Put only 1 tape in that media set. If there is enought space your backups will fullfil the tape. Becareful to your append time.
Make sure your job will appen to the media instead of overwritte media

If the media is full BE 91 will go in the scratch media. if no tapes are present the job will be queued!

Hopes that helps