Hi,
I have a problem of one of my ASM disk group. The problem was due to Oracke RAc database uninstallation not properly ended due do network connection problem when i was deinstalling my RAC database in my server (Oracle 11g R2 in Centos 6 using ASM on raw device).
When i deinstall my first installation itwas not done properly and i had to remove all files from Oracle and Grid home to finish the deinstallation but when i tried to install again grid and put OCR in ASM with the same disk partition i got an error of mounting ASM disk group because of the presence of the OCR in the disk partition.
To bypass the problem i was creating new disk partition and do the installation of ASm in this newly created partition and it was working.
Actually i want to reuse this old disk partition to cerate new ASM disk group for my flash recovery and archive log destination but when i invoke ASMCA command it show error in mounting the old OCR diskgroup, it means that the old OCR disk group is still registered in ASM database even it was not configured and this disk group is not mountable.
And when i check the asm_diskgroup tables it seems that this disk group is still register in the system even it was not configured during installation (see command output below):
SQL> select substr(dg.name,1,10) AS diskgroup, SUBSTR(d.name,1,12) AS asmdisk, SUBSTR(dg.compatibility,1,12) AS asm_compat, SUBSTR(dg.database_compatibility,1,12) AS db_compat
FROM V$ASM_DISKGROUP dg, v$asm_disk d
where dg.group_number = d.group_number; 2 3
DISKGROUP ASMDISK ASM_COMPAT DB_COMPAT
------------------ --------------------- -------------------- -------------------
DATA DATA_0000 11.2.0.0.0 10.1.0.0.0
OCR_DISK 0.0.0.0.0 0.0.0.0.0
OCR_DISK 0.0.0.0.0 0.0.0.0.0
SQL> select NAME,STATE,TYPE from V$ASM_DISKGROUP;
NAME STATE TYPE
------------------------------ ----------- ------
OCR_DISK DISMOUNTED
DATA CONNECTED EXTERN
My question is can i remove this disk group from my ASM database and reuse the raw partition to create new disk group from asmca command without disrupting the actual database configuration ?
If yes, what is the process or command to remove it ?
Another question, can i put archivelog dest and flash recoveryarea into an ASM disk group and how can i proceed.
thank you,
Raluce.