问题现象：
在AIX下新建LV，然后在LV上建表空间，出现WARNING（Oracle recommends creating new datafiles on devices with zero offset）
alter tablespace ZJ_DATA add datafile '/dev/rdata40_disk' size 2500M
Wed Apr 27 22:45:36 2011
WARNING: You are creating datafile /dev/rdata41_disk.
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.
通过mklv -T O -y data40_disk oradatavg 1重建如上表空间后上述警告消失，运行一段时间数据库完全正常，可见数据文件已经正常写入该DATAFILE。
但无意中一次lslv对比了数据库上线时和刚刚建立的两个lv文件，发现在TYPE、DEVICESUBTYPE、RELOCATABLE、MIRROR WRITE CONSISTENCY、EACH LP COPY ON A SEPARATE PV
方面存在区别，详见如下。
$ lslv data40_disk
LOGICAL VOLUME: data40_disk VOLUME GROUP: oradatavg
LV IDENTIFIER: 00c164fe00004c0000000110a1021713.66 PERMISSION: read/write
VG STATE: active/complete LV STATE: opened/syncd
TYPE: jfs WRITE VERIFY: off
MAX LPs: 512 PP SIZE: 256 megabyte(s)
COPIES: 1 SCHED POLICY: parallel
LPs: 10 PPs: 10
STALE PPs: 0 BB POLICY: relocatable
INTER-POLICY: minimum RELOCATABLE: yes
INTRA-POLICY: middle UPPER BOUND: 16
MOUNT POINT: N/A LABEL: None
MIRROR WRITE CONSISTENCY: on/ACTIVE
EACH LP COPY ON A SEPARATE PV ?: yes
Serialize IO ?: NO
DEVICESUBTYPE : DS_LVZ
$ lslv data_disk
LOGICAL VOLUME: data_disk VOLUME GROUP: oradatavg
LV IDENTIFIER: 00c164fe00004c0000000110a1021713.14 PERMISSION: read/write
VG STATE: active/complete LV STATE: closed/syncd
TYPE: raw WRITE VERIFY: off
MAX LPs: 512 PP SIZE: 256 megabyte(s)
COPIES: 1 SCHED POLICY: parallel
LPs: 4 PPs: 4
STALE PPs: 0 BB POLICY: relocatable
INTER-POLICY: minimum RELOCATABLE: no
INTRA-POLICY: middle UPPER BOUND: 16
MOUNT POINT: N/A LABEL: None
MIRROR WRITE CONSISTENCY: off
EACH LP COPY ON A SEPARATE PV ?: no
Serialize IO ?: NO
为了鉴证MKLV命令的默认参数，我们来继续几个做测试
方法一：mklv带有 -T O参数，但是不指定TYPE(-t) ，新建的lv带DEVICESUBTYPE属性，且TYPE:jfs
p550a:/home/oracle/dba#mklv -T O -y data40_disk oradatavg 1
data40_disk
p550a:/home/oracle/dba#lslv data40_disk
LOGICAL VOLUME: data40_disk VOLUME GROUP: oradatavg
LV IDENTIFIER: 000037750000d60000000112749c9dbb.173 PERMISSION: read/write
VG STATE: active/complete LV STATE: closed/syncd
TYPE: jfs WRITE VERIFY: off
MAX LPs: 512 PP SIZE: 512 megabyte(s)
COPIES: 1 SCHED POLICY: parallel
LPs: 1 PPs: 1
STALE PPs: 0 BB POLICY: relocatable
INTER-POLICY: minimum RELOCATABLE: yes
INTRA-POLICY: middle UPPER BOUND: 32
MOUNT POINT: N/A LABEL: None
MIRROR WRITE CONSISTENCY: on/ACTIVE
EACH LP COPY ON A SEPARATE PV ?: yes
Serialize IO ?: NO
DEVICESUBTYPE : DS_LVZ
方法二：mklv带有 -T O参数，指定TYPE(-t 'raw') ，通过lslv可以看出，新建的lv带DEVICESUBTYPE属性，且TYPE:raw
p550a:/home/oracle/dba#mklv -T O -t 'raw' -y data41_disk oradatavg 1
data41_disk
p550a:/home/oracle/dba#lslv data41_disk
LOGICAL VOLUME: data41_disk VOLUME GROUP: oradatavg
LV IDENTIFIER: 000037750000d60000000112749c9dbb.174 PERMISSION: read/write
VG STATE: active/complete LV STATE: closed/syncd
TYPE: raw WRITE VERIFY: off
MAX LPs: 512 PP SIZE: 512 megabyte(s)
COPIES: 1 SCHED POLICY: parallel
LPs: 1 PPs: 1
STALE PPs: 0 BB POLICY: relocatable
INTER-POLICY: minimum RELOCATABLE: yes
INTRA-POLICY: middle UPPER BOUND: 32
MOUNT POINT: N/A LABEL: None
MIRROR WRITE CONSISTENCY: on/ACTIVE
EACH LP COPY ON A SEPARATE PV ?: yes
Serialize IO ?: NO
DEVICESUBTYPE : DS_LVZ
方法三：通过smitlv，指定TYPE(-t 'raw')建lv ，通过lslv可以看出，新建的lv不带DEVICESUBTYPE属性，且TYPE:raw
p550a:/home/oracle/dba#smit lv
添加逻辑卷
在输入字段中输入或选择值。
当完成所有希望的更改之后，按 Enter 键。
[输入字段]
逻辑卷名称 [data42_disk]
* 卷组名称 oradatavg
* 逻辑分区的数量 [1] #
物理卷名 [] +
逻辑卷类型 [raw] +
物理卷位置 中间 +
物理卷范围 最小 +
用于分配的 [] #
物理卷最大数量
每个逻辑分区的副本数量 1 +
要一致性镜像化写入吗? 主动 +
要将每个逻辑分区副本分配 是 +
到一个单独的物理卷吗？
要在重新组织的过程中 是 +
重新分配物理卷吗？
逻辑卷标号 []
逻辑分区的最大数量 [512] #
要启用坏块重定位吗？ 是 +
读取/写入的“规划策略” 并行 +
逻辑分区副本
要启用写入验证吗？ 否 +
包含分配映射的文件 []
组合分割区大小？ [未分割] +
序列化 IO？ 否
p550a:/home/oracle/dba#lslv data42_disk
LOGICAL VOLUME: data42_disk VOLUME GROUP: oradatavg
LV IDENTIFIER: 000037750000d60000000112749c9dbb.175 PERMISSION: read/write
VG STATE: active/complete LV STATE: closed/syncd
TYPE: raw WRITE VERIFY: off
MAX LPs: 512 PP SIZE: 512 megabyte(s)
COPIES: 1 SCHED POLICY: parallel
LPs: 1 PPs: 1
STALE PPs: 0 BB POLICY: relocatable
INTER-POLICY: minimum RELOCATABLE: yes
INTRA-POLICY: middle UPPER BOUND: 32
MOUNT POINT: N/A LABEL: None
MIRROR WRITE CONSISTENCY: on/ACTIVE
EACH LP COPY ON A SEPARATE PV ?: yes
Serialize IO ?: NO
方法四：mklv不带 -T O参数，但指定TYPE(-t 'raw') ，通过lslv可以看出，新建的lv不带DEVICESUBTYPE属性，且RELOCATABLE: yes
p550a:/#mklv -t 'raw' -y data43_disk oradatavg 1
data43_disk
p550a:/#lslv data43_disk
LOGICAL VOLUME: data43_disk VOLUME GROUP: oradatavg
LV IDENTIFIER: 000037750000d60000000112749c9dbb.176 PERMISSION: read/write
VG STATE: active/complete LV STATE: closed/syncd
TYPE: raw WRITE VERIFY: off
MAX LPs: 512 PP SIZE: 512 megabyte(s)
COPIES: 1 SCHED POLICY: parallel
LPs: 1 PPs: 1
STALE PPs: 0 BB POLICY: relocatable
INTER-POLICY: minimum RELOCATABLE: yes
INTRA-POLICY: middle UPPER BOUND: 32
MOUNT POINT: N/A LABEL: None
MIRROR WRITE CONSISTENCY: on/ACTIVE
EACH LP COPY ON A SEPARATE PV ?: yes
Serialize IO ?: NO
综合以上测试可以得出：
1、mklv默认的TYPE是jfs
2、默认建立普通类型的lv，LV类型是DS_LV，这种类型的LV，在lslv的命令中没有任何SUBTYPE类型说明（不带DEVICESUBTYPE : DS_LVZ）。
©著作权归作者所有：来自51CTO博客作者zylhsy的原创作品，如需转载，请注明出处，否则将追究法律责任
职场AIX休闲ORACLE数据库