Check logical corruption and repair through Scrubbing Disk group in Oracle ASM

Scrubbing help to improve the availability and reliablity of data. It help to check logical data corruptions and repair them by mirroring in case of Normal & High redundancy disks groups.

Example

Scrubbing on diskgroup

ALTER DISKGROUP data SCRUB POWER LOW;

Scrubbing on File

ALTER DISKGROUP data SCRUB FILE '+DATA/ORCL/DATAFILE/example.266.806582193' REPAIR POWER HIGH FORCE;

Scrubbing on disk of diskgroup

ALTER DISKGROUP data SCRUB DISK DATA_0005 REPAIR POWER HIGH FORCE;


Options:
REPAIR option automatically repairs disk corruptions. If not specified then it only report about logical corruptions.
POWER value may be AUTO, LOW, HIGH, or MAX. If not specified it will take auto.
WAIT option: command wait until the scrubbing operation has completed.
FORCE option: the command even system I/O load is high or scrubbing has been disabled internally at the system level.

Check scrubbing process status

Select * from V$ASM_OPERATION;