Search This Blog

Thursday, February 18, 2021

Unable to bring up DATA diskgroup in ASM

Error :
ORA-15032: not all alterations performed
ORA-15040: diskgroup is incomplete
ORA-15042: ASM disk "1" is missing from group number "2"
Solution :
1.) ls -ltr /dev/sdb* 
2.) As root, 
- cd <asm home>/bin and create a shell file called kfed.sh using the following script 
- And change the permission as executable - ex) chmod 755 kfed.sh 
vi kfed.sh 
#! /bin/sh 
rm /tmp/kfed_DH.out /tmp/kfed_FS.out /tmp/kfed_BK.out /tmp/kfed_FD.out /tmp/kfed_DD.out 
for i in `ls kfed read /dev/sd*` 
do 
echo $i >> /tmp/kfed_DH.out 
./kfed read $i >> /tmp/kfed_DH.out 
echo $i >> /tmp/kfed_FS.out 
./kfed read $i blkn=1 >> /tmp/kfed_FS.out 
echo $i >> /tmp/kfed_BK.out 
./kfed read $i aun=1 blkn=254 >> /tmp/kfed_BK.out 
echo $i >> /tmp/kfed_FD.out 
./kfed read $i aun=2 blkn=1 >> /tmp/kfed_FD.out 
echo $i >> /tmp/kfed_DD.out 
./kfed read $i aun=2 blkn=2 >> /tmp/kfed_DD.out 
echo $i >> /tmp/kfed_PST.out 
./kfed read $i aun=1 blkn=2 >> /tmp/kfed_PST.out 
done 
---- 
- Run kfed.sh in <asm home>/bin 
#chmod u+x kfed.sh 
# kfed.sh 
- Upload /tmp/kfed_DH.out, /tmp/kfed_FS.out, /tmp/kfed_BK.out, /tmp/kfed_FD.out, /tmp/kfed_DD.out and /tmp/kfed_PST.out 
_+_)_+_+_+_+_+__+_+_+_+__+_+_+_+++__+_+_++_ 


alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS'; 
select 'THIS ASM REPORT WAS GENERATED AT: ==)> ' , sysdate " " from dual; 
select 'HOSTNAME ASSOCIATED WITH THIS ASM INSTANCE: ==)> ' , MACHINE " " from v$session where program like '%SMON%'; 
select * from v$asm_diskgroup; 
SELECT * FROM V$ASM_DISK ORDER BY GROUP_NUMBER,DISK_NUMBER; 
select * from gv$asm_operation; 
select * from v$version; 
show parameter 


4.)kfod asm_diskstring='<diks_path>' disks=all


#>   ls -ltr /dev/sdb*
brw-r----- 1 root disk 8, 20 Dec 22 17:50 /dev/sdb4
brw-r----- 1 root disk 8, 17 Dec 22 17:50 /dev/sdb1
brw-r----- 1 root disk 8, 16 Dec 22 17:50 /dev/sdb
brw-rw---- 1 root dba  8, 18 Dec 22 19:46 /dev/sdb2
brw-rw---- 1 root dba  8, 19 Dec 22 20:12 /dev/sdb3

$>  ls -ltr /dev/sdb2
brw-rw---- 1 root dba 8, 18 Dec 22 22:02 /dev/sdb2
[oracle@db1:~]
$>  ls -ltr /dev/sdb4
brw-rw---- 1 root disk 8, 20 Dec 22 17:50 /dev/sdb4
[oracle@db1:~]
$>  ls -ltr /dev/sdb3
brw-rw---- 1 root dba 8, 19 Dec 22 22:10 /dev/sdb3
Login as root and change the ownership
#>  chown -R root:dba /dev/sdb4
[oracle@db1:~]
$>  ls -ltr /dev/sdb4
brw-rw---- 1 root dba 8, 20 Dec 22 17:50 /dev/sdb4

$>  kfed read /dev/sdb4
kfbh.endian:                          1 ; 0x000: 0x01
kfbh.hard:                          130 ; 0x001: 0x82
kfbh.type:                            1 ; 0x002: KFBTYP_DISKHEAD


No comments:

Post a Comment

Transportable tablespace refresh

  1.check tablespace for the user which need to refresh -------------------------------------------------------------------  SQL> select ...