Hey folks
Is there a way to reset the ASM Instance. I mean, where does ASM stores the information e.g. the diskgroup name etc..? there is nowhere an controlfile or something similar.
the reason is: I can't drop my diskgroup because i can't mount them anymore. I think my fault was, that I include in asm_diskstring all four device files. I use an EVA.
SQL> alter system set asm_diskstring='/dev/rdsk/c*t*d*' scope=both;
System altered.
SQL> show parameter asm_diskstr
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskstring string /dev/rdsk/c*t*d*
SQL> select path from v$asm_disk;
PATH
--------------------------------------------------------------------------------
/dev/rdsk/c8t0d6
/dev/rdsk/c2t0d6
/dev/rdsk/c4t0d6
/dev/rdsk/c6t0d6
...skip...
#this are the four device files
24 rows selected.
SQL> create diskgroup testing external redundancy disk '/dev/rdsk/c6t0d6';
create diskgroup testing external redundancy disk '/dev/rdsk/c6t0d6'
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15030: diskgroup name "TESTING" is in use by another diskgroup
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
TESTING DISMOUNTED
SQL> alter diskgroup testing mount;
alter diskgroup testing mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15024: discovered duplicately numbered ASM disk 0
SQL> !oerr ORA 15024
15024, 00000, "discovered duplicately numbered ASM disk %s"
// *Cause: The discovery encountered two disks claiming to have the same
// ASM disk number.
// *Action: Check that the ASM_DISKSTRING parameter specifies only a
// single path for each disk.
//
#change it to one path
SQL> alter system set asm_diskstring='/dev/rdsk/c6t0d6' scope=both;
System altered.
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
TESTING DISMOUNTED
SQL> alter diskgroup testing mount;
alter diskgroup testing mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15063: ASM discovered an insufficient number of disks for diskgroup
"TESTING"
SQL> drop diskgroup testing;
drop diskgroup testing
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15001: diskgroup "TESTING" does not exist or is not mounted
where does ASM store the diskgroup name "testing"?
is there a way to reset the whole ASM configuration?
I have already deleted the device files and recreate them with insf -e.
OS: HPUX 11.23
ASM:10.2.0.3
Any ideas?
Regards Oviwan