Creating the database, Error detection and recovery, Error detection – HP XP Array Manager Software User Manual

Page 28: 28 error detection and recovery

Advertising
background image

6.

Enable integrity checking on all devices with the appropriate XP RAID Managerraidvchkset –vt
[type] –vs bsize slba elba command, either for data or redo, and the appropriate start LBA and
end LBA.
This example shows how to set and display the validation parameters for the Oracle data files.
Bsize units are bytes. For raidvchkset, STLBA and ENLBA units are in decimal; for raidvchkdsp,
units are in hexadecimal, as specified by the –fx option.

# raidvchkset -g vgdata -vt data9 -vs 16 2048 4802559

# raidvchkdsp -g vgdata -fxd

Group PairVol Device_File Seq# LDEV# BR-W-E-E MR-W-B BR-W-B SR-W-B-S

vgdata disk1 c4t0d1 10033 2 D E B R D E E D E D D E E E

vgdata disk2 c4t0d2 10033 12c D E B R D E E D E D D E E E

# raidvchkdsp -g vgdata -fxd -v offset

Group PairVol Device_File Seq# LDEV# Bsize STLBA ENLBA BNM

vgdata disk1 c4t0d1 10033 2 8192 800 4947FF 9

vgdata disk2 c4t0d2 10033 12c 8192 800 4947FF 9

This example shows how to set and display the validation parameters for the Oracle log files:

# raidvchkset -g vglog -vt

# raidvchkdsp -g vglog -fxd

Group PairVol Device_File Seq# LDEV# BR-W-E-E MR-W-B BR-W-B SR-W-B-S

vglog disk3 c4t0d3 10033 23 D D B W D D D D D D D D D D

vglog disk4 c4t0d4 10033 147 D D B W D D D D D D D D D D

7.

Restart the database and verify the validation parameters data.

Creating the Database

You can use the standard procedure described in the Oracle documentation to create a database.

Note: When you issue the CREATE TABLESPACE command, it must be used with the REUSE option.
If the REUSE option is not specified, a validation error may occur depending on the host environment.

Error Detection and Recovery

This section provides general guidelines for error detection and recovery. Most errors are caused by
hardware failure or misoperation/misconfiguration. Recovery and restoration can be easy for these
cases. Also, rare but serious intermittent errors that cause data corruption are also detected by Database
Validator immediately, thereby minimizing the damage from error and the cost for recovery.

Error Detection

When the storage system detects a validation error, the storage system reports a Check Condition
error to the host. If the faulty write request originates from the Oracle application, the following actions
may be taken:

The Oracle application turns the damaged data file offline and/or

The Oracle instance stops

Performing Database Validator Operations

28

Advertising