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

  • From: "Mladen Gogala" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "mgogala@xxxxxxxxx" for DMARC)
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 14 May 2015 06:31:56 -0400

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

--
//www.freelists.org/webpage/oracle-l


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2015