Hi all gurus,
Here I have a bit complicated situation that I would like to discuss, it would be appreciate if anyone could share the light on this issue.
Currently I face a sudden error where suddenly my main diskgroup which is DATA fail to mount.
When I try to mount manually via ASMCMD or under SQL environment, I get the ORA-15042 error.
I assume this due to the disk are corrupted, yet when I try to investigate from OS level seems all disk and permission are working fine. Below are the output :-
SQL> select group_number, name, state from v$asm_diskgroup;
GROUP_NUMBER NAME STATE
------------ ------------------------------ -----------
1 ACFS MOUNTED
2 CRS MOUNTED
0 DATA DISMOUNTED
4 FRA MOUNTED
SQL> select path, mount_status, header_status, group_number, name, state, total_mb from v$asm_disk;
PATH MOUNT_S HEADER_STATU GROUP_NUMBER NAME STATE TOTAL_MB
------------------------------ ------- ------------ ------------ ------------------------------ -------- ----------
/dev/rdsk/c1t1d0s4 CLOSED MEMBER 0 NORMAL 0 <-- This is the disk pointing to the DATA diskgroup
/dev/rdsk/c1t2d0s4 CACHED MEMBER 4 FRA_0000 NORMAL 30623
/dev/rdsk/c1t3d0s4 CACHED MEMBER 2 CRS_0000 NORMAL 5018
/dev/rdsk/c1t4d0s4 CACHED MEMBER 1 ACFS_0000 NORMAL 1000
bash-3.2# od -c -N 128 /dev/rdsk/c1t1d0s4
0000000 001 202 001 001 \0 \0 \0 \0 \0 \0 \0 200 r . @ 225
0000020 036 027 002 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
0000040 O R C L D I S K \0 \0 \0 \0 \0 \0 \0 \0
0000060 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
0000100 \0 \0 013 \0 \0 001 003 D A T A _ 0 0 0
0000120 0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
0000140 \0 \0 \0 \0 \0 \0 \0 \0 D A T A \0 \0 \0 \0
0000160 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
0000200
| bash-3.2$ kfed read /dev/rdsk/c1t1d0s4 | |
kfbh.endian: 1 ; 0x000: 0x01
kfbh.hard: 130 ; 0x001: 0x82
kfbh.type: 1 ; 0x002: KFBTYP_DISKHEAD
kfbh.datfmt: 1 ; 0x003: 0x01
kfbh.block.blk: 0 ; 0x004: blk=0
kfbh.block.obj: 2147483648 ; 0x008: disk=0
kfbh.check: 2504011378 ; 0x00c: 0x95402e72
kfbh.fcn.base: 136990 ; 0x010: 0x0002171e
kfbh.fcn.wrap: 0 ; 0x014: 0x00000000
kfbh.spare1: 0 ; 0x018: 0x00000000
kfbh.spare2: 0 ; 0x01c: 0x00000000
kfdhdb.driver.provstr: ORCLDISK ; 0x000: length=8
kfdhdb.driver.reserved[0]: 0 ; 0x008: 0x00000000
kfdhdb.driver.reserved[1]: 0 ; 0x00c: 0x00000000
kfdhdb.driver.reserved[2]: 0 ; 0x010: 0x00000000
kfdhdb.driver.reserved[3]: 0 ; 0x014: 0x00000000
kfdhdb.driver.reserved[4]: 0 ; 0x018: 0x00000000
kfdhdb.driver.reserved[5]: 0 ; 0x01c: 0x00000000
kfdhdb.compat: 186646528 ; 0x020: 0x0b200000
kfdhdb.dsknum: 0 ; 0x024: 0x0000
kfdhdb.grptyp: 1 ; 0x026: KFDGTP_EXTERNAL
kfdhdb.hdrsts: 3 ; 0x027: KFDHDR_MEMBER
kfdhdb.dskname: DATA_0000 ; 0x028: length=9
kfdhdb.grpname: DATA ; 0x048: length=4
kfdhdb.fgname: DATA_0000 ; 0x068: length=9
Kindly need your advise on this, any idea would be appreciated