Tag Archives: ASM

Creating ASM devices on AIX

We implemented an ASM on a standby database with AIX 6.1. Here’s how you create the asm disks to point to the physical device.

Posted in ASM, Oracle, Setup ASM | Tagged , , | Comments Off

Moving ASM disk between disk groups.

Had reason to move some disks from a data disk group to a backup disk group. Here’s now.

Posted in ASM, Configuration. | Tagged , , , , | Comments Off

Oraenv and ASM.

. oraenv seemed unable to set the environment for an ASM instance. Because ASM instances start with a + symbol (+ASM or +ASMN in RAC), I found that . oraenv +ASM would fail. Interestingly enough other setups did not appear … Continue reading

Posted in ASM, Configuration. | Tagged , , , | Comments Off

Using an spfile in ASM.

Getting the spfile into ASM. The ASM can contain the spfile for your database, but you need to get it in there. Here’s how. Getting the spfile into ASM. The ASM can contain the spfile, but you need to get … Continue reading

Posted in ASM, Configuration., Converting to ASM | Tagged , , , , | Comments Off

ORA-15071: ASM disk “DATA_0003″ is already being dropped

ORA-15071 occurs when dropping a disk from a diskgroup. When attempting to drop a disk from a disk group, the disk is still listed as being in the group, and issuing the command results in: SQL> alter diskgroup data drop … Continue reading

Posted in ASM | Tagged , , , , | Comments Off

Space available in the ASM

How do I find space available in an ASM instance ?

Posted in ASM | Tagged , , , | Comments Off

Using DBMS_FILE_TRANSFER with ASM.

Using DBMS_FILE_TRANSFER with ASM.

Posted in Oracle, PLSQL | Tagged , | Comments Off

Storage Resources for ASM disk groups.

What’s the best allocation of storage to ASM disk groups ?

Posted in ASM | Tagged , , | Comments Off