On Sun, 18 Mar 2007, Shachar Shemesh wrote:

Date: Sun, 18 Mar 2007 21:32:06 +0200
From: Shachar Shemesh <[EMAIL PROTECTED]>
To: Jonathan Ben Avraham <[EMAIL PROTECTED]>
Cc: Geoffrey S. Mendelson <[EMAIL PROTECTED]>,
    Israel Linux Mailing list <linux-il@linux.org.il>
Subject: Re: Rsync and databases

Jonathan Ben Avraham wrote:
On Sun, 18 Mar 2007, Geoffrey S. Mendelson wrote:

Date: Sun, 18 Mar 2007 13:35:00 +0200
From: Geoffrey S. Mendelson <[EMAIL PROTECTED]>
To: Israel Linux Mailing list <linux-il@linux.org.il>
Subject: Rsync and databases

I lost the original to this thread, but I thought some comments may be
usefull.

First of all, rsyncing an open file is not a good idea. If the file
is a database you can end up with a totaly worthless bunch of random
bits. :-(


If the file is closed, then RSYNC will work, but it may not work for
all database systems, check before using.

Rsync will definately *not* work for Oracle database files. The rsync
fails on the verification stage. Use ftp instead.
Sounds strange, as rsync is supposed to create an identical copy on the
remote machine. Does it fail on the rsync or Oracle verification stage?
Do you know why it fails?

Hi Shachar,
The rsync fails, on the verification stage after it transfers the file, before invoking Oracle. This is a known problem with rsync and very sparce files that are more than 10GB. Haven't looked into it for a while. Might have been fixed recently but definately not working in RHEL3.

 - yba

 - yba

Shachar



--
 EE 77 7F 30 4A 64 2E C5  83 5F E7 49 A6 82 29 BA    ~. .~   Tk Open Systems
=}------------------------------------------------ooO--U--Ooo------------{=
     - [EMAIL PROTECTED] - tel: +972.2.679.5364, http://www.tkos.co.il -

=================================================================
To unsubscribe, send mail to [EMAIL PROTECTED] with
the word "unsubscribe" in the message body, e.g., run the command
echo unsubscribe | mail [EMAIL PROTECTED]

Reply via email to