Unable to take online backup in disk oracle 10g with AIX

[former_member518118]

Hello All,

We are facing backup issue in oracle 10g with AIX, we are unable to take online backup.

all parameters in initSID.sap are correct and not able to take backup in disk using brtools as well as via DB13.

command

BR0101I Parameters

Name                           Value

oracle_sid                    SID

oracle_home                    /oracle/SID/102_64

oracle_profile                 /oracle/SID/102_64/dbs/initSID.ora

sapdata_home                   /oracle/SID

sap_profile                    /oracle/SID/102_64/dbs/initSID_disk.sap

backup_mode                    ALL

backup_type                    online

compress                       only

compress_cmd                   compress -c $ > $

exec_parallel                  0

system_info                    sidadm/sidadm devscm AIX 1 6 0000D63BD400

oracle_info                    ASD 10.2.0.4.0 8192 7789 402319440 aildevscm UTF8 UTF8 4233452999

sap_info                       702 SAPSR3 0002LK0003ASD0011B19243729580015Maintenance_ORA

make_info                      rs6000_64 OCI_102 Mar  6 2010

command_line                   brbackup -jid ALL__20151104150038 -u / -c force -t online -m all -p initSID_disk.sap

Error

BR0201I Compressing /oracle/SID/sapdata5/sr3_5/sr3.data5

BR0278E Command output of 'LANG=C compress -c /oracle/SID/sapdata1/sr3_11/sr3.data11   /usr/sap/SID/SYS/exe/run/brtools -f getcompr -':

/oracle/SID/sapdata1/sr3_11/sr3.data11: Invalid argument

Also run compression rate update but no luck.

Referred note 44515  994136  948294

Thread https://scn.sap.com/thread/3263137

Please help for the same.

Regards

Naveen

[former_member182657]

Hi,

BR0051I BRBACKUP 7.20 (1)

Could you apply patch for current BR*tools version with the latest available at SMP to check again ?You could refer SAP Note  1723121 - Corrections in BR*Tools 7.20 patch 24     

or best would be to apply the latest for version 7.20.

Hope this will help you.

Good luck !!

[former_member518118]

Hi Gaurav,

Already used BR0651I BRTOOLS 7.20 (1)

Regards

Naveen

[former_member182657]

Hi Naveen,

Its perfect that you've used mentioned BR0651I BRTOOLS 7.20 (1),but my means is to patch the BRTOOLS with the latest available from SMP (Latest might be 42).

Kindly refer SAP Notes  1428529 - Corrections in BR*Tools Version 7.20

Regards,

[Former Member]

Hello Naveen,

In your initSID.sap file try making the following changes:

compress = brtools

#compress_cmd

Comment the line containing compress_cmd as given above.

Thanks.

Best Regards,

Anita

[former_member518118]

Hello Anita,

We are trying to take online with compress backup, as per your suggestion i tried above but error occur when # compress_cmd.

Error-

BR0051I BRBACKUP 7.20 (1)

BR0165E Parameter 'compress_cmd' is not set in /oracle/SID/102_64/dbs/initSID_disk.sap

i tried from both via brtools and using DB13, but no luck.

Regards

Naveen

[Former Member]

Hello Naveen,

Hope you changed below line as well:

compress = brtools

Best Regards,

Anita

[former_member518118]

Hi Anita,

Offline backup is completed successfully but not able to take online backup.

after some analysis mount point in aix related like sapdata1-n, logs and archive are not mounted with option read read and cio, may this is the issue.

in note 948294 the mount point should be with option cio, but not sure beacuse take downtime to remount all.

After this only will sure whats the root cause for the same.

Regards

Naveen