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
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