Skip to content

Archive for

Couldn’t find device with uuid ‘6fq50M-M4b8-mV4b-10ff-UKHA-CgDE-ojFbn0’ volume group unknown device

When i try to increase the size primary volume group , it show following error.

[root@testser dev]# pvscan

Couldn't find device with uuid '6fq50M-M4b8-mV4b-10ff-UKHA-CgDE-ojFbn0'.
PV /dev/sda2 VG VolGroup00 lvm2 [24.88 GB / 0 free]
PV unknown device VG VolGroup00 lvm2 [4.97 GB / 4.97 GB free]
PV /dev/sde1 lvm2 [4.99 GB]
Total: 3 [34.84 GB] / in use: 2 [29.84 GB] / in no VG: 1 [4.99 GB]

User --removemissing command to resolve this issues.

root@testser dev]# vgreduce --removemissing VolGroup00
Couldn't find device with uuid '6fq50M-M4b8-mV4b-10ff-UKHA-CgDE-ojFbn0'.
Couldn't find device with uuid '6fq50M-M4b8-mV4b-10ff-UKHA-CgDE-ojFbn0'.
Wrote out consistent volume group VolGroup00
[root@testser dev]# pvdisplay

dbms_space displaying information about space usage

Oracle Database provides data dictionary views and PL/SQL packages that allow you to display information about the space usage of schema objects.

DBMS_SPACE : refer here

Just a example :

SQL> VARIABLE total_blocks NUMBER
SQL> VARIABLE total_bytes NUMBER
SQL> VARIABLE unused_blocks NUMBER
SQL> VARIABLE unused_bytes NUMBER
SQL> VARIABLE lastextf NUMBER
SQL> VARIABLE last_extb NUMBER
SQL> VARIABLE lastusedblock NUMBER

SQL> exec DBMS_SPACE.UNUSED_SPACE('SCOTT', 'EMP', 'TABLE', :total_blocks,:total_ bytes,:unused_blocks,:unused_bytes, :lastextf,:last_extb, :lastusedblock);

PL/SQL procedure successfully completed.

SQL> print

TOTAL_BLOCKS
------------
8
TOTAL_BYTES
-----------
65536
UNUSED_BLOCKS
-------------
4
UNUSED_BYTES
------------
32768
LASTEXTF
----------
4
LAST_EXTB
----------
144
LASTUSEDBLOCK
-------------
4

SQL>