HANA資料庫伺服器備份卷擴容（Linux LVM）

HANA資料庫備份出現錯誤，從錯誤上看明細是備份盤的孔家滿了。

[447] backup could not be completed, [2000008] Error during asynchronous file transfer (io_getevents), rc=28: No space left on device; $fileCallback$=[W] , buffer= 

1.在AWS控制台中擴充卷，從1000G變成2000G

2.登入到機器中fdisk-l,看到磁盤大小實際上不變

3.以為需要umount，結果umount是提示失敗

HANADBPRD:/hana/hanabackup/data # umount /hana/hanabackup

umount: /hana/hanabackup: target is busy

        (In some cases useful info about processes that

         use the device is found by lsof(8) or fuser(1).)

HANADBPRD:/hana/hanabackup/data # fuser -mv /hana/hanabackup

                     USER        PID ACCESS COMMAND

/hana/hanabackup:    root     kernel mount /hana/hanabackup

                     root       4031 ..c.. bash          

                     root      14117 ..c.. fuser             --c表示程序是在該目錄下啟動

                     root      48758 ..c.. bash

                     s4padm    45588 F.... hdbindexserver    --F表示打開檔案

HANADBPRD:/hana/hanabackup/data # lsof /hana/hanabackup

COMMAND   PID USER   FD   TYPE DEVICE SIZE/OFF       NODE NAME

bash     4031 root  cwd    DIR  254,3       69  193017069 /hana/hanabackup/data

lsof    14201 root  cwd    DIR  254,3       69  193017069 /hana/hanabackup/data

lsof    14202 root  cwd    DIR  254,3       69  193017069 /hana/hanabackup/data

bash    48758 root  cwd    DIR  254,3     4096 1074766613 /hana/hanabackup/data/DB_S4P

4.修改歸檔日志備份配置

因為是HANA的備份設定備份到此檔案夾，避免強行解除安裝後系統備份出現問題導緻系統夯住，是以就先修改備份配置

在hana studio中以system登入，backup and recover---configuration,将log backup settings中将日志歸檔disable.

5.強制解除安裝卷 umount -l /home

6.擴容還是失敗

HANADBPRD:/hana/hanabackup # growpart /dev/xvvvv4n1 1

WARN: unknown label 

failed [sfd_dump:1] sfdisk --unit=S --dump /dev/xvvvv4n1

sfdisk: /dev/xvvvv4n1: does not contain a recognized partition table

FAILED: failed to dump sfdisk info for /dev/xvvvv4n1

HANADBPRD:/ # mount /dev/xvvvv4n1 /hana/hanabackup

mount: unknown filesystem type 'LVM2_member'

原來是用LVM進行管理的，其實都可以不用umount的

7.LVM擴容

---檢視卷組

HANADBPRD:/ # vgs  

  VG            #PV #LV #SN Attr   VSize    VFree

  vg_hana         3   3   0 wz--n- 1001.99g 1.99g

  vg_hanabackup   1   1   0 wz--n- 1000.00g    0 

---檢視實體卷

HANADBPRD:/ # pvs

  PV           VG            Fmt  Attr PSize    PFree

  /dev/xvme2n1 vg_hana       lvm2 a--   334.00g    0 

  /dev/xvvvv4n1 vg_hanabackup lvm2 a--  1000.00g    0 

  /dev/xvme4n1 vg_hana       lvm2 a--   334.00g 1.99g

  /dev/xvme6n1 vg_hana       lvm2 a--   334.00g    0 

--擴容實體卷

HANADBPRD:/ # pvresize -v /dev/nvvvv4n1

    Using physical volume(s) on command line.

    Archiving volume group "vg_hanabackup" metadata (seqno 3).

    Resizing volume "/dev/nvvvv4n1" to 4194304000 sectors.

    Resizing physical volume /dev/nvvvv4n1 from 0 to 511999 extents.

    Updating physical volume "/dev/nvvvv4n1"

    Creating volume group backup "/etc/lvm/backup/vg_hanabackup" (seqno 4).

  Physical volume "/dev/nvvvv4n1" changed

  1 physical volume(s) resized / 0 physical volume(s) not resized

--檢視實體卷，此時磁盤已經成了2T

HANADBPRD:/ # pvs

  PV           VG            Fmt  Attr PSize   PFree   

  /dev/nvvvv4n1 vg_hanabackup lvm2 a--    1.95t 1000.00g

---檢視卷組

HANADBPRD:/ # vgs

  VG            #PV #LV #SN Attr   VSize    VFree   

  vg_hanabackup   1   1   0 wz--n-    1.95t 1000.00g

---檢視邏輯卷，邏輯卷還是沒有變化

HANADBPRD:/ # lvs

  LV            VG            Attr       LSize    Pool Origin Data%  Meta%  Move Log Cpy%Sync Convert                                               

  lv_hanabackup vg_hanabackup -wi-ao---- 1000.00g  

--擴充邏輯卷，                                                

HANADBPRD:/ # lvextend -L +1000g /dev/vg_hanabackup/lv_hanabackup

  Size of logical volume vg_hanabackup/lv_hanabackup changed from 1000.00 GiB (255999 extents) to 1.95 TiB (511999 extents).

  Logical volume lv_hanabackup successfully resized

---檢視邏輯卷，邏輯卷已變大

HANADBPRD:/ # lvs

  LV            VG            Attr       LSize   Pool Origin Data%  Meta%  Move Log Cpy%Sync Convert

  lv_hanadata   vg_hana       -wi-ao---- 400.00g                                                    

  lv_hanalog    vg_hana       -wi-ao---- 300.00g                                                    

  lv_hanashared vg_hana       -wi-ao---- 300.00g                                                    

  lv_hanabackup vg_hanabackup -wi-ao----   1.95t  

--挂載卷并擴容，df- h中，邏輯卷還是沒有擴容，

此時必須擴容卷，這個地方很容易卡住，主要原因是需要看你的檔案系統用不同的工具指令：

resize2fs針對ext2/ext3/ext4 file system resize

xfs的需要使用xfs_growfs

HANADBPRD:/ # mount /dev/mapper/vg_hanabackup-lv_hanabackup /hana/hanabackup

HANADBPRD:/ # xfs_growfs /hana/hanabackup

meta-data=/dev/mapper/vg_hanabackup-lv_hanabackup isize=512    agcount=4, agsize=65535744 blks

         =                       sectsz=512   attr=2, projid32bit=1

         =                       crc=1        finobt=0 spinodes=0

data     =                       bsize=4096   blocks=262142976, imaxpct=25

         =                       sunit=0      swidth=0 blks

naming   =version 2              bsize=4096   ascii-ci=0 ftype=1

log      =internal               bsize=4096   blocks=127999, version=2

         =                       sectsz=512   sunit=0 blks, lazy-count=1

realtime =none                   extsz=4096   blocks=0, rtextents=0

data blocks changed from 262142976 to 524286976

-檢視卷大小，這個時候已經是2T了。

--df -h 

/dev/mapper/vg_hanabackup-lv_hanabackup  2.0T  733G  1.3T  37% /hana/hanabackup

8.進入hana statuio中重新啟動自動歸檔的功能。