File Corruption

This is a discussion on File Corruption within the Rsync forums, part of the Networking and Network Related category; We are using rsync to transfer Oracle redo logs from one system to another over a WAN/VPN. The problem ...


Go Back   Usenet Forums > Networking and Network Related > Rsync

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 09-09-2005
Kevin Stussman
 
Posts: n/a
Default File Corruption

We are using rsync to transfer Oracle redo logs from one system to
another over a WAN/VPN. The problem we are having is that 1 out of about
500 or so files sent is corrupted. The receiving Oracle server produces
a message like this:

---
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00283: recovery session canceled due to errors
ORA-00368: checksum error in redo log block
ORA-00353: log corruption near block 116744 change 12227272 time
09/08/2005
21:43:34
ORA-00334: archived log:
'/oracle/logsync/files/incoming/yyc-db02-raw/GWLPROD_5879.arc'
---

Comparing the md5sum on the two files (original and sent copy)
produces different hashes, but the byte sizes are the same. When the
good file is manually re-sent again via rsync, it works fine and oracle
picks it right up. This leaves two possibilities that I can think of:

1. Somewhere in transport, the file got corrupted, (i.e. network,
compression/decompression, etc)
2. The file that the Oracle producer created was not completely finished
when rsync picked it up. Although the file sizes on each machine were
the same..(I'm looking deeper into this).

My questions are:
- Has anyone had any similar problems with rsync and transferring oracle
redo logs?
- Is there way to ensure that rsync checks the integrity of the
transferred file when it is complete? (i.e. do a checksum on the new
receiver file and the old sender file before completing...does this
already happen behind the scenes?) This file would *not* have already
existed on the receiver side and is deleted from the sender side when
completed.

Thanks for any pointers,

Kevin.

Details:
--------
rsync version 2.6.6 protocol version 29
Oracle 9i
RHES 3 (latest patches and kernel)

Rsync command used
------------------
/usr/local/bin/rsync --remove-sent-files --include '*/' --include
'*.arc' --exclude '*' -acvze "ssh -x -c arcfour"
remote-site:/oracle/logsync/file
s/outgoing/ /oracle/logsync/files/incoming/remote-site/


--
To unsubscribe or change options: https://lists.samba.org/mailman/listinfo/rsync
Before posting, read: http://www.catb.org/~esr/faqs/smart-questions.html
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:53 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0