本帖最后由 paulyi 于 2014-2-10 13:59 编辑

AIX FOR ORACLE 日志中出现以下的警告:

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