Oracle Database Discussions

Hi, We have installed Oracle 11gR2 RAC with ASM,

By mistake I formated the CRS diskgroup using the following,
dd if=/dev/zero of=/dev/rdsk/c5t1d0 bs=4096 count=5000

we dont have any failegroup, we used externam redundancy.

Now my Cluster, ASM is down, I am not able to mount the diskgroup, can any one help me to fix this.


SQL> alter diskgroup asmcrsdg1 mount;
alter diskgroup asmcrsdg1 mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15040: diskgroup is incomplete
ORA-15042: ASM disk "1" is missing from group number "1"


SQL> alter diskgroup asmcrsdg1 add disk '/dev/rdsk/ora_c5t1d0' name asmcrsdg1_0000;
alter diskgroup asmcrsdg1 add disk '/dev/rdsk/ora_c5t1d0' name asmcrsdg1_0000
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15001: diskgroup "ASMCRSDG1" does not exist or is not mounted


SQL> alter diskgroup asmcrsdg1 mount force;
alter diskgroup asmcrsdg1 mount force
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15040: diskgroup is incomplete
ORA-15042: ASM disk "1" is missing from group number "1"


in the alert log file I am seeing the following,


ORA-15130: diskgroup "ASMCRSDG1" is being dismounted
Errors in file /app/oracle/rdbms/diag/asm/+asm/+ASM2/trace/+ASM2_rbal_2410.trc:
ORA-15130: diskgroup "ASMCRSDG1" is being dismounted
ERROR: ORA-15130 in COD recovery for diskgroup 1/0x9ec09c4b (ASMCRSDG1)
ERROR: ORA-15130 thrown in RBAL for group number 1
Errors in file /app/oracle/rdbms/diag/asm/+asm/+ASM2/trace/+ASM2_rbal_2410.trc:
ORA-15130: diskgroup "ASMCRSDG1" is being dismounted
Errors in file /app/oracle/rdbms/diag/asm/+asm/+ASM2/trace/+ASM2_rbal_2410.trc:
ORA-15130: diskgroup "ASMCRSDG1" is being dismounted
ERROR: ORA-15130 in COD recovery for diskgroup 1/0x9ec09c4b (ASMCRSDG1)
ERROR: ORA-15130 thrown in RBAL for group number 1
Errors in file /app/oracle/rdbms/diag/asm/+asm/+ASM2/trace/+ASM2_rbal_2410.trc:
ORA-15130: diskgroup "ASMCRSDG1" is being dismounted
Errors in file /app/oracle/rdbms/diag/asm/+asm/+ASM2/trace/+ASM2_rbal_2410.trc:
ORA-15130: diskgroup "ASMCRSDG1" is being dismounted

Edited by: ManoRangasamy on Nov 8, 2010 1:38 PM