Open Database RSYNC

[Chris Shoemaker]

On Thu, Sep 08, 2005 at 02:20:37PM -0400, Poe, David wrote:
> We have nearly 200 GB of data in a production Oracle database broken up
> into about 100 files of 2 GB.  The database incurrs a 5% change per week
> in the form of new data, no modification nor deletions.  I need to copy
> this data from one mount point to another then bring up the new database
> on the new mount point in place of the original.  The high availability
> and production nature of this system means that my maintenance windows
> are few and far between.  To minimize my use of the maint window, I
> would like to pre-copy as much data as I can with RSYNC before the

For the first copy, it's probably more efficient to just use 'cp', but
rsync would work, too.


> window, then do a final sync of the data during the window with the
> database down.  My question is, will RSYNC be a good option given that
> the Oracle database is up and running for the initial sync?  

"good" compared to what?  to copying the database files while the
database is down?  That depends on how much the files changed between
the time you copy them and the time you rsync them.  Best-case is far
better than cp.  Worst-case is not much worse than cp.

-chris


> I'm hoping
> that RSYNC will be an option for us, as other mirroring strategies I
> have seen rely upon same size disk devices/partitions, which we do not
> want because the goal is to put up a single device larger area to keep
> this data.  Please ignore the gaping holes for ideas such as just having
> Oracle use another mount point in addition to the one it is already
> using or online VG expansions.
>  
> David Poe

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