Re: rman block recovery
From: <zigzagdna_at_yahoo.com>
Date: Wed, 11 Apr 2012 20:43:30 -0700 (PDT)
Message-ID: <12378398.64.1334202210927.JavaMail.geo-discussion-forums_at_vbth19>
On Wednesday, April 11, 2012 10:17:41 PM UTC-4, Mladen Gogala wrote:
> On Wed, 11 Apr 2012 19:05:52 -0700, zigzagdna wrote:
>
>
> > I wonder when block recovery is done will Oracle stop as soon as block
> > is "recoverd" or will it keep applying changes from archived logs to
> > that block until it runs out of archive logs. If a point in time
> > recovery is applied, then that block can be incosistent with all other
> > blocks because of incomplete recovery ...
>
> Sounds like a good thing to test. BTW, you should keep your databases on
> SAN, no corrupt blocks there.
>
> --
> http://mgogala.byethost5.com
Date: Wed, 11 Apr 2012 20:43:30 -0700 (PDT)
Message-ID: <12378398.64.1334202210927.JavaMail.geo-discussion-forums_at_vbth19>
On Wednesday, April 11, 2012 10:17:41 PM UTC-4, Mladen Gogala wrote:
> On Wed, 11 Apr 2012 19:05:52 -0700, zigzagdna wrote:
>
>
> > I wonder when block recovery is done will Oracle stop as soon as block
> > is "recoverd" or will it keep applying changes from archived logs to
> > that block until it runs out of archive logs. If a point in time
> > recovery is applied, then that block can be incosistent with all other
> > blocks because of incomplete recovery ...
>
> Sounds like a good thing to test. BTW, you should keep your databases on
> SAN, no corrupt blocks there.
>
> --
> http://mgogala.byethost5.com
My database is alreday on SAN but somehow my data center SAN has issues causing corruption. Received on Wed Apr 11 2012 - 22:43:30 CDT