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