Oracle 11g RAC 警告处理

问题．WARNING: You are creating/reusing datafile /dev/rcv_sysaux_800m.
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/rcv_sysaux_800m.
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.
一． 分析
数据库创建时，裸设备未使用-T O参数，一般情况下，AIX 的逻辑卷前 4k 用于存储 control block (LVCB)，在 Oracle 9iR2 之前，Oracle 软件自动跳过这 4k 而不用。这带来了一个潜在的问题，当 Oracle 的 db_block_size 大于 4k 的时候，一个 Block 可能跨在两个 PV/LUN/磁盘上。这样当系统崩溃的时候，很有可能造成大量的 IO 不完整，一个 PV 上 IO 写入，另一边可能未完成，启动 Oracle 的时候将会看到 ORA-1578 错误，这几乎是致命的。
二． 解决方法
Raw lv 列表
Vg lv
Oraclevg cp_crs1024m
cp_vote1024m
cp_system_1024m
cp_pwdfile_100m
cp_sysaux_800m
cp_undo1_4096m
cp_undo2_4096m
cp_temp_4096m
cp_example_800m
cp_users_800m
cp_redo1_1_500m
cp_redo1_2_500m
cp_redo1_3_500m
cp_redo1_4_500m
cp_redo1_5_500m
cp_redo1_6_500m
cp_redo2_1_500m
cp_redo2_2_500m
cp_redo2_3_500m
cp_redo2_4_500m
cp_redo2_5_500m
cp_redo2_6_500m
cp_ctl1_110m
cp_ctl2_110m
cp_ctl3_110m
cp_spfile_110m
cv_system_1024m
cv_pwdfile_100m
cv_sysaux_800m
cv_undo1_4096m
cv_undo2_4096m
cv_temp_4096m
cv_example_800m
cv_users_800m
cv_redo1_1_500m
cv_redo1_2_500m
cv_redo1_3_500m
cv_redo1_4_500m
cv_redo1_5_500m
cv_redo1_6_500m
cv_redo2_1_500m
cv_redo2_2_500m
cv_redo2_3_500m
cv_redo2_4_500m
cv_redo2_5_500m
cv_redo2_6_500m
cv_ctl1_110m
cv_ctl2_110m
cv_ctl3_110m
cv_spfile_110m
Cvpovg cv_pobase
cv_pobase_indx
cv_poplan
cv_poplan_indx
cv_poorder
cv_poorder_indx
cv_posys
cv_posys_indx
cv_potemp
cv_potemp_indx








方案A：
1. 修改VG为scarable vg
#smit chvg

2. 用以下命令把lv的整个数据向前移动4K：dd if=/dev/lvname of=/dev/lvname seek=0 skip=1 bs=4k
dd if=/dev/rc p_crs1024m of=/dev/rc p_crs1024m seek=0 skip=1 bs=4k
dd if=/dev/rc p_vote1024m of=/dev/rc p_vote1024m seek=0 skip=1 bs=4k
dd if=/dev/rc p_system_1024m of=/dev/rc p_system_1024m seek=0 skip=1 bs=4k
dd if=/dev/rc p_pwdfile_100m of=/dev/rc p_pwdfile_100m seek=0 skip=1 bs=4k
dd if=/dev/rc p_sysaux_800m of=/dev/rc p_sysaux_800m seek=0 skip=1 bs=4k
dd if=/dev/rc p_undo1_4096m of=/dev/rc p_undo1_4096m seek=0 skip=1 bs=4k
dd if=/dev/rc p_undo2_4096m of=/dev/rc p_undo2_4096m seek=0 skip=1 bs=4k
dd if=/dev/rc p_temp_4096m of=/dev/rc p_temp_4096m seek=0 skip=1 bs=4k
dd if=/dev/rc p_example_800m of=/dev/rc p_example_800m seek=0 skip=1 bs=4k
dd if=/dev/rc p_users_800m of=/dev/rc p_users_800m seek=0 skip=1 bs=4k
dd if=/dev/rc p_redo1_1_500m of=/dev/rc p_redo1_1_500m seek=0 skip=1 bs=4k
dd if=/dev/rc p_redo1_2_500m of=/dev/rc p_redo1_2_500m seek=0 skip=1 bs=4k
dd if=/dev/rc p_redo1_3_500m of=/dev/rc p_redo1_3_500m seek=0 skip=1 bs=4k
dd if=/dev/rc p_redo1_4_500m of=/dev/rc p_redo1_4_500m seek=0 skip=1 bs=4k
dd if=/dev/rc p_redo1_5_500m of=/dev/rc p_redo1_5_500m seek=0 skip=1 bs=4k
dd if=/dev/rc p_redo1_6_500m of=/dev/rc p_redo1_6_500m seek=0 skip=1 bs=4k
dd if=/dev/rc p_redo2_1_500m of=/dev/rc p_redo2_1_500m seek=0 skip=1 bs=4k
dd if=/dev/rc p_redo2_2_500m of=/dev/rc p_redo2_2_500m seek=0 skip=1 bs=4k
dd if=/dev/rc p_redo2_3_500m of=/dev/rc p_redo2_3_500m seek=0 skip=1 bs=4k
dd if=/dev/rc p_redo2_4_500m of=/dev/rc p_redo2_4_500m seek=0 skip=1 bs=4k
dd if=/dev/rc p_redo2_5_500m of=/dev/rc p_redo2_5_500m seek=0 skip=1 bs=4k
dd if=/dev/rc p_redo2_6_500m of=/dev/rc p_redo2_6_500m seek=0 skip=1 bs=4k
dd if=/dev/rc p_ctl1_110m of=/dev/rc p_ctl1_110m seek=0 skip=1 bs=4k
dd if=/dev/rc p_ctl2_110m of=/dev/rc p_ctl2_110m seek=0 skip=1 bs=4k
dd if=/dev/rc p_ctl3_110m of=/dev/rc p_ctl3_110m seek=0 skip=1 bs=4k
dd if=/dev/rc p_spfile_110m of=/dev/rc p_spfile_110m seek=0 skip=1 bs=4k
dd if=/dev/rc v_system_1024m of=/dev/rc v_system_1024m seek=0 skip=1 bs=4k
dd if=/dev/rc v_pwdfile_100m of=/dev/rc v_pwdfile_100m seek=0 skip=1 bs=4k
dd if=/dev/rc v_sysaux_800m of=/dev/rc v_sysaux_800m seek=0 skip=1 bs=4k
dd if=/dev/rc v_undo1_4096m of=/dev/rc v_undo1_4096m seek=0 skip=1 bs=4k
dd if=/dev/rc v_undo2_4096m of=/dev/rc v_undo2_4096m seek=0 skip=1 bs=4k
dd if=/dev/rc v_temp_4096m of=/dev/rc v_temp_4096m seek=0 skip=1 bs=4k
dd if=/dev/rc v_example_800m of=/dev/rc v_example_800m seek=0 skip=1 bs=4k
dd if=/dev/rc v_users_800m of=/dev/rc v_users_800m seek=0 skip=1 bs=4k
dd if=/dev/rc v_redo1_1_500m of=/dev/rc v_redo1_1_500m seek=0 skip=1 bs=4k
dd if=/dev/rc v_redo1_2_500m of=/dev/rc v_redo1_2_500m seek=0 skip=1 bs=4k
dd if=/dev/rc v_redo1_3_500m of=/dev/rc v_redo1_3_500m seek=0 skip=1 bs=4k
dd if=/dev/rc v_redo1_4_500m of=/dev/rc v_redo1_4_500m seek=0 skip=1 bs=4k
dd if=/dev/rc v_redo1_5_500m of=/dev/rc v_redo1_5_500m seek=0 skip=1 bs=4k
dd if=/dev/rc v_redo1_6_500m of=/dev/rc v_redo1_6_500m seek=0 skip=1 bs=4k
dd if=/dev/rc v_redo2_1_500m of=/dev/rc v_redo2_1_500m seek=0 skip=1 bs=4k
dd if=/dev/rc v_redo2_2_500m of=/dev/rc v_redo2_2_500m seek=0 skip=1 bs=4k
dd if=/dev/rc v_redo2_3_500m of=/dev/rc v_redo2_3_500m seek=0 skip=1 bs=4k
dd if=/dev/rc v_redo2_4_500m of=/dev/rc v_redo2_4_500m seek=0 skip=1 bs=4k
dd if=/dev/rc v_redo2_5_500m of=/dev/rc v_redo2_5_500m seek=0 skip=1 bs=4k
dd if=/dev/rc v_redo2_6_500m of=/dev/rc v_redo2_6_500m seek=0 skip=1 bs=4k
dd if=/dev/rc v_ctl1_110m of=/dev/rc v_ctl1_110m seek=0 skip=1 bs=4k
dd if=/dev/rc v_ctl2_110m of=/dev/rc v_ctl2_110m seek=0 skip=1 bs=4k
dd if=/dev/rc v_ctl3_110m of=/dev/rc v_ctl3_110m seek=0 skip=1 bs=4k
dd if=/dev/rc v_spfile_110m of=/dev/rc v_spfile_110m seek=0 skip=1 bs=4k
dd if=/dev/rc v_pobase of=/dev/rc v_pobase seek=0 skip=1 bs=4k
dd if=/dev/rc v_pobase_indx of=/dev/rc v_pobase_indx seek=0 skip=1 bs=4k
dd if=/dev/rc v_poplan of=/dev/rc v_poplan seek=0 skip=1 bs=4k
dd if=/dev/rc v_poplan_indx of=/dev/rc v_poplan_indx seek=0 skip=1 bs=4k
dd if=/dev/rc v_poorder of=/dev/rc v_poorder seek=0 skip=1 bs=4k
dd if=/dev/rc v_poorder_indx of=/dev/rc v_poorder_indx seek=0 skip=1 bs=4k
dd if=/dev/rc v_posys of=/dev/rc v_posys seek=0 skip=1 bs=4k
dd if=/dev/rc v_posys_indx of=/dev/rc v_posys_indx seek=0 skip=1 bs=4k
dd if=/dev/rc v_potemp of=/dev/rc v_potemp seek=0 skip=1 bs=4k
dd if=/dev/rc v_potemp_indx of=/dev/rc v_potemp_indx seek=0 skip=1 bs=4k










方案B：
1.修改VG为scarable vg
#smit chvg
2.重建裸设备
oraclevg
mklv -y'cv_crs1024m' -t ‘raw’ -T O oraclevg 8
mklv -y'cv_vote1024m' -t ‘raw’ -T O oraclevg 8
mklv -y'cv_system_1024m' -t ‘raw’ -T O oraclevg 10
mklv -y'cv_pwdfile_100m' -t ‘raw’ -T O oraclevg 1
mklv -y'cv_sysaux_800m' -t ‘raw’ -T O oraclevg 10
mklv -y'cv_undo1_4096m' -t ‘raw’ -T O oraclevg 40
mklv -y'cv_undo2_4096m' -t ‘raw’ -T O oraclevg 40
mklv -y'cv_temp_4096m' -t ‘raw’ -T O oraclevg 40
mklv -y'cv_example_800m' -t ‘raw’ -T O oraclevg 10
mklv -y'cv_users_800m' -t ‘raw’ -T O oraclevg 10
mklv -y'cv_redo1_1_500m' -t ‘raw’ -T O oraclevg 10
mklv -y'cv_redo1_2_500m' -t ‘raw’ -T O oraclevg 10
mklv -y'cv_redo1_3_500m' -t ‘raw’ -T O oraclevg 10
mklv -y'cv_redo1_4_500m' -t ‘raw’ -T O oraclevg 10
mklv -y'cv_redo1_5_500m' -t ‘raw’ -T O oraclevg 10
mklv -y'cv_redo1_6_500m' -t ‘raw’ -T O oraclevg 10
mklv -y'cv_redo2_1_500m' -t ‘raw’ -T O oraclevg 10
mklv -y'cv_redo2_2_500m' -t ‘raw’ -T O oraclevg 10
mklv -y'cv_redo2_3_500m' -t ‘raw’ -T O oraclevg 10
mklv -y'cv_redo2_4_500m' -t ‘raw’ -T O oraclevg 10
mklv -y'cv_redo2_5_500m' -t ‘raw’ -T O oraclevg 10
mklv -y'cv_redo2_6_500m' -t ‘raw’ -T O oraclevg 10
mklv -y'cv_ctl1_110m' -t ‘raw’ -T O oraclevg 1
mklv -y'cv_ctl2_110m' -t ‘raw’ -T O oraclevg 1
mklv -y'cv_ctl3_110m' -t ‘raw’ -T O oraclevg 1
mklv -y'cv_spfile_110m' -t ‘raw’ -T O oraclevg 1
mklv -y'cv_recover4096m' -t ‘raw’ -T O oraclevg 40


cvpovg
mklv -y 'cv_pobase' -t ‘raw’ -T O cvpovg 79
mklv -y 'cv_pobase_indx' -t ‘raw’ -T O cvpovg 47
mklv -y 'cv_poplan' -t ‘raw’ -T O cvpovg 157
mklv -y 'cv_poplan_indx' -t ‘raw’ -T O cvpovg 94
mklv -y 'cv_poorder' -t ‘raw’ -T O cvpovg 157
mklv -y 'cv_poorde_indx' -t ‘raw’ -T O cvpovg 94
mklv -y 'cv_posys' -t ‘raw’ -T O cvpovg 40
mklv -y 'cv_posys_indx' -t ‘raw’ -T O cvpovg 24
mklv -y 'cv_potemp' -t ‘raw’ -T O cvpovg 79
3. 属性修改（两个节点都要操作）
#cd /dev
chown oracle:dba /dev/rcv*
chmod 755 /dev/ rcv*

4. 重建库
#su – oracle
$dbca