Re: Block Corruptions on Oracle and UNIX

g3000 wrote:
> Thanks for all the replys.
>
> Im personally a little more unknowledgable about disk subsystems.
> I understand what SAN and NAS are but not JBOD?
>
> Im assuming Joel Garry and "hpuxrac" is saying is when you have
> networked storage versus direct attached there is a greater possiblity
> of issues. ( one being keeping a prod and standby in sync ? )

I was referring to any network involved. After several months of no problems after a network reconfiguration, I've had 3 significant events since Friday. None corrupted a data file block, but two interrupted standby log transport (homegrown), and one made a vendor supplied monitor program for a feature we don't even use go cpu-crazy, extending application logins from instantaneous to many minutes. And one apparently broke a remote session leaving a row locked, causing an month-end update to crash, causing double-updating to occur in some random records because the update was written below lowest common denominator database standards, and so is not atomic. So I'm sorting that out.

But no Oracle data block corruption.

>
> Dont understand why Oracle offers RAC on 10G Standard but NO block
> level media recovery?
> Also no incremental backups. Makes no sense.
>
> Seems to me if you have the need for RAC you definitely need the other
> two. Maybe Im wrong.

Different requirements.
http://www.oracle.com/technology/products/database/clustering/pdf/ds_rac.pdf

>
> This maybe outside the thread but any "notoriously" bad subsystem
> vendors? ( poor support, poor quality )

Google about, I vaguely recall seeing such posts. I've seen some bad ones, but long ago, so useless to comment on them. There are some cheap systems specifically being supported for Oracle, so to not-answer your question, see
http://www.oracle.com/technology/deploy/availability/pdf/lcs_OW.ppt.pdf (which in turn points to
http://www.oracle.com/technology/deploy/availability/htdocs/lowcoststorage.html ).

>
> thanks again for all your replies. I have enough to go do further
> reading to gain more understanding.

jg

--
@home.com is bogus.
http://www.signonsandiego.com/uniontrib/20051103/news_1b3guidant.html