[sclug] Writing files to 2 places at once?

[Sapan Ganguly]

I have a good question.  First of all here is my situation, I have a RHEL3
machine running Oracle, the server is low on disk space (but not critical
yet) so I've attached a disk array to it.  I've set myself the task of
moving the Oracle datafiles (about 90 files 2.0Gb or more each) to the new
disk array without any down time...or maybe a small amount of down time,
certainly no more than 1 hour.

I've been thinking along thsese lines, all the filesystems involved are
journalling (ext3), I've also been reading about FAM (File Access Monitor)
and IMON (Inode Monitor).  I may be barking up the wrong tree but what do
you all think?  Should I be able to use both or one of these tools to let
Oracle write to its datafiles in the current location and to my new location
at the same time?

I've tried an rsync whilst the database is running, the first run took ages
as expected...but so did the second run, third etc.  I haven't tried a run
with the database shutdown yet, I will try that on the test system and see
if it is any faster.  The rsync options I'm using are -

rsync -a --inplace  /oradata/db /array1/oradata/db    (I don't think I need
any other options since I'm not going over the network)

So, what do you think?  Am I being silly?

Thanks,
Sapan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.tmdg.co.uk/pipermail/sclug/attachments/20060303/004c6229/attachment.htm