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

How to recovery PDB when PDB database is dropped in Oracle

  How to recovery PDB when PDB database is dropped :) [oracle@rac01 ~]$ sqlplus '/as sysdba' SQL*Plus: Release 21.0.0.0.0 - Product...