ASM for single-instance 11g db server?

#41

On Wed, 06 Apr 2011 21:12:08 -0700, Noons wrote:

Quote:

Vendors SQL-guys have started to fix these also, another significant
performance increase coming, I hope.

But it's all Oracle's fault, ain't it? Damn SQL, it's always the
problem. Never the space between the chair and the keyboard...

These things just happen.

Indeed! Good story, that one. Surprising how often Ive seen it repeated
and I still see it again and again. One would have thought IT
damagement would have wised up. Unfortunately, they're all still
looking for silver bullets...

Speaking of ASM, did anyone find the way to eliminate those pesky
"SUCCESS: diskgroup XXXX was dismounted". Here is a sample:

Thu Apr 07 09:20:04 EDT 2011
RFS[27]: Successfully opened standby log 40: '+DGFRA/adostby/onlinelog/
group_40.798.744985951'
Thu Apr 07 09:20:12 EDT 2011
Media Recovery Log /BACKUP/archives/archADPRD_2_544610_614435904.dbf
Thu Apr 07 09:20:26 EDT 2011
Media Recovery Log /BACKUP/archives/archADPRD_2_544611_614435904.dbf
Thu Apr 07 09:20:38 EDT 2011
Media Recovery Log /BACKUP/archives/archADPRD_1_242827_614435904.dbf
Media Recovery Log /BACKUP/archives/archADPRD_2_544612_614435904.dbf
Media Recovery Log /BACKUP/archives/archADPRD_3_217554_614435904.dbf
Media Recovery Waiting for thread 1 sequence 242828
Thu Apr 07 09:20:43 EDT 2011
SUCCESS: diskgroup DGREDO was dismounted
SUCCESS: diskgroup DGFRA was dismounted

My alert log is full of the messages like the last two. What is the point
of those?

--
http://mgogala.byethost5.com

#42

joel garry wrote,on my timestamp of 7/04/2011 3:21 AM:

Quote:

Of course if one of many controllers corrupts, welcome to hell.

Exactly. RAID5, RAID10, whatever, it doesn't matter. That is why we have backups
and DR sites. No RAID type was ever thought out to prevent ALL possible disaster
scenarios.

Quote:

Never underestimate the power of the damager:
http://groups.google.com/group/comp....edb062e0071ac0
http://groups.google.com/group/comp....f1684073028648

Dude: the last time one damager walked into our DC we made sure he couldn't walk
ever again!

Quote:

I've been amazed many times how often warnings are ignored. (Couldn't
find with a quick search something I came across yesterday on the hp
forums - guy posted his warning messages with a raid question,
apparently didn't realize that the "battery dead" messages meant no
battery backup on write cache [depends on hardware as to whether that
turns cache off, I believe].) Yet another use for duct tape -
covering up annoying warning lights.
http://groups.google.com/group/comp....e05efc4b33ac4c

Sure. But like I said: RAID was not designed to cover ALL possible disaster
scenarios, natural or stupidity-caused.

Quote:

I'm running OLTP on RAID5. No one mentions what happens when the
write buffer is full. Or when the batteries die and turn off the
cache.

That is indeed another case of "traditional lore" creeping in.

Not all OLTP workloads are the same. I ran a OLTP system in my search engine
marketing days for two years with 0 (zero) downtime, using 9i and RAID5 on an
Apple XRaid SAN: can't get any more low end! Yet the workload was of a nature
that allowed us to get away with it: very rapid arrival of very short
transactions, but not overlapping or multi-threaded. We were happily pumping an
average of 100MB/s, constant 24X7, at a ridiculously low cost. 6 years ago. No
problems.

When it comes to storage performance and resilience, there is no such thing as a
general rule or a one size fits all. Every single instance has to be analyzed
on its own merit and according to its own conditions.

That's why I am very reluctant to join things like BAARF: it's waaaaay to
general for my taste.

Now: BAAG, that is a totally different kettle!

#43

John Hurley wrote,on my timestamp of 7/04/2011 3:39 AM:

Quote:

# onedbguru is obviously well-qualified to be speaking on the topics
he does.

Maybe so ... I don't put a lot of faith in postings by people that are
not willing to use their real names ( even after all the years I was
using hpuxrac I don't think it was hard to know who I really was ).

Hep! Noons is not my "real" name either!
(then again: anyone who doesn't know who I am is in serious need of basic search
engine head-bashing...)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

ASM for single-instance 11g db server?

comp.databases.oracle.server comp.databases.oracle.server

Re: ASM for single-instance 11g db server? - 04-07-2011 , 08:26 AM

Re: ASM for single-instance 11g db server? - 04-07-2011 , 08:31 AM

Re: ASM for single-instance 11g db server? - 04-07-2011 , 08:39 AM