Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 

 

 

Implementing the Oracle Hardware Resilient (HARD) Initiative for the OCR

Oracle RAC Cluster Tips by Burleson Consulting

This is an excerpt from the bestselling book Oracle Grid & Real Application Clusters.  To get immediate access to the code depot of working RAC scripts, buy it directly from the publisher and save more than 30%.


The purpose of the Oracle Hardware Assisted Resilient Data (HARD) initiative is to prevent data corruptions before they can occur. When HARD is enabled, the OCR writes what are known as HARD-compatible blocks.

While data corruptions are rare, they can have a catastrophic effect on a database, and by extension, on the business it supports. By providing Oracle's data validation algorithms to disk manufacturers and having these algorithms at work inside storage devices, Oracle, with disk vendor support, will prevent corrupted data from being written to the database files on permanent storage. This type of end-to-end high-level software to low-level hardware validation is currently a unique capability provided only by Oracle and its storage partners. Oracle program algorithms validate and add protection information to the database blocks and once passed to the disk, the protection information is validated by the HARD compliant storage device. In this manner, HARD prevents corruptions from being introduced into the I/O path between the database and storage and therefore eliminates a large percentage of failures that the database industry has previously not been able to prevent. While RAID, in its many flavors (0, 1, 1+0, 5) has gained a wide following with system operators by ensuring the physical protection of data, the HARD algorithm implementation takes data protection to the next level by going beyond protecting physical bits, to protecting business data.

The HARD algorithms were first made available in the Oracle9i Database and have been extended into the Oracle Database 10g. The validation in Oracle Database 10g is more comprehensive and all file types and blocks are inoculated by HARD including database files, online logs, archive logs and backups. In addition the use of ASM enables HARD without having to use raw disk devices. With the cooperation of hardware vendors HARD support is being offered in conjunction with many of the major storage arrays.

The classes of data corruptions that Oracle addresses with HARD include:

* Writes of physically and logically corrupt blocks

* Writes of blocks to incorrect locations

* Erroneous writes by programs other than Oracle to Oracle data

* Partially written blocks

* Lost writes

* Corrupted third party backups

The HARD initiative includes several algorithms that will be embedded in Oracle storage partner?s storage devices to prevent all these classes of corruptions. These algorithms will be rolled out in stages by Oracle's storage partners over time.

The following companies have joined the HARD initiative as of this writing:

* EMC

* Compaq

* Fujitsu

* Hewlett Packard

* Hitachi

* NEC

* Network Appliance

* Sun Microsystems

* VERITAS

* IDC

HARD Validated Products

HARD Test Kit Version 2.2 for Oracle9i Release 2

Validation Description

Hitachi SANRISE 9900V/Lightning 9900V (DB Validator)

HP Surestore xp1024

NEC iStorage Disk Array

Sun StorEdge 9900

Checks for writes of corrupted datafile blocks.  This includes the checksum value as well as validation of selected fields in the block.

4 (out of 5 possible checks)

4 (out of 5 possible checks)

5 (out of 5 possible checks)

4 (out of 5 possible checks)

Checks for writes of corrupted redo log blocks. This includes the checksum value as well as validation of selected fields in the block.

3 (out of 4 possible checks)

3 (out of 4 possible checks)

4 (out of 4 possible checks)

3 (out of 4 possible checks)

Checks for writes of corrupted controlfile blocks. This includes the checksum value as well as validation of selected fields in the block.  

4 (out of 5 possible checks)

4 (out of 5 possible checks)

5 (out of 5 possible checks)

4 (out of 5 possible checks)

Check for writes of Oracle data that is not a multiple of Oracle blocksize for target device.

Yes

Yes

Yes

Yes

HARD Test Kit Version 2.1 for Oracle8i and Oracle9i Release 1

Validation Description

Hitachi SANRISE 9900V/Lightning 9900V (DB Validator)

HP Surestore xp1024

Sun StorEdge 9900

Checks for writes of corrupted datafile blocks.  This includes the checksum value as well as validation of selected fields in the block.

4 (out of 5 possible checks)

4 (out of 5 possible checks)

4 (out of 5 possible checks)

Checks for writes of corrupted controlfile blocks. This includes the checksum value as well as validation of selected fields in the block.  

4 (out of 5 possible checks)

4 (out of 5 possible checks)

4 (out of 5 possible checks)

Check for writes of Oracle data that is not a multiple of Oracle blocksize for target device.

Yes

Yes

Yes

HARD Test Kit Version 1 for Oracle8i

Validation Description

EMC Symmetrix (Double Checksum)

Checks the checksum value of an Oracle data block on write.

Yes

 


This is an excerpt from the bestselling book Oracle Grid & Real Application Clusters, Rampant TechPress, by Mike Ault and Madhu Tumma.

You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.

http://www.rampant-books.com/book_2004_1_10g_grid.htm


 

 
��  
 
 
Oracle Training at Sea
 
 
 
 
oracle dba poster
 

 
Follow us on Twitter 
 
Oracle performance tuning software 
 
Oracle Linux poster
 
 
 

 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational