Re: dataguard rolling upgrade 11.1 to 11.2 - slow standby opening

From: Mladen Gogala <>
Date: Thu, 14 May 2015 06:31:56 -0400
Message-ID: <>

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

Received on Thu May 14 2015 - 12:31:56 CEST

Original text of this message