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]