AIX上裸设备WARNING: Oracle recommends creating new datafiles on devices with zero offset.

 

AIX上裸设备WARNING: Oracle recommends creating new datafiles on devices with zero offset.

 

在ITPUB上看到有人提问： 创建lv的时候 mklv -T O,怎么还在alert log里看到warning  : Oracle recommends creating new datafiles on devices with zero offset. 下面红字是原贴的内容： 环境              RAC(oracle 10G )+AIX+HA+裸设备 操作 追加数据文件 扩充表空间               #mklv -y'rkk_data02' -T O -w'n' -s'n' -r'n' -t raw dzz 240 hdiskpower3 rkk_data02                rkk_data02              # pwd 权限在2个节点都改过 SQL> alter tablespace DATA add datafile '/dev/rrk_data02' size 25000m; Tablespace altered. # tail -f alert_kk1.log Wed Feb 16 6:30:12 2011 alter tablespace DATA01 add datafile '/dev/rrkk_data02' size 25000m Wed Feb 16 6:30:12 2011 WARNING: You are creating datafile /dev/rrkk_data02. WARNING: Oracle recommends creating new datafiles on devices with zero offset. The command "/usr/sbin/mklv -y LVname -T O -w n -s n -r n VGname NumPPs" can be used. Please contact Oracle customer support for more details. Wed Feb 16 6:35:12 2011 WARNING: You are creating/reusing datafile /dev/rrkk_data02. WARNING: Oracle recommends creating new datafiles on devices with zero offset. The command "/usr/sbin/mklv -y LVname -T O -w n -s n -r n VGname NumPPs" can be used. Please contact Oracle customer support for more details. Completed: alter tablespace DATA01 add datafile '/dev/rrkk_data02' size 25000m 其实揪其原因，还是文档没看到位. 在Oracle的官方文档里，创建lv之前，创建vg的命令是这样写的： To create a volume group, enter a command similar to the following, or use SMIT (smit mkvg): # /usr/sbin/mkvg -y VGname-B -s PPsize-V majornum-n \ -CPhysicalVolumes 可以看到，有-B参数，也就是要创建Big VG，如果不这样做会怎么样呢？下面引用AIX中mklv命令参数-T O的说明： For big vg format volume groups, the -T O option indicates that the logical volume control block will not occupy the first block of the logical volume.Therefore, the space is available for application data. Applications can identify this type of logical volume with the IOC INFO ioctl. The logical volume has a device subtype of DS_LVZ. A logical volume created without this option has a device subtype of DS_LV. This option is ignored for old and scalable vg format volume groups. 说的很清楚了，这个-T O参数只对big vg起作用，对于old 和scalable vg参数会被忽略。 显然，光mklv加-T O是不够的，还要在创建VG的时候是Big VG。