Re: DBWR performance

From: John Hurley <johnthehurley_at_gmail.com>
Date: Sun, 20 May 2012 11:03:28 -0700 (PDT)
Message-ID: <43ce4d43-6012-45e0-bf99-c832d98dae80_at_r4g2000pbf.googlegroups.com>

Mladen:

# Two weeks ago, on one of my production databases. There is no RAC and yes, the entire database went down.

Ouch ... we are not a big shop but for our most important database we have a spare server powered off right next to prod server.

If unknown hardware failure ... pull out internal drives ( raid 1
mirror for operating system ) ... attach fiber channel connections to
spare server ... power it up ... re-configure network interfaces

( linux will not be happy exactly with different mac addresses etc ) ... and back up and running.

Local storage not a bad idea ( depending ) for operating system and installed software ( as long as you can move it quickly to another machine ) but everything else better be "somewhere else" ... Received on Sun May 20 2012 - 13:03:28 CDT