Disclaimer

Sunday, 24 November 2024

Recover disk in NORMAL redundancy

 

Steps to Recover a Disk in Normal Redundancy





Solution 1:



Solution 2:-




Steps to Recover a Disk in Normal Redundancy

  1. Identify the Problematic Disk

    • Log in to ASM and check the status of the disk group and disks:
      SET LINESIZE 200
      COL NAME FORMAT A30 SELECT GROUP_NUMBER, NAME, STATE, PATH FROM V$ASM_DISK;
    • Check for any disks in the MISSING state or flagged with FORCING OFFLINE.
  2. Drop the Missing/Failed Disk

    • Drop the failed disk from the disk group:
      ALTER DISKGROUP <diskgroup_name> DROP DISK <disk_name>;
    • If the drop operation is stuck, you can force the drop:
      ALTER DISKGROUP <diskgroup_name> DROP DISK <disk_name> FORCE;
  3. Add a New Disk (if necessary)

    • If there is no replacement disk automatically available, you will need to add a new disk to the disk group:
      ALTER DISKGROUP <diskgroup_name> ADD DISK '/path_to_new_disk';
  4. Rebalance the Disk Group

    • ASM will automatically rebalance the disk group when a disk is added or removed. Monitor the rebalancing process:
      SELECT OPERATION, STATE, SOFAR, EST_WORK FROM V$ASM_OPERATION;
    • Optionally, you can manually adjust the rebalancing power to speed up or slow down the process:
      ALTER DISKGROUP <diskgroup_name> REBALANCE POWER <level>;
      Replace <level> with a value from 0 (low impact) to 11 (high impact).
  5. Verify the Disk Group Status

    • After rebalancing completes, check the status of the disk group:
      SELECT NAME, STATE, TYPE, TOTAL_MB, FREE_MB FROM V$ASM_DISKGROUP;
    • Ensure there are no errors or missing disks.


No comments:

Post a Comment

Understanding SQL Plan Baselines in Oracle Database

  Understanding SQL Plan Baselines in Oracle Database SQL Plan Baseline is the feature in Oracle started from Database 11g that helps to pre...