Helpful tips

How do I know if my ASM is compatible?

How do I know if my ASM is compatible?

Check the compatibility of ASM diskgroup in Oracle

1. Check the compatibility of a ASM diskgroup. SELECT name AS diskgroup, substr(compatibility,1,12) AS asm_compat,
2. Check the ASM attribute. column value for a20.
3. Create diskgroup defines tha attribute.
4. Alter command only used to increased value.

What is compatible ASM?

COMPATIBLE. ASM – The minimum version of the ASM software that can access the disk group. In 11g, the default setting is 10.1. COMPATIBLE. RDBMS – The minimum COMPATIBLE database initialization parameter setting for any database instance that uses the disk group.

How do I check ASM Diskgroup attributes?

How to List ASM Diskgroup Attributes

1. You can use asmcmd lsattr or v$asm_attribute view to display the ASM diskgroup attributes.
2. Synopsis.
3. -G diskgroup – Disk group name.
4. ASMCMD> lsattr -l -G DG_TEST.
5. ASMCMD> lsattr -l -G DG_TEST scrub*
6. Synopsis.
7. -G diskgroup – Disk group name.
8. ASMCMD> lsattr -l -G DG_TEST_DATA compatible*

What is compatible ADVM?

COMPATIBLE. ADVM attribute determines whether the disk group can contain Oracle ADVM volumes. The value must be set to 11.2 or higher. Before setting this attribute, the COMPATIBLE. ASM value must be 11.2 or higher. Also, the Oracle ADVM volume drivers must be loaded in the supported environment.

What is ASM disk repair time?

You need to set DISK_REPAIR_TIME parameter, which gives the time it takes for the disk to get repaired. The default time for this is set to 3.6 hours.

How do I find my ASM version?

ASM Configuration Assistant(ASMCA) commands in Oracle

1. Check version of ASMCMD. — Check ASM version.
2. General ASMCMD commands.
3. Configure and Manage the ASM instance with ASMCA.
4. List the operation going on disk.
5. Manage the Diskgroup and disk with ASMCA.
6. Handle file group or Quota group.
7. Managing the ADVM Volume.

How do I create a Diskgroup in ASM?

1. Create ASM disk. Get the Lun name from storage team. Lun Name – /dev/sda1.
2. Check the ASM Disks, Check the newly added disk, $sudo oracleasm listdisks.
3. Create the ASM Diskgroup. $sqlplus / as sysasm.
4. Check the newly added disk in ASM Diskgroup.

What is Disk_repair_time in ASM?

In other words, the DISK_REPAIR_TIME value is the acceptable time of duration during you need to fix the failure. This setting is also the countdown timer of ASM to drop the disk(s) that have been taken offline. The default setting for DISK_REPAIR_TIME is 3.6 hours.

What is Oracle ADVM?

Oracle ASM Dynamic Volume Manager (Oracle ADVM) provides volume management services and a standard disk device driver interface to clients. File systems and other disk-based applications send I/O requests to Oracle ADVM volume devices as they would to other storage devices on a vendor operating system.

How do I make an ASM disk offline?

To take a disk offline, select the disk to take offline and click Offline. If you bring a disk offline, then Oracle ASM performs the following: Depending on how much data is stale, the operation may require additional time to complete.

What is ASM disk?

Automatic Storage Management (ASM) is an integrated, high-performance database file system and disk manager. ASM groups the disks in your storage system into one or more disk groups. You manage a small set of disk groups and ASM automates the placement of the database files within those disk groups.

When do I set the compatibility attribute in ASM?

For information about disk group compatibility attributes, refer to “Disk Group Compatibility”. The STORAGE.TYPE attribute can be set when creating a disk group or when altering a disk group. The attribute cannot be set when clients are connected to the disk group.

How does the ASM attribute work in Oracle?

ASM attribute determines the minimum software version for an Oracle ASM instance that can use the disk group. This setting also affects the format of the data structures for the Oracle ASM metadata on the disk. The format of other file contents is determined by Oracle ASM Dynamic Volume Manager (Oracle ADVM) and the database instance.

How are disk group attributes determined in ASM?

When an instance of a database which uses ASM storage starts up, it needs to negotiate the minimum compatibility of the ASM disk groups with the corresponding ASM instance. This minimum compatibility of ASM disk groups is determined by disk group attributes as well as by the value of the COMPATIBLE parameter of both instances.

What are the attributes of an 11g ASM instance?

The next listing shows the view from a 10g DB instance using an 11g ASM instance: compatible.asm only determines the format of the persistent metadata which describe an ASM disk group. It must at least have the same value as the compatible.rdbms attribute of the disk group. It does not influence the format of files in the disk group.