Environment first: AIX7.1OracleASM11.2.0.3 the size of flashdg in ASM needs to be increased to 35 GB in the current test environment ), diskgroup is created based on the lv divided in raw mode in vg. Since the test environment only notifies the AIX administrator, the AIX administrator increases the number of pp of fsflashdglv through smitlv.
First, let's explain the environment: AIX 7.1 Oracle/ASM 11.2.0.3. In this test environment, we need to increase the flashdg size in ASM to 35 GB (currently 10 Gb ), diskgroup is created based on the lv divided in raw mode in vg. Because the test environment only notifies the AIX administrator, the AIX administrator increases the number of pp of fsflashdglv through smit lv.
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: root @ seven1 :/. 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/
Grid @ seven1: /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/grid @ seven1: /home/grid>
It is found that flashdg does not increase.
Use the kfed tool of Oracle to obtain the information of asmdisk: grid @ seven1: /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: grid @ seven1:/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: 0x0000grid @ seven1:/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 grid @ seven1: /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/grid @ seven1: /home/grid>
OK. At this time, flashdg1 recognizes 35 GB.
