Show TOC

Hardware Compression for BRARCHIVELocate this document in the navigation structure

Use

When you archive the offline redo log files with BRARCHIVE, performing software compression in advance is useless, since the previously determined compression rates cannot be used for archiving the next redo log files. If BRARCHIVE does not have any information on the compression rates, the default value of 1 is assumed. This means, for example, that when the tape size is 16,000 MB and the redo log files are 200 MB, up to 80 offline redo log files can be archived on a volume.

If, however, a larger number of offline redo log files were written on one day that actually fit on the tape, you can change the parameter tape_size accordingly.

We know from experience that during a hardware compression, the size of the offline redo logs shrinks by around a third. Therefore, you can increase the init<DBSID>.sap parameter tape_size by around 50% (to 24,000 MB in the above example) to reflect the actual compression rate. This enables you to archive many more (up to 120 in the example) offline redo log files with one BRARCHIVE call.

You can define a separate init<DBSID>.sap profile parameter, tape_size_arch, for BRARCHIVE. If you do this, changes to individual parameters do not affect the next database backup with BRBACKUP.

More Information