Exadata - Disk scrubbing

Disk scrubbing exists on Exadata cell nodes to automatically repair bad sectors of the disk when the system is idle, without sacrificing system performance.?It tries to repair bad sectors on the disk by working at certain periods when the disks are idle.?If too much bad area is starting to appear on the disc, you can increase the scrubbing interval.

We can access information about disk scrubbing activity with the following commands.

Detection of whether Disk scrub activity is active on the Exadata cell node:

CellCLI> list cell attributes name,hardDiskScrubInterval
exa1celadm01 biweekly        

Detection of whether the Harddisk Scrub process has started on the Exadata Cell node:

If the $CELLTRACE/alert.log file on Cellnode contains the following information, the process has been started and completed.

The cell alert log file will contain statements as follows.

=> When scrubbing starts:

Begin scrubbing CellDisk:CD_05_exa1celadm01.

=> When scrubbing is finished:

Finished scrubbing CellDisk:CD_05_exa1celadm01, scrubbed blocks (1MB):1906336, found bad blocks:0

In addition, when the griddisks are checked, if there is an active scrub process, the status of the griddisk will be seen as “active – scrub resilvering working”.?

Determining the scheduling time of the Harddisk Scrub process:

CellCLI> list cell attributes name,hardDiskScrubInterval
exa1celadm01 biweekly        

NOTE : biweekly is the default value and means biweekly.?You can also set it as daily or weekly if you wish.

Closing the Harddisk Scrub process:

CellCLI> alter cell hardDiskScrubInterval=none
Cell exa1celadm01 successfully altered        

Changing the running frequency of the Harddisk Scrub process:

Daily :

CellCLI> alter cell hardDiskScrubInterval=daily
Cell exa1celadm01 successfully altered        

weekly :

CellCLI> alter cell hardDiskScrubInterval=weekly
Cell exa1celadm01 successfully altered        

Every two weeks:

CellCLI> alter cell hardDiskScrubInterval=biweekly
Cell exa1celadm01 successfully altered        

Ensuring that the Harddisk Scrub process starts at a specific date and time:

CellCLI> alter cell hardDiskScrubStartTime='2018-12-12T21:30:22+03:00'
Cell exa1celadm01 successfully altered        

?

NOTE : At the end of the time, the timezone value should also be given.?That's what +03:00 above is for.

要查看或添加评论,请登录

Ahmet Duru?z的更多文章

  • How to determine the last modified date of tables in Oracle ?

    How to determine the last modified date of tables in Oracle ?

    For each row in a table, ORA_ROWSCN returns the SCN of the most recent change in the row. This pseudo-column can be…

  • Oracle Data Redaction

    Oracle Data Redaction

    Available with the Oracle Advanced Security license, Oracle Data Redaction allows you to mask (redact) data returned…

  • Active requests on Exadata cell node

    Active requests on Exadata cell node

    An active request represents a client- or application-centric view of I/O requests handled by the cell node. You can…

  • SQL Tuning Health-Check Script (SQLHC)

    SQL Tuning Health-Check Script (SQLHC)

    Also known as SQLHC, this tool is used to check the environment in which a single SQL statement is running, Cost-based…

  • Principle of Least Privilege for Oracle databases

    Principle of Least Privilege for Oracle databases

    An important concept in computer security, the principle of least privilege (POLP) is to limit users' access rights to…

  • Read Only Table Partitions

    Read Only Table Partitions

    As of Oracle version 12.2, partitions or sub-partitions of a table can be marked as read-only.

  • Hybrid Columnar Compression

    Hybrid Columnar Compression

    Hybrid Columnar Compression (HCC) is a feature that comes with Oracle Database 11g Release 2 and can be used with…

  • Usefully My Oracle Support (MOS) documentation on Oracle Exadata Database Machine

    Usefully My Oracle Support (MOS) documentation on Oracle Exadata Database Machine

    There are MOS documents on many topics related to Exadata. You can find the most useful of these documents in the list…

社区洞察

其他会员也浏览了