lv_ctl1_128m 128M 1 控制文件
lv_ctl2_128m 128M 1 控制文件
lv_ctl3_128m 128M 1 控制文件
lv_spfile_128m 128M 1 服务器参数文件
以下2个暂时不建立
lv_example_1024m 1024M 8 Example表空间
lv_recover_2048m 2048M 16 flashback
建立脚本:
从9.2.0.4开始Oracle在AIX上支持了0 OFFSET的裸设备,使用0 OFFSET的裸设备是一种比较安全的做法,可以避免块断裂造成的问题。
因此ORACLE建议从9204后的环境下使用这种裸设备。-T O就是创建0 OFFSET的裸设备,不过只有SCALEABLE VG和BIG VG支持这种LV,其他种类的VG不支持
/usr/sbin/mklv -y'lv_ocr_512m' -w'n' -s'n' -r'n' -t'raw' -T O datavg 4
/usr/sbin/mklv -y'lv_vote_512m' -w'n' -s'n' -r'n' -t'raw' -T O datavg 4
/usr/sbin/mklv -y'lv_system_2048m' -w'n' -s'n' -r'n' -t'raw' -T O datavg 16
/usr/sbin/mklv -y'lv_pwdfile_128m' -w'n' -s'n' -r'n' -t'raw' -T O datavg 1
/usr/sbin/mklv -y'lv_sysaux_2048m' -w'n' -s'n' -r'n' -t'raw' -T O datavg 16
/usr/sbin/mklv -y'lv_undo1_2048m' -w'n' -s'n' -r'n' -t'raw' -T O datavg 16
/usr/sbin/mklv -y'lv_undo2_2048m' -w'n' -s'n' -r'n' -t'raw' -T O datavg 16
/usr/sbin/mklv -y'lv_temp_2048m' -w'n' -s'n' -r'n' -t'raw' -T O datavg 16
/usr/sbin/mklv -y'lv_users_1024m' -w'n' -s'n' -r'n' -t'raw' -T O datavg 8
/usr/sbin/mklv -y'lv_redo1_1_128m' -w'n' -s'n' -r'n' -t'raw' -T O datavg 1
/usr/sbin/mklv -y'lv_redo1_2_128m' -w'n' -s'n' -r'n' -t'raw' -T O datavg 1
/usr/sbin/mklv -y'lv_redo1_3_128m' -w'n' -s'n' -r'n' -t'raw' -T O datavg 1
/usr/sbin/mklv -y'lv_redo1_4_128m' -w'n' -s'n' -r'n' -t'raw' -T O datavg 1
/usr/sbin/mklv -y'lv_redo1_5_128m' -w'n' -s'n' -r'n' -t'raw' -T O datavg 1
/usr/sbin/mklv -y'lv_redo1_6_128m' -w'n' -s'n' -r'n' -t'raw' -T O datavg 1
/usr/sbin/mklv -y'lv_redo2_1_128m' -w'n' -s'n' -r'n' -t'raw' -T O datavg 1
/usr/sbin/mklv -y'lv_redo2_2_128m' -w'n' -s'n' -r'n' -t'raw' -T O datavg 1
/usr/sbin/mklv -y'lv_redo2_3_128m' -w'n' -s'n' -r'n' -t'raw' -T O datavg 1
/usr/sbin/mklv -y'lv_redo2_4_128m' -w'n' -s'n' -r'n' -t'raw' -T O datavg 1
/usr/sbin/mklv -y'lv_redo2_5_128m' -w'n' -s'n' -r'n' -t'raw' -T O datavg 1
/usr/sbin/mklv -y'lv_redo2_6_128m' -w'n' -s'n' -r'n' -t'raw' -T O datavg 1
/usr/sbin/mklv -y'lv_ctl1_128m' -w'n' -s'n' -r'n' -t'raw' -T O datavg 1
/usr/sbin/mklv -y'lv_ctl2_128m' -w'n' -s'n' -r'n' -t'raw' -T O datavg 1
/usr/sbin/mklv -y'lv_ctl3_128m' -w'n' -s'n' -r'n' -t'raw' -T O datavg 1
/usr/sbin/mklv -y'lv_spfile_128m' -w'n' -s'n' -r'n' -t'raw' -T O datavg 1
修改权限
OCR的lv用户为root,组为oinstall,权限为640
OCR device:
# chown root:oinstall /dev/rhdiskn
# chmod 640 /dev/rhdiskn
其它lv用户为oracle,组为dba,权限为660
# chown oracle:dba /dev/rhdiskn
# chmod 660 /dev/rhdiskn
配置DBCA_RAW_CONFIG
用oracle用户在/home/oracle下,建立一个dbca_raw.conf
system=/dev/rlv_system_2048m
sysaux=/dev/rlv_sysaux_2048m
users=/dev/rlv_users_1024m
temp=/dev/rlv_temp_2048m
undotbs1=/dev/rlv_undo1_2048m
undotbs2=/dev/rlv_undo2_2048m
redo1_1=/dev/rlv_redo1_1_128m
redo1_2=/dev/rlv_redo1_2_128m
redo1_3=/dev/rlv_redo1_3_128m
redo1_4=/dev/rlv_redo1_4_128m
redo1_5=/dev/rlv_redo1_5_128m
redo1_6=/dev/rlv_redo1_6_128m
redo2_1=/dev/rlv_redo2_1_128m
redo2_2=/dev/rlv_redo2_2_128m
redo2_3=/dev/rlv_redo2_3_128m
redo2_4=/dev/rlv_redo2_4_128m
redo2_5=/dev/rlv_redo2_5_128m
redo2_6=/dev/rlv_redo2_6_128m
control1=/dev/rlv_ctl1_128m
control2=/dev/rlv_ctl2_128m
control3=/dev/rlv_ctl3_128m
pfile=/dev/rlv_spfile_128m
pwdfile=/dev/rlv_pwdfile_128m
3.oracle目录及用户profile
新建立一个lv,用于建立oracle软件目录,建立好文件系统之后,修改目录owner为oracle,组为oinstall,目录权限为775
ORACLE_BASE设置为/oracle/product
ORACLE_HOME为/oracle/product/ora