What is ASM in Oracle 11gR2?

What is ASM in Oracle 11gR2?

Automatic Storage Management (ASM) is an integrated, high-performance database file system and disk manager. ASM eliminates the need for you to directly manage potentially thousands of Oracle database files. ASM groups the disks in your storage system into one or more disk groups.

How do you check disk on ASM?

To see all disks, use V$ASM_DISKGROUP instead. Contains one row for every Oracle ASM file in every disk group mounted by the Oracle ASM instance. In an Oracle ASM instance, contains one row for every active Oracle ASM long running operation executing in the Oracle ASM instance.

How do I create ASM Diskgroup in 11gR2?

CREATE DISKGROUP MANUAL in 11gR2

1. CREATING ORACLEASM DISKS using ‘oracleasm createdisk’ command as root.
2. VERIFYING ASK DISK LABEL BY PROVIDING DISK.
3. VERIFYING DISK USING listdiks.
4. CREATING THE DISK GROUP IN COMMAND PROMPT.

How do I configure Oracleasm?

updating the configuration file /etc/sysconfig/oracleasm. Creating ASM disk groups….1. Install and configure ASMLIB software

1. An open source (GPL) kernel module package: kmod-oracleasm.
2. An open source (GPL) utilities package: oracleasm-support.
3. A closed source (proprietary) library package: oracleasmlib.

How do I know if I have ASMLib?

d/oracleasm createdisk is used. There is a situation during scandisks operation where the ASMLIB is binded to the single/individual path and not to the pseudo device. You can verify this running an ls -l /dev/oracleasm/disks and checking the major,minor numbers of the devices.

When to set disk group attributes in Oracle ASM?

Disk group attributes are parameters that are bound to a disk group, rather than an Oracle ASM instance. Disk group attributes can be set when a disk group is created or altered, unless otherwise noted in the following list. ACCESS_CONTROL.ENABLED. This attribute can only be set when altering a disk group.

What is the default value for Oracle ASM failure group?

The type value determines the distance to the nearest neighbor disk in the failure group where Oracle ASM mirrors copies of the data. The default value is data which specifies a distance of 1 to the nearest neighbor disk.

When to enable Columnar Compression in Oracle ASM?

If the STORAGE.TYPE disk group attribute is set to AXIOM or ZFSSA, then functionality for Hybrid Columnar Compression (HCC) can be enabled for Pillar Axiom or ZFS storage. ZFS storage must be added through Direct NFS (dNFS) and Pillar Axiom storage must be added as SCSI/Fiber Channel.

What should be the redundancy level for Oracle ASM?

Specify the redundancy level of the disk group. For Oracle ASM to mirror files, specify the redundancy level as NORMAL REDUNDANCY (2-way mirroring by default for most file types) or HIGH REDUNDANCY (3-way mirroring for all files). Specify EXTERNAL REDUNDANCY if you do not want mirroring by Oracle ASM.