Re: dataguard rolling upgrade 11.1 to 11.2 - slow standby opening
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Thu, 14 May 2015 06:31:56 -0400
Message-ID: <5554799C.3090106_at_yahoo.com>
On 05/14/2015 06:20 AM, Howard Latham wrote:
> Redhat Linux 5
> I did a rolling upgrade on a 1TB database in a dataguard environment.
> all went well
> However when I had to activate the standby and make it the primary we
> experienced extremely poor performance for about an hour. Also it
> took over ten minutes to open it.
> After these delays the database started behaving ok. It might be an
> intermittent hardware fault but I cant help wondering if it was the
> upgrade completing - it being unable to complete fully until the
> database was open. I do know Oracle have used 'tricks' (deferring
> work) to get databases open quicker after upgrades in the past. Has
> anyone else noticed a similar Spike after an upgrade?
>
Again, what is in the alert log, what were the most pervasive waiting events.
Date: Thu, 14 May 2015 06:31:56 -0400
Message-ID: <5554799C.3090106_at_yahoo.com>
On 05/14/2015 06:20 AM, Howard Latham wrote:
> Redhat Linux 5
> I did a rolling upgrade on a 1TB database in a dataguard environment.
> all went well
> However when I had to activate the standby and make it the primary we
> experienced extremely poor performance for about an hour. Also it
> took over ten minutes to open it.
> After these delays the database started behaving ok. It might be an
> intermittent hardware fault but I cant help wondering if it was the
> upgrade completing - it being unable to complete fully until the
> database was open. I do know Oracle have used 'tricks' (deferring
> work) to get databases open quicker after upgrades in the past. Has
> anyone else noticed a similar Spike after an upgrade?
>
Again, what is in the alert log, what were the most pervasive waiting events.
-- Mladen Gogala Oracle DBA http://mgogala.freehostia.com -- http://www.freelists.org/webpage/oracle-lReceived on Thu May 14 2015 - 12:31:56 CEST