Using GINZIP to compress the backup directory

[Former Member]

Hello Guys,

Please suggest if this is the right way of doing it.

We have SAP 4.6c on SUSE Linux Enterprise 8 with Oracle.

The backup is done to the disk using BRBACKUP.

So now the question is

Is it advisable to further compress the backup files using GUNZIP.

What we are doing is once the SAP backup is over we gunzip the backup directory to a single and than move the ziped file to tape.

But when we gunzip it the CPU utilization is normally 100% .

So just needed to confirm, whether this practice is recommended by SAP or Oracle.

Thanks and Regards

Pritam

[Former Member · Accepted solution]

Hi,

A common backup strategy for database and non-database files is not a solution since non-database data can better be backed up with operating system tools (such as tar).

SAP provides the tools BRBACKUP, BRARCHIVE, BRRESTORE, BRRECOVER, BRCONNECT, and BRTOOLS to protect the data in your Oracle database. Operating system programs – such as “dd”, “cpio”, or “tar” used directly on UNIX – are too limited and so not suitable for this task.

So Ans to ur question not adv to use these for backup.backup over the network is not rec by sap or oracle.They rec backup on direct tape.

Regards

Vinod

[Former Member · Accepted solution]

Thanks Vinod for the reply.Now have to convince the client

[Former Member · Accepted solution]

Hello Vinod,

But what if someone is using gzip in the initSID.sap

I mean using the parameter compress_cmd = gzip -c $ > $

Is it advisable to use the OS level utility to compress the file.

Is brbackup capable of compressing the files without using any OS level compression utility.

Regards

Pritam

[Former Member · Accepted solution]

Pritam,

As I mentioned Databse includes Database files and Non database files.

This file init<sid>.ora is Non DB file and called parameter files.Usually for 9i series spfile is recmndd.which is binary file.

As this file is Non Db file you can backup with any OS command.To compress you can use GZIP.

There is no question of advice,Its depends on your resources.and this file is very small.

Even u can backup with BRtools or OC command.Each one has its own compressing technique and tools.

Finally nothing to worry too much you can gzip init<sid>.ora and back up the file.

Regards

Vinod

[Former Member]

Is the original backup to disk already compressed?

BRBACKUP allows you to make compressed backups to disk.

[Former Member]

Yes BRBACKUP is compressing the files to the disk.

[Former Member]

Pritam

Yes to make single file you can use gzip,tar or cpio acc to ur convnce.

You can run process in background to make CPU utilisation less which is rec one.

For backup SAP or oracle rec process or cycle.You need to adopt the required process or cycle depends on your requirements and resources.

Vinod