Dracut during initqueue is trying to understand what is your root device that he needs to mount and he can’t understand it… so you probably need to fix the cmdline in your boot.
1- Check if SDA* or Logical Group Name is missing or has been changed
2- Boot your Server into Rescue
3- use blkid command to locate/print block device attributes
# blkid
/dev/ram0: UUID="4a9ee2e6-a7fd-4c33-a95e-998482e1d9a7" TYPE="ext2"
/dev/sda1: PARTLABEL="primary" PARTUUID="96080286-cd99-4994-84f0-32633275666d"
/dev/sda2: LABEL="root" UUID="cccb8548-0f70-49c0-bf3c-abe9a0544d0c" TYPE="ext3" PARTLABEL="primary" PARTUUID="6bf115ff-b584-44ff-bdb1-ef9011a63ab0"
/dev/sda3: UUID="8910d5d3-77d7-4d40-b9f7-b12d025617ca" TYPE="swap" PARTLABEL="primary" PARTUUID="74bcd17b-f8c0-4c25-a428-287c7f9ab8b2"
/dev/sda4: UUID="agrUA9-zne0-UcYC-EdNi-wqb5-4Ch5-r6FRxz" TYPE="LVM2_member" PARTLABEL="primary" PARTUUID="fd1db930-34df-4d6f-91f6-616dd3ea750c"
/dev/mapper/vg00-database: LABEL="usr" UUID="1e78deeb-1173-4ca5-b9ee-a42ea7afeb56" TYPE="ext4"
/dev/mapper/vg00-var: LABEL="var" UUID="2cfb49db-3be3-4f05-b7d1-c6d2a60751cc" TYPE="ext4"
/dev/mapper/vg00-home: LABEL="home" UUID="3602b303-dd4f-4c74-99ad-1b24849382f1" TYPE="ext4"
The Issue here was, Volume Group “usr” has been changed to “database”
/dev/mapper/vg00-database: LABEL="usr" UUID="1e78deeb-1173-4ca5-b9ee-a42ea7afeb56" TYPE="ext4"
4- Mount your Hard Drive into /mnt Directory
# mount /dev/mapper/vg00-var var/
# mount /dev/mapper/vg00-home home/
# mount /dev/mapper/vg00-database usr/
5- cat fstab file
# cat /mnt/etc/fstab
/dev/sda2 / ext3 defaults,noatime 1 1
/dev/sda3 none swap sw
/dev/vg00/usr /usr ext4 defaults,noatime 0 2
/dev/vg00/database /database ext4 defaults,noatime 0 2
/dev/vg00/var /var ext4 defaults,usrquota,noatime 0 2
/dev/vg00/home /home ext4 defaults,usrquota,noatime 0 2
devpts /dev/pts devpts gid=5,mode=620 0 0
none /proc proc defaults 0 0
none /tmp tmpfs defaults 0 0
6- unmount all Drives
# umount -a
7- List Logical volume
# lvdisplay
--- Logical volume ---
LV Path /dev/vg00/database
LV Name database
VG Name vg00
LV UUID fgmzOW-22f2-LRMH-10fE-1si4-MzKd-bjOIlv
LV Write Access read/write
LV Creation host, time punix, 2018-11-19 18:41:14 +0000
LV Status available
# open 1
LV Size 100.00 GiB
Current LE 25600
Segments 2
Allocation inherit
Read ahead sectors auto
- currently set to 256
Block device 253:0
--- Logical volume ---
LV Path /dev/vg00/var
LV Name var
VG Name vg00
LV UUID cz9Agw-UnHu-HJhw-MH4Z-vxu0-DQ85-fb4kI9
LV Write Access read/write
LV Creation host, time punix, 2018-11-19 18:41:14 +0000
LV Status available
# open 0
LV Size 10.00 GiB
Current LE 2560
Segments 1
Allocation inherit
Read ahead sectors auto
- currently set to 256
Block device 253:1
--- Logical volume ---
LV Path /dev/vg00/home
LV Name home
VG Name vg00
LV UUID 6P6Mue-FKHl-BMm1-feen-rRC9-etRH-kcfFhT
LV Write Access read/write
LV Creation host, time punix, 2018-11-19 18:41:14 +0000
LV Status available
# open 0
LV Size 10.00 GiB
Current LE 2560
Segments 1
Allocation inherit
Read ahead sectors auto
- currently set to 256
Block device 253:2
8- Rename wrong volume group to the correct volume group
# lvrename /dev/vg00/database /dev/vg00/usr
Renamed "database" to "usr" in volume group "vg00"
9- Correct the mount Directories in fstab file: we have commented /dev/vg00/database mount point
# cat /mnt/etc/fstab
/dev/sda2 / ext3 defaults,noatime 1 1
/dev/sda3 none swap sw
/dev/vg00/usr /usr ext4 defaults,noatime 0 2
#/dev/vg00/database /database ext4 defaults,noatime 0 2
/dev/vg00/var /var ext4 defaults,usrquota,noatime 0 2
/dev/vg00/home /home ext4 defaults,usrquota,noatime 0 2
devpts /dev/pts devpts gid=5,mode=620 0 0
none /proc proc defaults 0 0
none /tmp tmpfs defaults 0 0
10- Reboot Server into Local mode again.
# reboot