AIX 5.3 裸设备建库
来源:互联网 发布:php大型网站架构 编辑:程序博客网 时间:2024/06/06 02:23
裸设备建库1.首先查看要创建逻辑卷上的卷组datavgdatavg ppsize 为32M[aix /] #lsvg datavgVOLUME GROUP: datavg VG IDENTIFIER: 00cd04ce00004c00000001215271137fVG STATE: active PP SIZE: 32 megabyte(s)VG PERMISSION: read/write TOTAL PPs: 2187 (69984 megabytes)MAX LVs: 256 FREE PPs: 625 (20000 megabytes)LVs: 17 USED PPs: 1562 (49984 megabytes)OPEN LVs: 15 QUORUM: 2TOTAL PVs: 1 VG DESCRIPTORS: 2STALE PVs: 0 STALE PPs: 0ACTIVE PVs: 1 AUTO ON: yesMAX PPs per VG: 30480 MAX PPs per PV: 3048 MAX PVs: 10LTG size (Dynamic): 256 kilobyte(s) AUTO SYNC: noHOT SPARE: no BB POLICY: relocatable 2.在datavg上建立好相应的裸设备mklv -y'ctl01' -w'n' -s'n' -r'n' -t 'raw' datavg 2mklv -y'ctl02' -w'n' -s'n' -r'n' -t 'raw' datavg 2mklv -y'ctl03' -w'n' -s'n' -r'n' -t 'raw' datavg 2mklv -y'redo01' -w'n' -s'n' -r'n' -t 'raw' datavg 2mklv -y'redo02' -w'n' -s'n' -r'n' -t 'raw' datavg 2mklv -y'redo03' -w'n' -s'n' -r'n' -t 'raw' datavg 2mklv -y'system01' -w'n' -s'n' -r'n' -t 'raw' datavg 19mklv -y'sysaux01' -w'n' -s'n' -r'n' -t 'raw' datavg 19mklv -y'users01' -w'n' -s'n' -r'n' -t 'raw' datavg 19mklv -y'undotbs01' -w'n' -s'n' -r'n' -t 'raw' datavg 19mklv -y'temp01' -w'n' -s'n' -r'n' -t 'raw' datavg 193.建好后赋予相应的属主及其权限注:是r开头的设备chown -R oracle:oinstall /dev/rctl0*chown -R oracle:oinstall /dev/rredo0*chown -R oracle:oinstall /dev/rsys*chown -R oracle:oinstall /dev/rundotbs01*chown -R oracle:oinstall /dev/rtemp01*chown -R oracle:oinstall /dev/rusers01*查看复权后的结果[aix94 /] #ls -al /dev/rctl0*crwxrwxr-x 1 oracle oinstall 45, 5 Jun 8 16:11 /dev/rctl01crwxrwxr-x 1 oracle oinstall 45, 6 Jun 8 16:11 /dev/rctl02crwxrwxr-x 1 oracle oinstall 45, 7 Jun 8 16:11 /dev/rctl03[aix94 /] #ls -al /dev/rredo0*crwxrwxr-x 1 oracle oinstall 45, 8 Jun 8 22:00 /dev/rredo01crwxrwxr-x 1 oracle oinstall 45, 10 Jun 8 16:14 /dev/rredo02crwxrwxr-x 1 oracle oinstall 45, 11 Jun 8 22:00 /dev/rredo03[aix94 /] #ls -al /dev/rsys*crw-rw---- 1 oracle oinstall 45, 13 Jun 8 22:00 /dev/rsysaux01crw-rw---- 1 oracle oinstall 45, 12 Jun 8 16:11 /dev/rsystem01[aix94 /] #ls -al /dev/rusers01 crw-rw---- 1 oracle oinstall 45, 14 Jun 8 16:11 /dev/rusers01[aix94 /] #ls -al /dev/rtemp01 crw-rw---- 1 oracle oinstall 45, 16 Jun 8 16:12 /dev/rtemp01[aix94 /] #ls -al /dev/rundotbs01 crw-rw---- 1 oracle oinstall 45, 15 Jun 8 16:11 /dev/rundotbs01[aix94 /] #lsvg -l datavg TYPE均为RAW设备类datavg:LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINTctl01 raw 2 2 1 open/syncd N/Actl02 raw 2 2 1 open/syncd N/Actl03 raw 2 2 1 open/syncd N/Aredo01 raw 2 2 1 open/syncd N/Aredo02 raw 2 2 1 open/syncd N/Aredo03 raw 2 2 1 open/syncd N/Asystem01 raw 19 19 1 open/syncd N/Asysaux01 raw 19 19 1 open/syncd N/Ausers01 raw 19 19 1 open/syncd N/Aundotbs01 raw 19 19 1 open/syncd N/Atemp01 raw 19 19 1 open/syncd N/A [aix94 /] #su -oracle添加裸设备mapping文件oracle$ vi raw.txt 添加以下内容system=/dev/rsystem01undotbs1=/dev/rundotbs01redo1_1=/dev/rredo01redo1_2=/dev/rredo02redo1_3=/dev/rredo03control1=/dev/rctl01control2=/dev/rctl02control3=/dev/rctl03users=/dev/rusers01temp=/dev/rtemp01sysaux=/dev/rsysaux01bash-3.2$ more .profile 添加DBCA_RAW_CONFIG=/u01/oracle/product/10.2.0/db_2/dbs/raw.txt export DBCA_RAW_CONFIG完成就就可以DBCA创建数据库了