Re: Using rsync for buidling Oracle standbys.

2009-09-03 Thread Tim Evans
Andrew Gideon wrote: > On the other hand, I recall that Oracle has its own replication engine > for this purpose. As much as I like rsync, wouldn't it make more sense > to use the Oracle-provided mechanism? That was my first thought, too. If the OP is already paying for two Oracle instances, r

Re: Using rsync for buidling Oracle standbys.

2009-09-03 Thread Andrew Gideon
On Thu, 03 Sep 2009 16:23:24 -0400, Matt McCutchen wrote: > but the non-atomicity of read(2) calls was not considered If a frozen snapshot is constructed, then I don't see how read()'s inatomicity (if that's a word {8^) would matter. However, I see a related issue. My experience with DB engine

Re: Using rsync for buidling Oracle standbys.

2009-09-03 Thread Matt McCutchen
On Thu, 2009-09-03 at 10:25 -0700, Saibabu Devabhaktuni wrote: > 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