Re: Who uses active data guard?
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 15 Oct 2012 20:43:24 +0000 (UTC)
Message-ID: <pan.2012.10.15.20.43.24_at_gmail.com>
On Mon, 15 Oct 2012 13:39:47 -0700, zigzagdna wrote:
Date: Mon, 15 Oct 2012 20:43:24 +0000 (UTC)
Message-ID: <pan.2012.10.15.20.43.24_at_gmail.com>
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.comReceived on Mon Oct 15 2012 - 22:43:24 CEST