Hi,

We currently use rsync to create an Oracle standby on a target box from an 
existing standby by copying all the datafiles while the source standby is in 
recovery status. We are occasionally running into datafile corruptions being 
reported by oracle when it is recovering the new standby. Oracle support says 
they don't recommend copying files while the changes being applied to them 
unless the database is put in backup mode (which is not possible for us).

We are using "rsync -av --password-file=pass.secret source_data_file_name 
ora...@target::ORCL/"

We are planning to use "rsync -av --password-file=pass.secret --block-size=8192 
source_data_file_name ora...@target::ORCL/"

This is because, we are using 8k block size for Oracle and hence the blocks 
will be copied in full by rsync to avoid fractured block copies. Am I correct 
in this assumption by using "--block-size" option?

Also, is there are option is rsync to keep checking the checksum's at block 
level, i.e., copy block 1 from host A to host B, calculate checksum at host B 
and verify that the checksum of same block at host A is also same?

Appreciate any help on this.

Thanks,
 Sai.



      

-- 
Please use reply-all for most replies to avoid omitting the mailing list.
To unsubscribe or change options: https://lists.samba.org/mailman/listinfo/rsync
Before posting, read: http://www.catb.org/~esr/faqs/smart-questions.html

Reply via email to