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

Using rsync for buidling Oracle standbys.

2009-09-03 Thread Saibabu Devabhaktuni
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. Orac