Expand oracle tablespace with bare Devices

Expand oracle tablespace server with bare device: IBM P6 minicomputer OS: aix5.db: Oracle 10g existing tablespace users, prompting that the tablespace is insufficient. 1. run the following SQL statement to query the raw device file name used in the table space: select * from DBA_DATA_FILESwhere tablespace_name = 'users: FILE_NAME FILE_ID TABLESPACE_NAME BYTES/dev/rlvusers01 5 USERS 17179607040/dev/rlvusers02 6 USERS 17179860992/dev/rlvusers03 7 USERS 17179860992/dev/rlvusers04 9 USERS 17179860992 2. query the vg [P6: 51: oracle]/home/oracle> lsvg-l datavgdatavg: lv name type LPs PPs PVs lv state mount POINTlvusers01 raw 64 64 1 open/s Yncd N/Alvusers02 raw 64 64 1 open/syncd N/Alvusers03 raw 64 64 1 open/syncd N/Alvusers04 raw 64 64 1 open/syncd N/A 3. view the detailed information of the bare device lv [P6: 51: oracle]/home/oracle> lslv lvusers04LOGICAL VOLUME: lvusers04 volume group: datavgLV IDENTIFIER: 00c4cf142134c00000001216d90116b. 24 PERMISSION: read/writeVG STATE: active/complete lv state: opened/syncdTYPE: raw write verify: offMAX LPs: 512 pp size: 256 megabyte (S) COPIES: 1 sched policy: parallelLPs: 64 PPs: 64 STALE PPs: 0 bb policy: relocatableINTER-POLICY: minimum RELOCATABLE: noINTRA-POLICY: middle upper bound: 128 mount point: N/a label: NoneMIRROR write consistency: off each lp copy on a separate pv?: No Serialize IO?: No devicesubtype: DS_LVZ note LPS: 64, VG: datavg, PP size: 256 M so the lvusers04 size = 64 * M = 16G 4. check if the vg free space is sufficient [P6: 51: oracle]/dev> lsvg datavgVOLUME GROUP: datavg vg identifier: 00c4cf142134c00000001216d901_bvg STATE: active pp size: 256 megabyte (s) VG PERMISSION: read/write TOTAL PPs: 1209 (309504 megabytes) MAX LVs: 512 FREE PPs: 495 (126720 megabytes) LVs: 27 USED PPs: 714 (182784 megabytes) OPEN LVs: 26 QU ORUM: 1 (Disabled) TOTAL PVs: 3 vg descriptors: 3 STALE PVs: 0 STALE PPs: 0 ACTIVE PVs: 3 auto on: noConcurrent: Enhanced-Capable Auto-Concurrent: disabledVG Mode: Concurrent Node ID:-Active Nodes: MAX PPs per VG: 130048 MAX PPs per PV: 1016 MAX PVs: 128LTG size (Dynamic): 1024 kilobyte (s) auto sync: noHOT SPARE: no bb policy: relocatable note Free PPs: 126720 M, about 120G 5. create a bare device LV (use root to log on) # mklv-y 'lvusers 05 '-t' raw' datavg 64 6. change the owner of the bare device # chown oracle: dba/dev/rlvusers05 * Note that if oracle uses RAC, the above statement must be executed on each node. * ** After the test, it is found that after the increase, the hacmp must be updated (because the added lv only has one node, and the two nodes do not ), therefore, restart hacmp and update the hacmp information. After the restart, the owner of the lv may be restored to the root, which needs to be manually reset. * ** 7. expand the tablespace SQL in ORACLE <ALTER tablespace users add DATAFILE '/dev/rlvusers05' SIZE 16000 M AUTOEXTEND OFF; note that the size is 160000 M rather than 16G, because it cannot be full, leave some space. 8. check the lv status of the bare device [P6: 51: oracle]/dev> lslv lvusers05LOGICAL VOLUME: lvusers05 volume group: datavgLV IDENTIFIER: 00c4cf142134c00000001216d901_ B. 26 PERMISSION: read/writeVG STATE: active/complete lv state: opened/syncdTYPE: raw write verify: offMAX LPs: 512 pp size: 256 megabyte (s) COPIES: 1 sched policy: parallelLPs: 64 PPs: 64 STALE PPs: 0 bb policy: relocatableINTER-POLICY: minimum RELOCATABLE: yesINTRA -POLICY: middle upper bound: 128 mount point: N/a label: NoneMIRROR write consistency: on/active each lp copy on a separate pv?: Yes Serialize IO?: NO. Note: opened/syncd is finished.