Omniback: Appending sessions to the same tape

[Fedon Kadifeli]

We want to get Oracle online backups through Omniback. We configured the necessary RMAN scripts into two Backup Datalists:

(1) Full: Gets the whole database backup (about 20GB).
(2) ArchiveAll: Gets the backup of all archive logs and deletes them.

Both datalists have the Protection backup option set to None.

I scheduled these Datalists as follows:

(1) Every day at 22:00
(2) Every day at 10:00, 18:00 and 23:00

Both Datalists use a single Media Pool which has currently 6 tape cartridges. This Media Pool has "Loose" Media Allocation Policy and "Appendable" Media Usage Policy.

What I want to do is this:

Use a new tape cartridge each time I start full backup (at 22:00) and APPEND the other sessions (at 23:00, 10:00 and 18:00) to the same cartridge. Currently Omniback uses a different cartridge for each session.

[Andreas Voss]

Hi,

add the medias from the pool into the preallocation list of the backup specifications. At my site this works - OB uses the media in the allocation order (yes it appends). To prevent using the tape next day i move (script based) the used tape after all backups have finisched into a different pool.

Regards

[Fedon Kadifeli]

I think the problem is related to RMAN. Omniback cannot (?) determine the size of the new Archive Log session, so it cannot decide whether the last cartridge has enough space for the new session or not, and as a result it uses a new cartridge...

[Madanagopalan S]

I am also doing the same online backup of database and offline backup of
application on the same tape. I have created the scsi library for one exchange
and made the policy to strict and usage policy to "Appendable"

[Madanagopalan S]

protection should be there. otherwise the media management take it as overwrite.