Atikh's DBA blog
  • Home
  • Oracle
  • MySQL
  • MongoDB
  • PostgreSQL
  • Snowflake
  • About Me
  • Contact Us

Oracle ASM Scrubbing

 Atikh Shaikh     oracle, Oracle 12c     No comments   

What is ASM Scrubbing?

 

ASM scrubbing is a process used to identify and repair data corruption issues within an ASM disk group. ASM Scrubbing scans the data stored in the disk group and checks for inconsistencies or corruption. The process typically involves reading each data block, comparing it to expected values, and correcting errors by relying on redundancy mechanisms.

 

The Importance of ASM Scrubbing

 

1. Data Integrity

2. Performance Optimization

3. Redundancy Assurance

4. Preventing Data Loss

5. Proactive Health Monitoring

 

How ASM Scrubbing Works

 

ASM scrubbing uses the redundancy features inherent in the ASM system to detect and correct errors.

The process typically works as follows:

 

1. Scanning Data Blocks: ASM scrubbing scans all the data blocks in a disk group, checking for any signs of corruption, such as bit errors or inconsistencies between mirrored copies.

 

2. Verifying Data Integrity: It cross-references each block with its mirror or redundant copy. If a mismatch is found between the blocks, it flags this as a potential error.

 

3. Correcting Errors: If errors are found, ASM attempts to correct them by retrieving data from the redundant copy (if available). For example, in a mirrored setup, if one disk’s data is corrupted, the data from the other disk is used to restore the correct information.

 

4. Logging and Reporting: During the scrubbing process, any identified errors are logged and reported to the system administrators. This allows administrators to monitor and assess the system’s health over time.

 

5. Automated vs. Manual Scrubbing: While ASM scrubbing can be configured to run automatically on a scheduled basis, it can also be manually initiated if needed. This flexibility allows system administrators to choose when to run the scrub, depending on system load and maintenance schedules.

 

Below commands can be used to perform scrubbing

ALTER DISKGROUP Dg_NAME SCURB POWER LOW;

ALTER DISKGROUP Dg_NAME SCURB FILE 'file-name' REPAIR POWER HIGH FORCE;

ALTER DISKGROUP Dg_NAME SCURB DISK Disk-name  REPAIR POWER HIGH FORCE;

 

REPAIR - this option allows automatic repairs disk corruptions; progress can be seen using V$ASM_OPERATION view in the database

 


Read More
  • Share This:  
  •  Facebook
  •  Twitter
  •  Instagram
  •  Pin
  •  linkedin
  •  reddit
Newer Posts Older Posts Home

Author

Atikh Shaikh
View my complete profile

Categories

  • MongoDB (18)
  • Oracle 12c (30)
  • Oracle12cR2 New Feature (3)
  • PostgreSQL (20)
  • RMAN (10)
  • Snowflake (8)
  • mysql (23)
  • oracle (73)

Blog Archive

  • ►  2018 (38)
    • ►  November (25)
    • ►  December (13)
  • ►  2019 (33)
    • ►  January (15)
    • ►  February (6)
    • ►  March (2)
    • ►  April (5)
    • ►  May (5)
  • ►  2020 (5)
    • ►  April (1)
    • ►  May (2)
    • ►  July (2)
  • ►  2021 (8)
    • ►  June (3)
    • ►  July (3)
    • ►  August (1)
    • ►  December (1)
  • ►  2022 (33)
    • ►  May (3)
    • ►  June (10)
    • ►  July (3)
    • ►  August (4)
    • ►  September (8)
    • ►  October (3)
    • ►  November (2)
  • ►  2023 (14)
    • ►  February (1)
    • ►  April (5)
    • ►  May (2)
    • ►  June (1)
    • ►  September (1)
    • ►  October (1)
    • ►  December (3)
  • ►  2024 (5)
    • ►  January (2)
    • ►  March (3)
  • ▼  2025 (5)
    • ▼  March (1)
      • Oracle ASM Scrubbing
    • ►  April (3)
    • ►  May (1)

Popular Posts

  • ORA-29283: invalid file operation: unexpected "LFI" error (1509)[29437]
    I was trying to export the schema in my windows PC, it got stuck with below error    C:\Users\shaik\Videos\technodba exp>expdp userid...
  • Oracle Dataguard Broker Configuration (DGMGRL)
    Data Guard Broker is a command-line interface that makes managing primary and standby databases easy. DBA can use a single command to switch...
  • ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES
    In previous articles, we have learned about user creation and grants  in MySQL in detail, but there are a few privileges called global priv...
  • PostgreSQL : How to get data directory location for PostgreSQL instance
    Sometimes, you start working on a PostgreSQL instance but forget about the data directory, here we will discuss different methods to know th...
  • Oracle 23ai : The all new Hybrid Read-Only for pluggable databases (PDBs)
      The latest Oracle database version, Oracle 23ai, introduced a new open mode called Hybrid Read-Only for pluggable databases (PDBs). Local ...

Labels

oracle Oracle 12c mysql PostgreSQL MongoDB oracle 19c Oracle23c oracle19c Orale PDB-CDB oracle12c python AWS Oracle ASM Virtualbox pluggable database storage engine

Pages

  • Disclaimer
  • Privacy Policy

Follow TechnoDBA

Copyright © Atikh's DBA blog | Powered by Blogger