Online Redo Backup Issue Input/Output Error

[Former Member]

Dear All,

Im getting this error while taking the backup in online mode with compressed:

BR0001I ******____________________________________________

BR0201I Compressing /oracle/DEV/sapdata2/sr3_20/sr3.data20

BR0203I to /oracle/DEV/sapbackup/bejvetdg/sr3.data20.Z ...

#FILE..... /oracle/DEV/sapdata2/sr3_20/sr3.data20

#SAVED.... /oracle/DEV/sapbackup/bejvetdg/sr3.data20.Z  #1/13  6.6048:1  755695638

BR0280I BRBACKUP time stamp: 2012-11-07 03.32.26

BR0063I 13 of 94 files processed - 39100.102 MB of 290713.930 MB done

BR0204I Percentage done: 13.45%, estimated end time: 6:58

BR0001I *******___________________________________________

BR0201I Compressing /oracle/DEV/sapdata2/sr3_21/sr3.data21

BR0203I to /oracle/DEV/sapbackup/bejvetdg/sr3.data21.Z ...

#FILE..... /oracle/DEV/sapdata2/sr3_21/sr3.data21

#SAVED.... /oracle/DEV/sapbackup/bejvetdg/sr3.data21.Z  #1/14  6.4439:1  820123572

BR0280I BRBACKUP time stamp: 2012-11-07 03.36.41

BR0063I 14 of 94 files processed - 44140.109 MB of 290713.930 MB done

BR0204I Percentage done: 15.18%, estimated end time: 6:59

BR0001I ********__________________________________________

BR0201I Compressing /oracle/DEV/sapdata2/sr3_22/sr3.data22

BR0203I to /oracle/DEV/sapbackup/bejvetdg/sr3.data22.Z ...

BR0278E Command output of 'LANG=C gzip -c /oracle/DEV/sapdata2/sr3_22/sr3.data22 > /oracle/DEV/sapbackup/bejvetdg/sr3.data22.Z':

gzip: /oracle/DEV/sapdata2/sr3_22/sr3.data22: Input/output error

BR0280I BRBACKUP time stamp: 2012-11-07 03.38.23

BR0279E Return code from 'LANG=C gzip -c /oracle/DEV/sapdata2/sr3_22/sr3.data22 > /oracle/DEV/sapbackup/bejvetdg/sr3.data22.Z':

BR0224E Compressing /oracle/DEV/sapdata2/sr3_22/sr3.data22 to /oracle/DEV/sapbackup/bejvetdg/sr3.data22.Z failed due to previous

BR0280I BRBACKUP time stamp: 2012-11-07 03.38.37

BR0317I 'Alter tablespace PSAPSR3 end backup' successful

BR0115I Compression rate for all files 6.3147:1

BR0056I End of database backup: bejvetdg.and 2012-11-07 03.38.23

BR0280I BRBACKUP time stamp: 2012-11-07 03.38.37

BR0054I BRBACKUP terminated with errors

But when I take the backup in online mode without compressed, it is taken successfully.

Help will be appreciated,

Regards,

[Former Member · Accepted solution]

Guess what, I rebooted the machine and everything worked out OK

Backup is now being processed and sr3.data22 is successfully compressed.

A very strange behaviour.

Thanks everyone,

Regards,

[Former Member]

Hi Zaman,

take a backup of your current gzip file ,

get a new gzip utility from your other system in landscape.

and then replace it  and then try.

check with hardware team if disk is working good (no bad sectors)

and if the disc have bad sectors brtools does not throw any errors related to it.

and yes online, compression is possible for  unix.

[Former Member]

Dear Nikhil,

thank you for the idea,

Thats exactly I am now doing and will let you know.

I will ask the hardware team aswell but if there were any bad sectors then uncompressed backup may also have some issues.

Regards,

[Former Member]

Error still the same after replacing the gzip from another machine (/usr/bin/gzip).

[Former Member]

Most welcome Edgar,

Error pops (input/output) up only at datafile: sr3.data22 (size 5.4 gig)

anyone for suggestions please?

is there any way I can use some other utility for compression other than gzip?

Uncompressed backups are being taken fine.

Regards,

[Former Member]

More information needed.

Did you try more than once?

Does the error always happen with the same file, i.e. sr3.data22 ?

Can you execute the failed gzip command from command line:

gzip -c /oracle/DEV/sapdata2/sr3_22/sr3.data22 > /oracle/DEV/sapbackup/bejvetdg/sr3.data22.Z

regards

[Former Member]

Dear Joe,

Yes I tried it many times and always on the sr3.data22 file.

I tried with the command you told and the exact error is coming.

While Sunil mentioned that the version of gzip should be 1.2.4 but i have the gzip 1.3.5 (2002-09-30) and i think it must support greater file sizes.

waiting for the best answer.

Thanks

Regards,

[Former Member]

Thanks;

I still think we should check for possible size limits of your gzip.

You wrote the size of file sr3.data22 is 5.4G.

And what are the size of successfully backed up files like sr3.data21, and their compressed copies sr3.data21.Z ?

You wrote your OS is SuSE Linux, SLES; but which release?

Is your backup directory on a local disk, or on an NFS mount?

I suppose you already checked for free space?

regards

[Former Member]

Most welcome,

The size of sr3.data21 is 5 gb, and below that are less than 5 gb.

Maximum file size by gzip:

http://www.gzip.org/#faq10

the OS version is SLES 11

the backup is being taken on local disk and a lot of space reamins (the uncompressed backup size is approx. 198 gb while this should be 50-60 gb)

Current free space is more than 250+gb

The last successful compressed backup was done on 29th of this October. It is very strange that this is happening.

Regards,

[Former Member]

A few more questions:

Is your OS 32- or 64-bit?

Were there any changes (Hardware, OS, reboot ...) since the last successful compressed backup?

Is the target directory /oracle/DEV/sapbackup/bejvetdg in the same Linux file system as the source directory /oracle/DEV/sapdata2 ?

Whan you are doing uncompressed backups, is the target also in the same filesystem as /oracle/DEV/sapbackup/bejvetdg ?

Besides gzip limits, we also have to consider file system limits.

regards

[Former Member]

Dear Joe,

OS is 64bit.

Yes, the filesystem is same (ext3)

I have now replaced the gzip from other SAP server (same OS version, arch, filesystem) where compressed backups are being taken successfully.

I will let you know the status, currently its running.

Thank you all for the response,

Regards,

[Former Member]

Error still the same after replacing gzip application in usr/bin from another machine.

[Former Member]

It seems part of my last questions wasn't that clear.

Let me rephrase:

What is the output of:

df -k /oracle/DEV/sapdata2/sr3_22

df -k /oracle/DEV/sapbackup/bejvetdg

Does this OS command work:

cp /oracle/DEV/sapdata2/sr3_22/sr3.data22 /oracle/DEV/sapbackup/bejvetdg

regards

[Former Member]

Dear Joe,

both folders are in same partition:

/dev/cciss/c0d0p3

(RAID Configured)

---

I am getting the error in copying the sr3.data22 file:

dev:/oracle/DEV/sapbackup # cp /oracle/DEV/sapdata2/sr3_22/sr3.data22 /oracle/DEV/sapbackup/

cp: reading `/oracle/DEV/sapdata2/sr3_22/sr3.data22': Input/output error

dev:/oracle/DEV/sapbackup #

---

It looks not good to me. It copied 1.8 GB and error occured. Any suggestions?

[Former Member]

So both folders are in the same partition.

You still didn't answer my question whether they are in the same filesystem.

As for the cp error:

Now we can say for sure that it is neither an SAP problem, nor a gzip problem, but some other problem. Maybe OS

Filesystem options or mount options come to my mind.

That's the reason for my perseverance regarding my question above ...

Or hardware problems, as suggested by Nikhil.

It's evening in my country, and I have to leave for now,

regards

[Former Member]

Dear Joe,

Yes, the filesystem is same (ext3). I am now taking uncompressed backup before any further recovery. Will update this thread.

Thank you all for your suggestions,

Regards,

[Former Member]

My definitely last reply for this week:

I was nor asking about filesystem type.

The df command I suggested above would have answered my question.

There is often, but not always, a 1.1 relationship between partitions and filesystems.

regards

[Former Member]

Dear Joe,

sorry i didnt understood your question, yes they are in the same filesystem

and now uncompressed backup cannot be processed on the same file.

I am now stuck here.

Should i reboot the machine and check?

I am in doubt that SAP may not be coming online after i stop it this time.

Regards,

[Former Member]

Hello Zaman,

try to compress with "compress = brtools"  in init<SID>.sap and BR*Tools 7.20, so you have best ratio between compression and CPU usage and no size limit.

Edgar

[Former Member]

Dear Edgar,

BR0191E Value 'brtools' of parameter/option 'compress' not supported for 'Unix'

I updated the brtools to 720 from 700, we have SLES deployed, hence this option may not work??

Kindly help.

Regards,

[Former Member]

Hello Zaman,  thank you for the feedback - I was not aware that compress=brtools is only possible for Windows.  Updating to BR*Tools 7.20 is a good idea anyhow, because only this version contains newer functionality.  Best regards, Edgar

[Former Member]

What is the size of the below data file?

>>/oracle/DEV/sapdata2/sr3_22/sr3.data22

Is it trying to create a zip file of more than 4G?

Whats gzip version? you need gzip 1.2.4.

[Former Member]

Dear Sunil,

current GZIP version is:

gzip 1.3.5

(2002-09-30).

The size of SR3_22 file is 5.4GB.

Regards,