Dovevo aggiungere spazio sulla macchina del mio database
[cgadmin@urm-db-prod ~]$ df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 32G 0 32G 0% /dev
tmpfs 32G 0 32G 0% /dev/shm
tmpfs 32G 26M 32G 1% /run
tmpfs 32G 0 32G 0% /sys/fs/cgroup
/dev/sda3 4.0T 3.4T 416G 90% /
/dev/sda2 2.0G 321M 1.5G 18% /boot
/dev/mapper/oraclevg1-oradata1 1007G 913G 43G 96% /opt/oracle/oradatalvm1
/dev/mapper/oraclevg-oradata 1008G 897G 60G 94% /opt/oracle/oradatalvm
/dev/sdd1 2.0T 1.6T 335G 83% /opt/oracle/oradatalvm2
tmpfs 6.3G 0 6.3G 0% /run/user/54321
10.223.4.164:/BACKUP-VOL/urm-db-prod 6.1T 2.6T 3.6T 42% /BACKUP-NFS
tmpfs 6.3G 0 6.3G 0% /run/user/1000
[cgadmin@urm-db-prod ~]$ lsblk
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT
sdf 8:80 0 200G 0 disk
sdd 8:48 0 2T 0 disk
└─sdd1 8:49 0 2T 0 part /opt/oracle/oradatalvm2
sdb 8:16 0 1T 0 disk
└─sdb1 8:17 0 1024G 0 part
└─oraclevg-oradata 252:1 0 1024G 0 lvm /opt/oracle/oradatalvm
sr0 11:0 1 1024M 0 rom
sde 8:64 0 200G 0 disk
sdc 8:32 0 1T 0 disk
└─sdc1 8:33 0 1024G 0 part
└─oraclevg1-oradata1 252:0 0 1024G 0 lvm /opt/oracle/oradatalvm1
sda 8:0 0 4T 0 disk
├─sda2 8:2 0 2G 0 part /boot
├─sda3 8:3 0 4T 0 part /
└─sda1 8:1 0 1M 0 part ho creato una nuova partizione sul disco agganciato
[root@urm-db-prod ~]# fdisk /dev/sdf
Welcome to fdisk (util-linux 2.23.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.
Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0x3f748bde.
Command (m for help): n
Partition type:
p primary (0 primary, 0 extended, 4 free)
e extended
Select (default p): p
Partition number (1-4, default 1): 1
First sector (2048-419430399, default 2048):
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-419430399, default 419430399):
Using default value 419430399
Partition 1 of type Linux and of size 200 GiB is set
Command (m for help): t
Selected partition 1
Hex code (type L to list all codes): 8e
Changed type of partition 'Linux' to 'Linux LVM'
Command (m for help): w
The partition table has been altered!e dopo aver modificato anche l’altro disco (sde) mi trovo questa situazione
[root@urm-db-prod ~]# lsblk
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT
sdf 8:80 0 200G 0 disk
└─sdf1 8:81 0 200G 0 part
sdd 8:48 0 2T 0 disk
└─sdd1 8:49 0 2T 0 part /opt/oracle/oradatalvm2
sdb 8:16 0 1T 0 disk
└─sdb1 8:17 0 1024G 0 part
└─oraclevg-oradata 252:1 0 1024G 0 lvm /opt/oracle/oradatalvm
sr0 11:0 1 1024M 0 rom
sde 8:64 0 200G 0 disk
└─sde1 8:65 0 200G 0 part
sdc 8:32 0 1T 0 disk
└─sdc1 8:33 0 1024G 0 part
└─oraclevg1-oradata1 252:0 0 1024G 0 lvm /opt/oracle/oradatalvm1
sda 8:0 0 4T 0 disk
├─sda2 8:2 0 2G 0 part /boot
├─sda3 8:3 0 4T 0 part /
└─sda1 8:1 0 1M 0 part creo fisicamente i dischi come disco LVM
[root@urm-db-prod ~]# pvcreate /dev/sde1
Physical volume "/dev/sde1" successfully created.
[root@urm-db-prod ~]# pvcreate /dev/sdf1
Physical volume "/dev/sdf1" successfully created.identifico i volum group sui quali operare
[root@urm-db-prod ~]# vgdisplay
--- Volume group ---
VG Name oraclevg
System ID
Format lvm2
Metadata Areas 1
Metadata Sequence No 3
VG Access read/write
VG Status resizable
MAX LV 0
Cur LV 1
Open LV 1
Max PV 0
Cur PV 1
Act PV 1
VG Size <1024.00 GiB
PE Size 4.00 MiB
Total PE 262143
Alloc PE / Size 262143 / <1024.00 GiB
Free PE / Size 0 / 0
VG UUID zLUGyN-eYZg-MY0u-B9oc-igU0-1WaQ-ftoFg0
--- Volume group ---
VG Name oraclevg1
System ID
Format lvm2
Metadata Areas 1
Metadata Sequence No 2
VG Access read/write
VG Status resizable
MAX LV 0
Cur LV 1
Open LV 1
Max PV 0
Cur PV 1
Act PV 1
VG Size <1024.00 GiB
PE Size 4.00 MiB
Total PE 262143
Alloc PE / Size 262143 / <1024.00 GiB
Free PE / Size 0 / 0
VG UUID N3GyiY-S04J-qQEM-Xa3Z-fm3A-C0qC-QBxhldestendo i VG
[root@urm-db-prod ~]# vgextend oraclevg /dev/sde1
Volume group "oraclevg" successfully extended
[root@urm-db-prod ~]# vgextend oraclevg1 /dev/sdf1
Volume group "oraclevg1" successfully extendede verifico
[root@urm-db-prod ~]# pvscan
PV /dev/sdb1 VG oraclevg lvm2 [<1024.00 GiB / 0 free]
PV /dev/sde1 VG oraclevg lvm2 [<200.00 GiB / <200.00 GiB free]
PV /dev/sdc1 VG oraclevg1 lvm2 [<1024.00 GiB / 0 free]
PV /dev/sdf1 VG oraclevg1 lvm2 [<200.00 GiB / <200.00 GiB free]
Total: 4 [2.39 TiB] / in use: 4 [2.39 TiB] / in no VG: 0 [0 ]visualizzo i LV
[root@urm-db-prod ~]# lvdisplay
--- Logical volume ---
LV Path /dev/oraclevg/oradata
LV Name oradata
VG Name oraclevg
LV UUID 5UoLiW-bBk4-cjV2-gZpw-GUHE-qVvb-3x7QcG
LV Write Access read/write
LV Creation host, time urm-db-prod, 2020-10-15 14:37:26 +0200
LV Status available
# open 1
LV Size <1024.00 GiB
Current LE 262143
Segments 1
Allocation inherit
Read ahead sectors auto
- currently set to 8192
Block device 252:1
--- Logical volume ---
LV Path /dev/oraclevg1/oradata1
LV Name oradata1
VG Name oraclevg1
LV UUID N3Ja7C-dsmd-vYhd-2EiF-4I7f-J41I-YPpEF5
LV Write Access read/write
LV Creation host, time urm-db-prod, 2022-04-06 15:19:28 +0200
LV Status available
# open 1
LV Size <1024.00 GiB
Current LE 262143
Segments 1
Allocation inherit
Read ahead sectors auto
- currently set to 8192
Block device 252:0a questo punto estendo il LV
[root@urm-db-prod ~]# lvextend /dev/oraclevg/oradata /dev/sde1
Size of logical volume oraclevg/oradata changed from <1024.00 GiB (262143 extents) to <1.20 TiB (313342 extents).
Logical volume oraclevg/oradata successfully resized.
[root@urm-db-prod ~]# lvextend /dev/oraclevg1/oradata1 /dev/sdf1
Size of logical volume oraclevg1/oradata1 changed from <1024.00 GiB (262143 extents) to <1.20 TiB (313342 extents).
Logical volume oraclevg1/oradata1 successfully resized.[root@urm-db-prod ~]# vgdisplay
--- Volume group ---
VG Name oraclevg
System ID
Format lvm2
Metadata Areas 2
Metadata Sequence No 5
VG Access read/write
VG Status resizable
MAX LV 0
Cur LV 1
Open LV 1
Max PV 0
Cur PV 2
Act PV 2
VG Size <1.20 TiB
PE Size 4.00 MiB
Total PE 313342
Alloc PE / Size 313342 / <1.20 TiB
Free PE / Size 0 / 0
VG UUID zLUGyN-eYZg-MY0u-B9oc-igU0-1WaQ-ftoFg0
--- Volume group ---
VG Name oraclevg1
System ID
Format lvm2
Metadata Areas 2
Metadata Sequence No 4
VG Access read/write
VG Status resizable
MAX LV 0
Cur LV 1
Open LV 1
Max PV 0
Cur PV 2
Act PV 2
VG Size <1.20 TiB
PE Size 4.00 MiB
Total PE 313342
Alloc PE / Size 313342 / <1.20 TiB
Free PE / Size 0 / 0
VG UUID N3GyiY-S04J-qQEM-Xa3Z-fm3A-C0qC-QBxhld
[root@urm-db-prod ~]# lvdisplay
--- Logical volume ---
LV Path /dev/oraclevg/oradata
LV Name oradata
VG Name oraclevg
LV UUID 5UoLiW-bBk4-cjV2-gZpw-GUHE-qVvb-3x7QcG
LV Write Access read/write
LV Creation host, time urm-db-prod, 2020-10-15 14:37:26 +0200
LV Status available
# open 1
LV Size <1.20 TiB
Current LE 313342
Segments 2
Allocation inherit
Read ahead sectors auto
- currently set to 8192
Block device 252:1
--- Logical volume ---
LV Path /dev/oraclevg1/oradata1
LV Name oradata1
VG Name oraclevg1
LV UUID N3Ja7C-dsmd-vYhd-2EiF-4I7f-J41I-YPpEF5
LV Write Access read/write
LV Creation host, time urm-db-prod, 2022-04-06 15:19:28 +0200
LV Status available
# open 1
LV Size <1.20 TiB
Current LE 313342
Segments 2
Allocation inherit
Read ahead sectors auto
- currently set to 8192
Block device 252:0
il file system è un banale ext4
[root@urm-db-prod ~]# resize2fs /dev/oraclevg/oradata
resize2fs 1.45.4 (23-Sep-2019)
Filesystem at /dev/oraclevg/oradata is mounted on /opt/oracle/oradatalvm; on-line resizing required
old_desc_blocks = 128, new_desc_blocks = 153
The filesystem on /dev/oraclevg/oradata is now 320862208 (4k) blocks long.
[root@urm-db-prod ~]# resize2fs /dev/oraclevg1/oradata1
resize2fs 1.45.4 (23-Sep-2019)
Filesystem at /dev/oraclevg1/oradata1 is mounted on /opt/oracle/oradatalvm1; on-line resizing required
old_desc_blocks = 64, new_desc_blocks = 77
The filesystem on /dev/oraclevg1/oradata1 is now 320862208 (4k) blocks long.ed alla fine
[root@urm-db-prod ~]# df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 32G 0 32G 0% /dev
tmpfs 32G 0 32G 0% /dev/shm
tmpfs 32G 26M 32G 1% /run
tmpfs 32G 0 32G 0% /sys/fs/cgroup
/dev/sda3 4.0T 3.4T 416G 90% /
/dev/sda2 2.0G 321M 1.5G 18% /boot
/dev/mapper/oraclevg1-oradata1 1.2T 913G 232G 80% /opt/oracle/oradatalvm1
/dev/mapper/oraclevg-oradata 1.2T 897G 249G 79% /opt/oracle/oradatalvm
/dev/sdd1 2.0T 1.6T 335G 83% /opt/oracle/oradatalvm2
tmpfs 6.3G 0 6.3G 0% /run/user/54321
10.223.4.164:/BACKUP-VOL/urm-db-prod 6.1T 2.6T 3.6T 42% /BACKUP-NFS
tmpfs 6.3G 0 6.3G 0% /run/user/1000
[root@urm-db-prod ~]# lsblk
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT
sdf 8:80 0 200G 0 disk
└─sdf1 8:81 0 200G 0 part
└─oraclevg1-oradata1 252:0 0 1.2T 0 lvm /opt/oracle/oradatalvm1
sdd 8:48 0 2T 0 disk
└─sdd1 8:49 0 2T 0 part /opt/oracle/oradatalvm2
sdb 8:16 0 1T 0 disk
└─sdb1 8:17 0 1024G 0 part
└─oraclevg-oradata 252:1 0 1.2T 0 lvm /opt/oracle/oradatalvm
sr0 11:0 1 1024M 0 rom
sde 8:64 0 200G 0 disk
└─sde1 8:65 0 200G 0 part
└─oraclevg-oradata 252:1 0 1.2T 0 lvm /opt/oracle/oradatalvm
sdc 8:32 0 1T 0 disk
└─sdc1 8:33 0 1024G 0 part
└─oraclevg1-oradata1 252:0 0 1.2T 0 lvm /opt/oracle/oradatalvm1
sda 8:0 0 4T 0 disk
├─sda2 8:2 0 2G 0 part /boot
├─sda3 8:3 0 4T 0 part /
└─sda1 8:1 0 1M 0 part