Open Database RSYNC

Poe, David dpoe at medplus.com
Thu Sep 8 18:20:37 GMT 2005


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
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?  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
-------------- next part --------------
HTML attachment scrubbed and removed


More information about the rsync mailing list