cancel
Showing results for 
Search instead for 
Did you mean: 

Disadvantages of a Compressed Backup.

Former Member
0 Kudos

R/All,

Due to space constraint at hard disk we are thinking to use commpression option for our SAP BACKUP.

Our sap configuration is ECC 6+Oracle 10.2+Windows 2003. Backup is happening on only local hard disk.

One of the possiable disadvantage we know that, the restore of compressed backup will take much time compare to non compressed backup.

Kindly guide us about possiable disadvantages further related to compressed backup.

Kind rgds,

Ashwin Mane

Accepted Solutions (1)

Accepted Solutions (1)

volker_borowski2
Active Contributor
0 Kudos

Hi,

did you try to use RMAN with compression.

With RMAN your backup is compressed on the fly (no staged file) with a ZIP type algorithm.

With advanced compression you can swith the compression to MEDIUM which is a good compromise between compression ratio and CPU requirements. We have an average 1:5  ratio for ABAP and 1:2,5 ratio for j2ee systems.

RMAN can be used under control of brbackup.

Volker

Watch out: If you have a direct Oracle License, Advanced compression is a feature that needs to be licensed seperately. If you have the standard SAP license with Oracle included, it is in the package.

Former Member
0 Kudos

R/All,

Thanks to all. We have set the compression option through init<SID>.sap. The backup file size becomes 1/4 smaller. Time taken for backup is also same. We are not facing any load at CPU. We will going to test the restore time with compressed backup soon.

We have found that the Archive backup is also getting compressed same as the database file. Is this normal?

Kind rgds,

Ashwin Mane

Former Member
0 Kudos

Hi Ashwin,

compress=brtools is for all file-level backups, so also for offline/archived redologs. Consider it as a feature

Edgar

Answers (2)

Answers (2)

Former Member
0 Kudos

If you compress with BR*Tools (compress=brtools in init<SID>.sap, see SAP Note https://service.sap.com/sap/support/notes/1173119) you will get the best possible combination of compression vs. backup/restore time. It will use CPU and take a bit longer - you'll have to test and then decide if you can live with it.

Former Member
0 Kudos

Hi

Former Member
0 Kudos

Hi, when you use compress option make sure you have sufficient freespace under sapbackup directory or drive as the backup tool will compress under this folder and then it will be moved to the backup folder you mentioned.

I think the another disadvantage - depends on the your disk/cpu speed the compress/uncompress will take time.

Former Member
0 Kudos

Dear Sunil,

Thank you for your prompt & helpful inputs...

Kind rgds,

Ashwin Mane