on 11-07-2012 12:46 PM
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,
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
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
Most welcome,
The size of sr3.data21 is 5 gb, and below that are less than 5 gb.
Maximum file size by gzip:
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,
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
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?
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.