Skip to main content

Posts

Showing posts with the label ASM

Add or Create A New ASM Disk On Oracle

 Adding or creating a new ASM (Automatic Storage Management) disk involves several steps. ASM is a feature of Oracle Database that manages database files and provides striping and mirroring for better performance and redundancy. Here's a general outline of the process to add or create a new ASM disk: 1. Identify the Disk First, identify the disk or disks that you want to add or use for ASM. These disks can be physical disks or partitions on your storage devices. 2. Prepare the Disk Before using a disk for ASM, make sure it is not currently being used by any other file system or application. If there is any existing data on the disk, back it up and remove it. 3. Discover the Disk Use the oracleasm command to discover the new disk(s) and make them available to ASM. The exact command may vary based on your Linux distribution and ASM version. Oracleasm command should be run by root user only. For example, on Red Hat-based Linux systems: [root@prod ~]# ora...

ASM Disks Migration from Old storage to New storage on RAC

 Check Number of Disk Groups SQL> select name,path, total_mb, state, mount_status, header_status from v$asm_disk; NAME                      PATH                            TOTAL_MB   STATE   MOUNT_STATUS HEADER_STATUS --------------   ------------------------------      ----------     --------      --------------         ------------ DATA_0000      /dev/oracleasm/disks/DATA      225264    NORMAL      CACHED                MEMBER FRA_0000        /dev/oracleasm/disks/FRA          92160    NORMAL      CACHED                MEMBER CRS_0000      ...