Re: Who uses active data guard?
From: <zigzagdna_at_yahoo.com>
Date: Mon, 15 Oct 2012 14:53:56 -0700 (PDT)
Message-ID: <b140738c-7491-41a1-b21a-ccbbcfd135cd_at_googlegroups.com>
On Monday, October 15, 2012 4:43:25 PM UTC-4, Mladen Gogala wrote:
> On Mon, 15 Oct 2012 13:39:47 -0700, zigzagdna wrote: > I thought data guard (whether active or not) provides for automatic > repair from block corruption. Can you confirm, it is only active data > guard? Yes, I can confirm. Only active Data Guard provides transparent protection against the block corruption. Also, there is a caveat that people usually don't think of when using active DG: you cannot use inserts into temporary tables, a very popular optimization method when it comes to big reports. -- Mladen Gogala http://mgogala.freehostia.com
Date: Mon, 15 Oct 2012 14:53:56 -0700 (PDT)
Message-ID: <b140738c-7491-41a1-b21a-ccbbcfd135cd_at_googlegroups.com>
On Monday, October 15, 2012 4:43:25 PM UTC-4, Mladen Gogala wrote:
> On Mon, 15 Oct 2012 13:39:47 -0700, zigzagdna wrote: > I thought data guard (whether active or not) provides for automatic > repair from block corruption. Can you confirm, it is only active data > guard? Yes, I can confirm. Only active Data Guard provides transparent protection against the block corruption. Also, there is a caveat that people usually don't think of when using active DG: you cannot use inserts into temporary tables, a very popular optimization method when it comes to big reports. -- Mladen Gogala http://mgogala.freehostia.com
Thanks a lot, learning something new. These groups are so useful. Received on Mon Oct 15 2012 - 23:53:56 CEST