Steps for Oracle to expand tablespaces Based on RAW in Linux

RAW-format tablespace Resizing in data. The procedure is as follows:View existing bare devices # cd/dev/raw # ls-rtlCheck the raw device size/View previous lvSize # blockdev -- getsize/dev/raw/raw3720488192 # blockdev -- getsize/dev/raw/raw3820488192 # blockdev -- getsize/dev/raw/raw3010248192 # lvscan ACTIVE '/dev/datavgsda/ indxsda07 '[4.89 GB] inheritACTIVE'/dev/datavgsda/datasda08 '[9.77 GB] inheritACTIVE'/dev/datavgsda/indxsda08 '[4.89 GB] inheritACTIVE'/dev/datavgsda '[9.77 GB] inherit .................................. ...........................View bare devices and lvBinding relationship # cd/etc/sysconfig # more rawdevicesView VGFree Space # vgdisplayFreePE/Size27301/106.64 GB create lv # lvcreate-L 10240 m-n datasda11 datavgsda # lvcreate-L 10240 m-n datasda12 datavgsda bind lv to RAW # raw/ dev/raw/raw39/dev/datavgsda/datasda11 # raw/dev/raw/raw40/dev/datavgsda/datasda12 Modify/etc/syscnfig/rawdevices file, add the following two lines, automatically load bare devices/dev/raw/raw39/dev/datavgsda/datasda11/dev/raw/raw40/dev/datavgsda/datasda12 ##### skip this step: run/etc/init. d/rawdevices restart authorize the bare device in the configuration file # chown Oracle: dba/dev/raw/raw39 # chown oracle: dba/dev/raw/raw40 # chown 660/dev/raw/raw39 # chown 660/dev/raw/raw40 # this step has been completed: AT/etc/rc. there is already a/bin/chown-R oracle: dba/dev/raw, used to ensure effective authorization after reboot # raw-qa can view the current raw information create a link file to view the previous link # pwd/oracle/data/EJETDB # ls-rtl total usage 188lrwxrwxrwx1 oracle dba14 2010-06-06undotbs03->/dev/raw/raw12lrwxrwxrwx1 oracle dba14 2010-06-06undotbs02->/dev/raw/raw11 (created by an oracle user) ln-s/dev/raw/raw39/oracle/data/EJETDB/datasda11ln-s/dev/raw/raw40/oracle/data/EJETDB/datasda12 alter tablespace users add datafile '/ oracle/data/EJETDB/datasda11 'size 10200 m reuse; alter tablespace users add datafile '/oracle/data/EJETDB/datasda12' SIZE 10200 m reuse;