oracle 添加裸设备lv,AIX 上创建裸设备lv出现的问题

昨天在客户那巡检时,发现日志中出现以下的警告:

Fri Apr 17 06:03:11 2009

WARNING: You are creating/reusing datafile /dev/ritms2_sysaux_1g.

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.

WARNING: You are creating/reusing datafile /dev/ritms2_sysaux_1g.

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.

看来创建lv时,没加-T 0 参数导致有4k的头部偏移,很可能会出现坏块,而出现ORA-01578错误

可以用以下方法进行检查

1.   lslv -L  itms2_sysaux_1g

2.   dbfsize /dev/ritms2_sysaux_1g

解决方法;

1.修改VG为scarable vg,并且重建裸设备,重建库,数据重倒

2.修改VG为scarable vg,用以下命令把lv的整个数据向前移动4K：

dd if=/dev/lvname f=/dev/lvname  seek=0 skip=1 bs=4k