Environment first: AIx 7.1 Oracle/ASM 11.2.0.3 Single Instance
In this test environment, the flashdg size in ASM needs to be increased to 35 GB (currently 10 Gb). diskgroup is created based on the LV divided in RAW mode in VG. Because only the AIX administrator is notified in the test environment, the AIX administrator increases the number of PP of fsflashdglv through Smit LV. After adding the number, you can see that the LV is increased, but the flashdg1 is not increased. The entire process is described below. ----- This is an unconventional solution. The conventional solution is to increase the flashdg size by adding disk after creating a LV.
After the system administrator adds the fsflashdglv size: [email protected]:/. root> lsvg-l datavgdatavg: LV name type lps pps pvs lv state Mount pointfsoraapplv jfs2 280 280 1 open/syncd/oraapploglv00 jfs2log 1 1 1 Open/syncd N/afsdatadglv raw 160 160 1 Open/syncd N/afsdatadg1raw 240 240 2 open/syncd N/afsflashdglv raw 280 280 2 open/syncd N/
[Email protected]: /home/GRID> asmcmd lsdgstate type rebal sector block au total_mb free_mb quota offline line_disks voting_files namemounted extern n 512 4096 1048576 51200 0 15238 0 n datadg/mounted extern n 15238 512 4096 1048576 0 4057 0 n flashdg1/[email protected]: /home/GRID>
It is found that flashdg does not increase.
Use Oracle's kfed tool to obtain asmdisk information: [email protected]: /home/GRID> kfod disk = all your disk size path user group ========================== ========================================================== ==================== 1: 30720 Mbps/dev/rfsdatadg1lv grid asmadmin 2: 20480 Mbps/dev/rfsdatadglv grid asmadmin 3: 35840 MB/dev/rfsflashdglv grid asmadmin restart oracle_sid ORACLE_HOME ==================== ========================================================== ===========+ ASM/oraapp/GRID/gridhome
The LV size is already 35 GB. Check disk header block: [email protected]:/home/GRID> kfed read/dev/rfsflashdglv Aun = 0kfbh. endian: 0; 0x000: 0x00kfbh. hard: 130; 0x001: 0x82kfbh. type: 1; 0x002: kfbtyp_diskheadkfbh.datfmt: 1; 0x003: 0x01kfbh. block. BLK: 0; 0x004: BLK = 0kfbh. block. OBJ: 2147483648; 0x008: disk = 0kfbh. check: 3587268014; 0x00c: 0xd5d15daekfbh. FCN. base: 0; 0x010: 0x00000000kfbh. FCN. wrap: 0; 0x014: 0x00000000kfbh. spare1: 0; 0x018: 0x00000000kfbh. spare2: 0; 0x01c: 0x00000000kfdhdb. driver. provstr: orcldisk; 0x000: length = 8kfdhdb. driver. reserved [0]: 0; 0x008: 0x000000001_kfdhdb. driver. reserved [1]: 0; 0x00c: 0x000000000000kfdhdb. driver. reserved [2]: 0; 0x010: 0x000000001_kfdhdb. driver. reserved [3]: 0; 0x014: 0x000000001_kfdhdb. driver. reserved [4]: 0; 0x018: 0x000000001_kfdhdb. driver. reserved [5]: 0; 0x01c: 0x000000001_kfdhdb. compat: 168820736; 0x020: 0x0a100000kfdhdb. dsknum: 0; 0x024: 0x0000kfdhdb. grptyp: 1; 0x026: kfdgtp_externalkfdhdb.hdrsts: 3; 0x027: large: flashdg00000000; 0x028: length = 13kfdhdb. kgname: flashdg1; 0x048: length = 8kfdhdb. fgname: flashdg00000000; 0x068: length = 13kfdhdb. capname:; 0x088: length = 0kfdhdb. crestmp. hi: 33006034; 0x0a8: hour = 0x12 days = 0xe mnth = 0x8 year = 0x7dekfdhdb. crestmp. lo: 3537131520; 0x0ac: USEC = 0x0 MSEC = 0x116 secs = 0x2d mins = 0x34kfdhdb. mntstmp. hi: 33006410; 0x0b0: hour = 0xa days = 0x1a mnth = 0x8 year = 0x7dekfdhdb. mntstmp. lo: 1403252736; 0x0b4: USEC = 0x0 MSEC = 0xfc secs = 0x3a mins = 0x14kfdhdb. secsize: 512; 0x0b8: 0x0200kfdhdb. blksize: 4096; 0x0ba: 0x1000kfdhdb. ausize: 1048576; 0x0bc: 0x00100000kfdhdb. mfact: 113792; 0x0c0: 0x0001bc80kfdhdb. dsksize: 10240; 0x0c4: 0x00002800kfdhdb. pmcnt: 2; 0x0c8: 0x00000002kfdhdb. fstlocn: 1; 0x0cc: 0x00000001kfdhdb. altlocn: 2; 0x0d0: 0x00000002kfdhdb. f1b1locn: 2; 0x0d4: 0x00000002kfdhdb. redomirrors [0]: 0; 0x0d8: 0x0000kfdhdb. redomirrors [1]: 0; 0x0da: 0x0000kfdhdb. redomirrors [2]: 0; 0x0dc: 0x0000kfdhdb. redomirrors [3]: 0; 0x0de: 0x0000kfdhdb. dbcompat: 168820736; 0x0e0: 0x0a100000kfdhdb. kgstmp. hi: 33006034; 0x0e4: hour = 0x12 days = 0xe mnth = 0x8 year = 0x7dekfdhdb. kgstmp. lo: 3536962560; 0x0e8: USEC = 0x0 MSEC = 0x71 secs = 0x2d mins = 0x34kfdhdb. vfstart: 0; 0x0ec: 0x00000000kfdhdb. vfend: 0; 0x0f0: 0x00000000kfdhdb. spfile: 0; 0x0f4: 0x00000000kfdhdb. spfflg: 0; 0x0f8: 0x00001_kfdhdb. ub4spare [0]: 0; 0x0fc: 0x000000000000kfdhdb. ub4spare [1]: 0; 0x100: 0x000000000000kfdhdb. ub4spare [2]: 0; 0x104: 0x000000000000kfdhdb. ub4spare [3]: 0; 0x108: 0x000000000000kfdhdb. ub4spare [4]: 0; 0x10c: 0x000000000000kfdhdb. ub4spare [5]: 0; 0x110: 0x000000000000kfdhdb. ub4spare [6]: 0; 0x114: 0x000000000000kfdhdb. ub4spare [7]: 0; 0x118: 0x000000000000kfdhdb. ub4spare [8]: 0; 0x11c: 0x000000000000kfdhdb. ub4spare [9]: 0; 0x120: 0x000000000000kfdhdb. ub4spare [10]: 0; 0x124: 0x000000000000kfdhdb. ub4spare [11]: 0; 0x128: 0x000000000000kfdhdb. ub4spare [12]: 0; 0x12c: 0x000000000000kfdhdb. ub4spare [13]: 0; 0x130: 0x000000000000kfdhdb. ub4spare [14]: 0; 0x134: 0x000000000000kfdhdb. ub4spare [15]: 0; 0x138: 0x000000000000kfdhdb. ub4spare [16]: 0; 0x13c: 0x000000001_kfdhdb. ub4spare [17]: 0; 0x140: 0x000000000000kfdhdb. ub4spare [18]: 0; 0x144: 0x000000000000kfdhdb. ub4spare [19]: 0; 0x148: 0x000000000000kfdhdb. ub4spare [20]: 0; 0x14c: 0x000000000000kfdhdb. ub4spare [21]: 0; 0x150: 0x000000000000kfdhdb. ub4spare [22]: 0; 0x154: 0x000000000000kfdhdb. ub4spare [23]: 0; 0x158: 0x000000000000kfdhdb. ub4spare [24]: 0; 0x15c: 0x000000000000kfdhdb. ub4spare [25]: 0; 0x160: 0x000000000000kfdhdb. ub4spare [26]: 0; 0x164: 0x000000000000kfdhdb. ub4spare [27]: 0; 0x168: 0x000000000000kfdhdb. ub4spare [28]: 0; 0x16c: 0x000000000000kfdhdb. ub4spare [29]: 0; 0x170: 0x000000000000kfdhdb. ub4spare [30]: 0; 0X174: 0x000000000000kfdhdb. ub4spare [31]: 0; 0x178: 0x000000000000kfdhdb. ub4spare [32]: 0; 0x17c: 0x000000000000kfdhdb. ub4spare [33]: 0; 0x180: 0x000000000000kfdhdb. ub4spare [34]: 0; 0x184: 0x000000000000kfdhdb. ub4spare [35]: 0; 0x188: 0x000000000000kfdhdb. ub4spare [36]: 0; 0x18c: 0x000000000000kfdhdb. ub4spare [37]: 0; 0x190: 0x000000000000kfdhdb. ub4spare [38]: 0; 0x194: 0x000000000000kfdhdb. ub4spare [39]: 0; 0x198: 0x000000000000kfdhdb. ub4spare [40]: 0; 0x19c: 0x000000000000kfdhdb. ub4spare [41]: 0; 0x1a0: 0x000000000000kfdhdb. ub4spare [42]: 0; 0x1a4: 0x000000000000kfdhdb. ub4spare [43]: 0; 0x1a8: 0x000000000000kfdhdb. ub4spare [44]: 0; 0x1ac: 0x000000000000kfdhdb. ub4spare [45]: 0; 0x1b0: 0x000000000000kfdhdb. ub4spare [46]: 0; 0x1b4: 0x000000001_kfdhdb. ub4spare [47]: 0; 0x1b8: 0x000000000000kfdhdb. ub4spare [48]: 0; 0x1bc: 0x000000000000kfdhdb. ub4spare [49]: 0; 0x1c0: 0x000000000000kfdhdb. ub4spare [50]: 0; 0x1c4: 0x000000000000kfdhdb. ub4spare [51]: 0; 0x1c8: 0x000000001_kfdhdb. ub4spare [52]: 0; 0x1cc: 0x000000000000kfdhdb. ub4spare [53]: 0; 0x1d0: 0x000000000000kfdhdb. ACDB. ABA. SEQ: 0; 0x1d4: 0x00000000kfdhdb. ACDB. ABA. BLK: 0; 0x1d8: 0x00000000kfdhdb. ACDB. ents: 0; 0x1dc: 0x0000kfdhdb. ACDB. ub2spare: 0; 0x1de: 0x0000 [email protected]:/home/GRID>
The disk header block shows that the LV In the ASM diskgroup is indeed 10 Gb, not 35 GB. Finally, do you still have other operations on the grid end?
Asked a circle of friends, did not ask, and finally asked a big colleague, he told me to try to resize disk. It is a test environment. Try SQL> alter diskgroup flashdg1 resize disk flashdg00000000 size 35840 m;
Diskgroup altered.
It looks okay. Hurry up and see [email protected]: /home/GRID> asmcmd lsdgstate type rebal sector block au total_mb free_mb quota offline line_disks voting_files namemounted extern n 512 4096 1048576 51200 0 15238 0 n datadg/mounted extern n 15238 512 4096 1048576 0 29657 0 n flashdg1/[email protected]: /home/GRID>
OK. At this time, flashdg1 recognizes 35 GB.
Increase the size of the ASM diskgroup by adding the LV In the AIX environment-unconventional method
