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

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;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.