Mục đích: Hướng dẫn các câu lệnh kiểm tra, giám sát, khắc phục lỗi storage trên Solaris (phần tạo các File system có mục riềng)
1.Scan để nhận phân vùng SAN (2 node) |
Echo |format |grep 00000036 | ||||||||||
2.Check thông tin phân vùng SAN |
-- Check số đường đi và thông tin phân vùng khác loại SAN, số controller, WWN,
root@dbaviet # mpathadm list lu /dev/rdsk/c7t60060E80056F530000006F5300000004d0s2 | ||||||||||
Check LUN được cấp từ SAN tập trung nào | -- Check LUN được cấp từ SAN tập trung nào root@dbaviet:~# luxadm display /dev/rdsk/c0t60060E80056F530000006F5300000000d0s2 DEVICE PROPERTIES for disk: /dev/rdsk/c0t60060E80056F530000006F5300000000d0s2 Vendor: HITACHI Product ID: OPEN-V -SUN Revision: 6008 --> ST9990v; 7006 là VSP; 5009 ST9985; Oracle FS1-2 6203. Đối soát Serial Num: 50 06F530000 Unformatted capacity: 1017177.000 MBytes Read Cache: Enabled Minimum prefetch: 0x0 Maximum prefetch: 0x0 Device Type: Disk device Path(s):
/dev/rdsk/c0t60060E80056F530000006F5300000000d0s2 /devices/scsi_vhci/ssd@g60060e80056f530000006f5300000000:c,raw Controller /devices/pci@300/pci@1/pci@0/pci@4/SUNW,emlxs@0/fp@0,0 Device Address 50060e80056f5362,4 Host controller port WWN 10000090fa6d736a Class primary State ONLINE | ||||||||||
Check HBA | WWN của cặp server cài DB RAC: root@dbaviet:~# fcinfo hba-port HBA Port WWN: 10000090fa9b6ca0 HBA Port WWN: 10000090fa9b6ca1
root@dbaviet:~# fcinfo hba-port HBA Port WWN: 10000090fa0d31bc HBA Port WWN: 10000090fa0d31bd | ||||||||||
Controller A, B trên Storage | Storage có 2 controller A & B. Nhưng theo cấu hình hiện tại chỉ có 1 controller A được cấu hình đi qua san switch (controller B hiện tại ko được dùng).
Do vậy để đảm bảo tính dự phòng trong trường hợp controller A bị reset thì hệ thống vẫn hoạt động được. Phương án như sau: 1. Bổ sung thêm 2 dây quang sau đó kết nối tới 2 san swich.
Sơ đồ hiện tại và bổ sung thêm dây quang như sau:
Storage hiện tại đang dùng firmware version 7xxx vẫn đang hoạt động ổn định. | ||||||||||
3.Check dung lượng metadata | root@app-01 # samcmd m
Mass storage status samcmd 4.6.85 00:38:00 Feb 1 2013 samcmd on app-01
ty eq status use state ord capacity free ra part high low
ma 810 m----2c--r- 1% on 1.796T 1.796T 1M 16 80% 70% mm 811 1% on 0 40.000G 39.991G [83867104 inodes] mr 812 1% on 1 1.796T 1.796T
ma 820 m----2c--r- 1% on 1.796T 1.796T 1M 16 80% 70% mm 821 1% on 0 40.000G 39.991G [83867104 inodes] mr 822 1% on 1 1.796T 1.796T
ma 830 m----2c--r- 1% on 1.796T 1.796T 1M 16 80% 70% mm 831 1% on 0 40.000G 39.991G [83867104 inodes] mr 832 1% on 1 1.796T 1.796T | ||||||||||
Check thông tin các partition | # format -- chọn 1 đĩa format> pa partition> pr | ||||||||||
Disable | dbaviet, Bước 1: disable 2 đường này (1 port vật lý tương đương với 2 đường logic; Card1 có 2 Card HBA, mỗi port 2 port) mpathadm disable path -i 10000000c963ab61 -t 50060e80056f5325 –l /dev/rdsk/c7t60060E80056F530000006F5300000004d0s2 mpathadm disable path -i 10000000c963ab61 -t 50060e80056f5307 –l /dev/rdsk/c7t60060E80056F530000006F5300000004d0s2 (10000000c963ab61 là WWN của 1 port trên 1 card)
root@dbaviet # luxadm probe No Network Array enclosures found in /dev/es
Found Fibre Channel device(s): Node WWN:50060e8004a53b34 Device Type:Disk device Logical Path:/dev/rdsk/c7t60060E8004A53B000000A53B00000212d0s2 Node WWN:50060e80056f5335 Device Type:Disk device Logical Path:/dev/rdsk/c7t60060E80056F530000006F5300000004d0s2 Node WWN:50060e801026c5b2 Device Type:Disk device Logical Path:/dev/rdsk/c7t60060E801026C5B00511448B00000000d0s2 Node WWN:50060e801026c5b2 Device Type:Disk device Logical Path:/dev/rdsk/c7t60060E801026C5B00511448B00000001d0s2 Node WWN:50060e801026c5b2 Device Type:Disk device Logical Path:/dev/rdsk/c7t60060E801026C5B00511448B0000005Bd0s2 Node WWN:50060e801036abe2 Device Type:Disk device Logical Path:/dev/rdsk/c7t60060E801036ABE0057DAEEE000001F8d0s2 Node WWN:50060e801663d812 Device Type:Disk device Logical Path:/dev/rdsk/c7t60060E801663D800000163D800000300d0s2 Node WWN:50060e801663d812 Device Type:Disk device Logical Path:/dev/rdsk/c7t60060E801663D800000163D800000301d0s2 Node WWN:50060e801663d812 Device Type:Disk device Logical Path:/dev/rdsk/c7t60060E801663D800000163D800000302d0s2 Node WWN:50060e801663d812 Device Type:Disk device Logical Path:/dev/rdsk/c7t60060E801663D800000163D800000303d0s2 Node WWN:50060e801663d812 Device Type:Disk device Logical Path:/dev/rdsk/c7t60060E801663D800000163D800000304d0s2 Node WWN:50060e801663d812 Device Type:Disk device Logical Path:/dev/rdsk/c7t60060E801663D800000163D800000305d0s2 Node WWN:50060e801663d812 Device Type:Disk device Logical Path:/dev/rdsk/c7t60060E801663D800000163D800000306d0s2 Node WWN:50060e801663d812 Device Type:Disk device Logical Path:/dev/rdsk/c7t60060E801663D800000163D800000400d0s2 Node WWN:50060e801663d812 Device Type:Disk device Logical Path:/dev/rdsk/c7t60060E801663D800000163D800000401d0s2 Node WWN:50060e801663d812 Device Type:Disk device Logical Path:/dev/rdsk/c7t60060E801663D800000163D800000402d0s2
root@dbaviet # luxadm display /dev/rdsk/c7t60060E80056F530000006F5300000004d0s2 DEVICE PROPERTIES for disk: /dev/rdsk/c7t60060E80056F530000006F5300000004d0s2 Vendor: HITACHI Product ID: OPEN-V -SUN Revision: 6008 Serial Num: 50 06F530004 Unformatted capacity: 1520435.250 MBytes Write Cache: Enabled Read Cache: Enabled Minimum prefetch: 0x0 Maximum prefetch: 0x0 Device Type: Disk device Path(s):
/dev/rdsk/c7t60060E80056F530000006F5300000004d0s2 /devices/scsi_vhci/ssd@g60060e80056f530000006f5300000004:c,raw
Controller /devices/ssm@0,0/pci@18,600000/SUNW,emlxs@1/fp@0,0 Device Address 50060e80056f5335,0 Host controller port WWN 10000000c963a9da Class primary State ONLINE
Controller /devices/ssm@0,0/pci@18,600000/SUNW,emlxs@1/fp@0,0 Device Address 50060e80056f5317,0 Host controller port WWN 10000000c963a9da Class primary State ONLINE
Controller /devices/ssm@0,0/pci@18,600000/SUNW,emlxs@1,1/fp@0,0 Device Address 50060e80056f5317,0 Host controller port WWN 10000000c963a9db Class primary State ONLINE
Controller /devices/ssm@0,0/pci@18,600000/SUNW,emlxs@1,1/fp@0,0 Device Address 50060e80056f5335,0 Host controller port WWN 10000000c963a9db Class primary State ONLINE
Controller /devices/ssm@0,0/pci@19,700000/SUNW,emlxs@1/fp@0,0 Device Address 50060e80056f5325,0 Host controller port WWN 10000000c963ab60 Class primary State ONLINE
Controller /devices/ssm@0,0/pci@19,700000/SUNW,emlxs@1/fp@0,0 Device Address 50060e80056f5307,0 Host controller port WWN 10000000c963ab60 Class primary State ONLINE
Controller /devices/ssm@0,0/pci@19,700000/SUNW,emlxs@1,1/fp@0,0 Device Address 50060e80056f5325,0 Host controller port WWN 10000000c963ab61 Class primary State ONLINE I/Os disabled on this ONLINE path
Controller /devices/ssm@0,0/pci@19,700000/SUNW,emlxs@1,1/fp@0,0 Device Address 50060e80056f5307,0 Host controller port WWN 10000000c963ab61 Class primary State ONLINE I/Os disabled on this ONLINE path
-- Disable cả port 10000000c963ab61 (trên server) trên tất cả các phân vùng: mpathadm disable path -i 10000000c963ab61 -t 50060e801036abea -l /dev/rdsk/c7t60060E801036ABE0057DAEEE000001F8d0s2
mpathadm disable path -i 10000000c963ab61 -t 50060e801663d851 -l /dev/rdsk/c7t60060E801663D800000163D800000300d0s2 mpathadm disable path -i 10000000c963ab61 -t 50060e801663d822 -l /dev/rdsk/c7t60060E801663D800000163D800000300d0s2
mpathadm disable path -i 10000000c963ab61 -t 50060e801663d851 -l /dev/rdsk/c7t60060E801663D800000163D800000301d0s2 mpathadm disable path -i 10000000c963ab61 -t 50060e801663d822 -l /dev/rdsk/c7t60060E801663D800000163D800000301d0s2
mpathadm disable path -i 10000000c963ab61 -t 50060e801663d851 -l /dev/rdsk/c7t60060E801663D800000163D800000302d0s2 mpathadm disable path -i 10000000c963ab61 -t 50060e801663d822 -l /dev/rdsk/c7t60060E801663D800000163D800000302d0s2
mpathadm disable path -i 10000000c963ab61 -t 50060e801663d851 -l /dev/rdsk/c7t60060E801663D800000163D800000303d0s2 mpathadm disable path -i 10000000c963ab61 -t 50060e801663d822 -l /dev/rdsk/c7t60060E801663D800000163D800000303d0s2
mpathadm disable path -i 10000000c963ab61 -t 50060e801663d851 -l /dev/rdsk/c7t60060E801663D800000163D800000304d0s2 mpathadm disable path -i 10000000c963ab61 -t 50060e801663d822 -l /dev/rdsk/c7t60060E801663D800000163D800000304d0s2
mpathadm disable path -i 10000000c963ab61 -t 50060e801663d851 -l /dev/rdsk/c7t60060E801663D800000163D800000305d0s2 mpathadm disable path -i 10000000c963ab61 -t 50060e801663d822 -l /dev/rdsk/c7t60060E801663D800000163D800000305d0s2
mpathadm disable path -i 10000000c963ab61 -t 50060e801663d851 -l /dev/rdsk/c7t60060E801663D800000163D800000306d0s2 mpathadm disable path -i 10000000c963ab61 -t 50060e801663d822 -l /dev/rdsk/c7t60060E801663D800000163D800000306d0s2
mpathadm disable path -i 10000000c963ab61 -t 50060e801663d851 -l /dev/rdsk/c7t60060E801663D800000163D800000400d0s2 mpathadm disable path -i 10000000c963ab61 -t 50060e801663d822 -l /dev/rdsk/c7t60060E801663D800000163D800000400d0s2
mpathadm disable path -i 10000000c963ab61 -t 50060e801663d851 -l /dev/rdsk/c7t60060E801663D800000163D800000401d0s2 mpathadm disable path -i 10000000c963ab61 -t 50060e801663d822 -l /dev/rdsk/c7t60060E801663D800000163D800000401d0s2
mpathadm disable path -i 10000000c963ab61 -t 50060e801663d851 -l /dev/rdsk/c7t60060E801663D800000163D800000402d0s2 mpathadm disable path -i 10000000c963ab61 -t 50060e801663d822 -l /dev/rdsk/c7t60060E801663D800000163D800000402d0s2
mpathadm disable path -i 10000000c963ab61 -t 50060e80056f5307 -l /dev/rdsk/c7t60060E80056F530000006F5300000004d0s2 mpathadm disable path -i 10000000c963ab61 -t 50060e80056f5325 -l /dev/rdsk/c7t60060E80056F530000006F5300000004d0s2 | ||||||||||
4.Đặt tên cho phân vùng (volname) | root@poc:/export/home/guds# format Searching for disks...done
AVAILABLE DISK SELECTIONS: 0. c0t5000C500480FAF33d0 <SEAGATE-ST960005SSUN600G-0606-558.91GB> /scsi_vhci/disk@g5000c500480faf33 /dev/chassis/SYS/SASBP/HDD0/disk 1. c0t5000C50047831DD7d0 <SEAGATE-ST960005SSUN600G-0606-558.91GB> /scsi_vhci/disk@g5000c50047831dd7 /dev/chassis/SYS/SASBP/HDD1/disk Specify disk (enter its number): 0 selecting c0t5000C500480FAF33d0 [disk formatted] /dev/dsk/c0t5000C500480FAF33d0s0 is part of active ZFS pool rpool. Please see zpool(1M).
FORMAT MENU: disk - select a disk type - select (define) a disk type partition - select (define) a partition table current - describe the current disk format - format and analyze the disk repair - repair a defective sector label - write label to the disk analyze - surface analysis defect - defect list management backup - search for backup labelsve verify - read and display labels inquiry - show disk ID volname - set 8-character volume name !<cmd> - execute <cmd>, then return quit format> vol Enter 8-character volume name (remember quotes)[""]:"OS" Ready to label disk, continue? y
format> ve
Volume name = < OS> ascii name = <SEAGATE-ST960005SSUN600G-0606-558.91GB> bytes/sector = 512 sectors = 1172123567 accessible sectors = 1172123534 Part Tag Flag First Sector Size Last Sector 0 usr wm 256 558.90GB 1172107150 1 unassigned wm 0 0 0 2 unassigned wm 0 0 0 3 unassigned wm 0 0 0 4 unassigned wm 0 0 0 5 unassigned wm 0 0 0 6 unassigned wm 0 0 0 8 reserved wm 1172107151 8.00MB 1172123534
format> q root@poc:/export/home/guds# format Searching for disks...done | ||||||||||
5.Format |
| ||||||||||
6.Mount | Theo các loại file system | ||||||||||
7.Umount | umount /dev/dsk/c0t2d0s7 umount: /dev/dsk/c0t2d0s7: device is busy
# fuser -u /dev/dsk/c0t2d0s7 /dev/dsk/c0t2d0s7: 1313co(oracle) 1223c(root)
# fuser -k /dev/dsk/c0t2d0s7 /dev/dsk/c0t2d0s7: 1313co 1223c
From <http://www.idevelopment.info/data/Unix/General_UNIX/GENERAL_Troubleshootingthedeviceisbusy.shtml> | ||||||||||
8.Xác định tiến trình đang sử dụng SAN | fuser | ||||||||||
9.Giả lập tải IO |
| ||||||||||
| Read: dd if=/dev/rdsk/c7t60060E80056F530000006F5300000560d0s0 of=/dev/null bs=1024k count=1000000 iostat -xncpzM 3 iostat -xnd 3 | ||||||||||
| Write: dd if=/dev/zero of=/dev/rdsk/c7t60060E80056F530000006F5300000560d0s0 bs=1024kb count=1024*100 & Iostat -xnd 5 | ||||||||||
10.Troubleshooting IO | # uname -a # pagesize # echo ::memstat | mdb -k # df -h # echo | format # zpool list # zfs list # zpool iostat 5 10 # vmstat 5 10 # vmstat -s # sar -rbc 5 10 # sar -d 5 10 | ||||||||||
Monitoring | iostat -xncpzM 3 | ||||||||||
| May 27 03:11:03 dbaviet scsi: [ID 107833 kern.warning] WARNING: /scsi_vhci/ssd@g60060e801036abe0057daeee000001f8 (ssd32): --> Phân vùng 01f8 (s05) May 27 03:11:03 dbaviet Error for Command: write(10) Error Level: Retryable May 27 03:11:03 dbaviet scsi: [ID 107833 kern.notice] Requested Block: 2038930082 Error Block: 2038930082 May 27 03:11:03 dbaviet scsi: [ID 107833 kern.notice] Vendor: HITACHI Serial Number: 9212286201F8 May 27 03:11:03 dbaviet scsi: [ID 107833 kern.notice] Sense Key: Aborted_Command May 27 03:11:03 dbaviet scsi: [ID 107833 kern.notice] ASC: 0x4b (data phase error), ASCQ: 0x0, FRU: 0x0 --> Bị lỗi block, nếu liên tục thì thường DB có vấn đề, còn thi thoảng gặp cảnh báo thì không sao do SAN đã sử dụng > 95% nên có thể sẽ phát sinh | ||||||||||
| May 27 11:52:38 dbaviet /scsi_vhci/ssd@g60060e801663d800000163d800000304 (ssd20): Command failed to complete (3) on path fp0/ssd@w50060e801663d822,4 --> đường đi qua cổng 50060e801663d822 của SAN Director
May 27 11:52:38 dbaviet scsi: [ID 107833 kern.warning] WARNING: /scsi_vhci/ssd@g60060e801663d800000163d800000304 (ssd20): May 27 11:52:38 dbaviet SCSI transport failed: reason 'tran_err': retrying command May 27 11:52:38 dbaviet scsi: [ID 243001 kern.info] /scsi_vhci (scsi_vhci0): May 27 11:52:38 dbaviet /scsi_vhci/ssd@g60060e801663d800000163d800000305 (ssd19): Command failed to complete (3) on path fp0/ssd@w50060e801663d822,5 May 27 11:55:58 dbaviet scsi: [ID 243001 kern.info] /scsi_vhci (scsi_vhci0): May 27 11:55:58 dbaviet /scsi_vhci/ssd@g60060e801663d800000163d800000303 (ssd21): Command failed to complete (3) on path fp0/ssd@w50060e801663d822,3 May 27 11:55:58 dbaviet scsi: [ID 107833 kern.warning] WARNING: /scsi_vhci/ssd@g60060e801663d800000163d800000303 (ssd21): May 27 11:55:58 dbaviet SCSI transport failed: reason 'tran_err': retrying command May 27 11:55:58 dbaviet scsi: [ID 243001 kern.info] /scsi_vhci (scsi_vhci0): May 27 11:55:58 dbaviet /scsi_vhci/ssd@g60060e801663d800000163d800000305 (ssd19): Command failed to complete (3) on path fp0/ssd@w50060e801663d822,5 May 27 11:55:58 dbaviet scsi: [ID 243001 kern.info] /scsi_vhci (scsi_vhci0): May 27 11:55:58 dbaviet /scsi_vhci/ssd@g60060e801663d800000163d800000304 (ssd20): Command failed to complete (3) on path fp0/ssd@w50060e801663d822,4 May 27 11:58:54 dbaviet scsi: [ID 243001 kern.warning] WARNING: /scsi_vhci (scsi_vhci0): May 27 11:58:54 dbaviet /scsi_vhci/ssd@g60060e801663d800000163d800000304 (ssd20): Command Timeout on path fp0/ssd@w50060e801663d822,4 May 27 12:02:18 dbaviet scsi: [ID 243001 kern.info] /scsi_vhci (scsi_vhci0): May 27 12:02:18 dbaviet /scsi_vhci/ssd@g60060e801663d800000163d800000303 (ssd21): Command failed to complete (3) on path fp0/ssd@w50060e801663d822,3 May 27 12:02:18 dbaviet scsi: [ID 243001 kern.info] /scsi_vhci (scsi_vhci0): May 27 12:02:18 dbaviet /scsi_vhci/ssd@g60060e801663d800000163d800000304 (ssd20): Command failed to complete (3) on path fp0/ssd@w50060e801663d822,4 May 27 12:02:18 dbaviet scsi: [ID 107833 kern.warning] WARNING: /scsi_vhci/ssd@g60060e801663d800000163d800000304 (ssd20): May 27 12:02:18 dbaviet SCSI transport failed: reason 'tran_err': retrying command May 27 12:04:42 dbaviet scsi: [ID 243001 kern.info] /scsi_vhci (scsi_vhci0): May 27 12:04:42 dbaviet /scsi_vhci/ssd@g60060e801663d800000163d800000304 (ssd20): Command failed to complete (3) on path fp0/ssd@w50060e801663d822,4 May 27 12:04:42 dbaviet scsi: [ID 243001 kern.info] /scsi_vhci (scsi_vhci0): May 27 12:04:42 dbaviet /scsi_vhci/ssd@g60060e801663d800000163d800000303 (ssd21): Command failed to complete (3) on path fp0/ssd@w50060e801663d822,3 May 27 12:04:42 dbaviet scsi: [ID 243001 kern.info] /scsi_vhci (scsi_vhci0): May 27 12:04:42 dbaviet /scsi_vhci/ssd@g60060e801663d800000163d800000305 (ssd19): Command failed to complete (3) on path fp0/ssd@w50060e801663d822,5 May 27 12:06:05 dbaviet scsi: [ID 243001 kern.warning] WARNING: /scsi_vhci (scsi_vhci0): May 27 12:06:05 dbaviet /scsi_vhci/ssd@g60060e801663d800000163d800000304 (ssd20): Command Timeout on path fp0/ssd@w50060e801663d822,4 May 27 12:06:05 dbaviet scsi: [ID 107833 kern.warning] WARNING: /scsi_vhci/ssd@g60060e801663d800000163d800000304 (ssd20): May 27 12:06:05 dbaviet SCSI transport failed: reason 'timeout': retrying command May 27 12:07:13 dbaviet scsi: [ID 107833 kern.warning] WARNING: /scsi_vhci/ssd@g60060e801036abe0057daeee000001f8 (ssd32): May 27 12:07:13 dbaviet Error for Command: write(10) Error Level: Retryable May 27 12:07:13 dbaviet scsi: [ID 107833 kern.notice] Requested Block: 112772434 Error Block: 112772434 May 27 12:07:13 dbaviet scsi: [ID 107833 kern.notice] Vendor: HITACHI Serial Number: 9212286201F8 May 27 12:07:13 dbaviet scsi: [ID 107833 kern.notice] Sense Key: Aborted_Command May 27 12:07:13 dbaviet scsi: [ID 107833 kern.notice] ASC: 0x4b (data phase error), ASCQ: 0x0, FRU: 0x0 May 27 12:09:23 dbaviet scsi: [ID 243001 kern.info] /scsi_vhci (scsi_vhci0): May 27 12:09:23 dbaviet /scsi_vhci/ssd@g60060e801663d800000163d800000304 (ssd20): Command failed to complete (3) on path fp0/ssd@w50060e801663d822,4 May 27 12:09:23 dbaviet scsi: [ID 107833 kern.warning] WARNING: /scsi_vhci/ssd@g60060e801663d800000163d800000304 (ssd20): May 27 12:09:23 dbaviet SCSI transport failed: reason 'tran_err': retrying command May 27 12:09:23 dbaviet scsi: [ID 243001 kern.info] /scsi_vhci (scsi_vhci0): May 27 12:09:23 dbaviet /scsi_vhci/ssd@g60060e801663d800000163d800000303 (ssd21): Command failed to complete (3) on path fp0/ssd@w50060e801663d822,3 May 27 12:15:29 dbaviet scsi: [ID 243001 kern.info] /scsi_vhci (scsi_vhci0): May 27 12:15:29 dbaviet /scsi_vhci/ssd@g60060e801663d800000163d800000304 (ssd20): Command failed to complete (3) on path fp0/ssd@w50060e801663d822,4 May 27 12:15:29 dbaviet scsi: [ID 243001 kern.info] /scsi_vhci (scsi_vhci0): May 27 12:15:29 dbaviet /scsi_vhci/ssd@g60060e801663d800000163d800000305 (ssd19): Command failed to complete (3) on path fp0/ssd@w50060e801663d822,5
--> Phân vùng 0305 đi qau cổng trên SAN Director 50060e801663d822 bị fail, nếu nhiều là có vấn đề, UD timeout (trường device Address trong luxadm display <path>) grep "Command failed to complete" messages |more | ||||||||||
| oracle@dbaviet$ grep 10000000c963ab61 messages May 27 03:12:25 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric --> 1 port trên cạc HBA Card1 (fcinfo hba-port) May 27 03:12:26 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 27 03:23:27 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 27 03:23:29 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 27 06:32:55 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 27 07:09:07 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 27 07:26:40 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 27 07:42:58 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 27 08:26:51 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 27 08:39:34 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 28 03:52:01 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 28 03:52:03 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 28 05:02:20 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 28 05:02:22 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 29 03:07:34 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 29 03:07:35 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 29 04:28:01 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 29 04:28:02 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 29 17:10:44 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 29 17:10:46 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 30 01:11:49 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 reappeared in fabric May 30 01:46:26 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 30 01:46:28 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 30 04:15:11 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 30 04:15:13 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 30 04:53:13 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 30 04:53:14 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 30 21:18:09 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 30 21:18:11 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 30 21:20:02 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 reappeared in fabric May 30 21:25:00 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 30 21:25:02 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 30 23:10:50 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 31 00:29:22 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 31 00:29:48 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 31 01:02:29 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 31 01:03:04 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 31 01:30:49 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 31 01:30:50 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 31 02:18:23 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 31 02:18:24 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 31 02:48:44 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 31 02:48:45 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 reappeared in fabric May 31 02:50:46 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 31 03:20:48 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 31 03:20:49 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 31 05:22:06 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 31 05:22:08 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 reappeared in fabric May 31 08:06:34 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 31 08:14:52 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric May 31 08:14:54 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric Jun 1 03:12:00 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric Jun 1 03:12:26 dbaviet fctl: [ID 517869 kern.warning] WARNING: fp(4)::N_x Port with D_ID=18300, PWWN=10000000c963ab61 disappeared from fabric --> | ||||||||||
|
*****
- Server DBAViet iện tại băng thông sẽ đạt 250MB/s theo lý thuyết, do các card HBA đang kết nối đên Bus B Controller1. Nên tốc độc restore trên mobicard đặt tốc độ 150Mb ( write vsp) + 30MB ( read sata) là gần đúng lý thuyết. Ngoài ra việc đọc trên phân vùng SATA chậm cũng ảnh hưởng đến việc write trên VSP nên kết quả report bởi lệnh iostat là bình thường.
- Kiểm tra hoạt động trên VSP thời điểm mobicard restore, các chỉ số performance đều ở mức bình thường của storage: cache write pending 5%, disk busy 20%, iops 300.
- Để đạt được băng thông cao hơn cần chuyển một card HBA qua Slot5 hoặc slot1 của server. Khi chuyển qua các slot1 ( Bus B, controller ) sẻ ảnh hưởng đến băng thông đường mạng, khi chuyển qua slot5 sẻ ảnh hưởng đến truy nhập ổ cứng internal. Nên để tăng băng thông có thể chọn option lắp vào slot5 ( Bus A) để tăng băng thông đến storage.
Các thông tin tham khảo:
- Vị trí các slot đã sử dụng trên e2900
- Tốc độ các Bus system trong hệ thống:
Link: http://docs.oracle.com/cd/E19095-01/sfe2900.srvr/817-5233-10/troubleshooting.html
* KHOÁ HỌC ORACLE DATABASE A-Z ENTERPRISE trực tiếp từ tôi giúp bạn bước đầu trở thành những chuyên gia DBA, đủ kinh nghiệm đi thi chứng chỉ OA/OCP, đặc biệt là rất nhiều kinh nghiệm, bí kíp thực chiến trên các hệ thống Core tại VN chỉ sau 1 khoá học.
* CÁCH ĐĂNG KÝ: Gõ (.) hoặc để lại số điện thoại hoặc inbox https://m.me/tranvanbinh.vn hoặc Hotline/Zalo 090.29.12.888
* Chi tiết tham khảo:
https://bit.ly/oaz_w
=============================
KẾT NỐI VỚI CHUYÊN GIA TRẦN VĂN BÌNH:
📧 Mail: binhoracle@gmail.com
☎️ Mobile: 0902912888
⚡️ Skype: tranbinh48ca
👨 Facebook: https://www.facebook.com/BinhOracleMaster
👨 Inbox Messenger: https://m.me/101036604657441 (profile)
👨 Fanpage: https://www.facebook.com/tranvanbinh.vn
👨 Inbox Fanpage: https://m.me/tranvanbinh.vn
👨👩 Group FB: https://www.facebook.com/groups/DBAVietNam
👨 Website: https://www.tranvanbinh.vn
👨 Blogger: https://tranvanbinhmaster.blogspot.com
🎬 Youtube: http://bit.ly/ytb_binhoraclemaster
👨 Tiktok: https://www.tiktok.com/@binhoraclemaster?lang=vi
👨 Linkin: https://www.linkedin.com/in/binhoracle
👨 Twitter: https://twitter.com/binhoracle
👨 Địa chỉ: Tòa nhà Sun Square - 21 Lê Đức Thọ - Phường Mỹ Đình 1 - Quận Nam Từ Liêm - TP.Hà Nội
=============================
học oracle database, Tự học Oracle, Tài liệu Oracle 12c tiếng Việt, Hướng dẫn sử dụng Oracle Database, Oracle SQL cơ bản, Oracle SQL là gì, Khóa học Oracle Hà Nội, Học chứng chỉ Oracle ở đầu, Khóa học Oracle online,khóa học pl/sql, học dba, học dba ở việt nam, khóa học dba, khóa học dba sql, tài liệu học dba oracle, Khóa học Oracle online, học oracle sql, học oracle ở đâu tphcm, học oracle bắt đầu từ đâu, học oracle ở hà nội, oracle database tutorial, oracle database 12c, oracle database là gì, oracle database 11g, oracle download, oracle database 19c, oracle dba tutorial, oracle tunning, sql tunning , oracle 12c, oracle multitenant, Container Databases (CDB), Pluggable Databases (PDB), oracle cloud, oracle security, oracle fga, audit_trail, oracle dataguard, oracle goldengate, mview, oracle exadata, oracle oca, oracle ocp, oracle ocm , oracle weblogic, middleware, hoc solaris, hoc linux, hoc aix, unix, securecrt, xshell, mobaxterm, putty