问题．WARNING: You are creating/reusing datafile /dev/rcv_sysaux_800m.WARNING: Oracle recommends creating new datafiles on devices with zero offset. Th......
问题．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
1/4 1 2 3 4 下一页 尾页 |
