RE: Lost Write Protect / ASM Diskgroup Scrubbing Worthwhile?

ASM protects against Filesystem corruption because there is no file system.

It doesn’t protect against Hardware corruption.

The Oracle database when you turn on all the block checksumming will try to protect you against most in-memory corruption and helping detect of blocks that are corrupt that come from the disk, but corruption can still happen during the write out of the block to disk or on disk itself (bit rot) which is why scrubbing of disk drives is still helpful.

Lost write protection is for easier detection of lost writes. Still won’t protect you from bit rot (like scrubbing does) but offers another higher layer of protection for memory or SW bugs.      

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Jack Applewhite
Sent: Thursday, October 22, 2020 1:53 PM To: oracle-l_at_freelists.org
Subject: Lost Write Protect / ASM Diskgroup Scrubbing Worthwhile?  

18c EE DBs on ASM X8-2M ODAs at 18.8

19c EE DBs on ASM X5-2 ODA at 19.8  

Would our very simple storage setup benefit from implementing / pursuing these two features? Doesn't ASM pretty much protect against OS / hardware induced block corruption?  

Thanks.

--

Jack C. Applewhite - Database Administrator Austin I.S.D. - MIS Department
512.414.9250 (wk)

I cannot help but notice that there is no problem between us that cannot be solved by your departure. -- Mark Twain

Confidentiality Notice: This email message, including all attachments, is for the sole use of the intended recipient(s) and may contain confidential student and/or employee information. Unauthorized use of disclosure is prohibited under the federal Family Educational Rights & Privacy Act (20 U.S.C. §1232g, 34 CFR Part 99, 19 TAC 247.2, Gov’t Code 552.023, Educ. Code 21.355, 29 CFR 1630.14(b)(c)). If you are not the intended recipient, you may not use, disclose, copy or disseminate this information. Please call the sender immediately or reply by email and destroy all copies of the original message, including attachments.

--

http://www.freelists.org/webpage/oracle-l Received on Fri Oct 23 2020 - 08:02:15 CEST