oracle表空间管理

1、用 oracle 企业管理器登陆oracle,选择表空间 ,查看 oracle 表空间的使用率重点查看 bpms_data bpms_index temp 这三个表空间 ,如果表空间使用率达到 80%,就须扩容 .扩容命令如下 :例: 给 bpms_data 扩容 20G1.在 datadg1 逻辑卷组分配新的逻辑卷bpms_data4vxassist -g datadg1 -U gen make BPMS_data420g&2.将权限分配给 oracle 用户和 dba 组 vxedit -g datadg set user=oracle group=dba mode=644BPMS

2、_data43.将空间分配给oracle 表空间ALTER TABLESPACE "BPMS_DATA" ADDDA TAFILE '/dev/vx/rdsk/datadg/BPMS_data4' SIZE 10000M以前扩容命令如下 :vxassist -g datadg1 -U gen make BPMS_data20g&vxassist -g datadg1 -U gen make BPMS_data220g&vxassist -g datadg1 -U gen make BPMS_data320g&vxassist -g d

3、atadg1 -U gen make BPMS_index20g&vxassist -g datadg1 -U gen make BPMS_index220g&vxassist -g datadg1 -U gen make BPMS_index320g&vxassist -g datadg1 -U gen make PERFSTAT_DA TA500m&vxassist -g datadg1 -U gen make config1g&vxassist -g datadg1 -U gen make control1256m&vxassist -g

4、datadg1 -U gen make control2256m&vxassist -g datadg1 -U gen make control3256m&vxassist -g datadg1 -U gen make cwmlite1100m&vxassist -g datadg1 -U gen make data_recover11g&vxassist -g datadg1 -U gen make drsys1200m&vxassist -g datadg1 -U gen make example1160m&vxassist -g datad

5、g1 -U gen make indx1100m&vxassist -g datadg1 -U gen make odm1100m&vxassist -g datadg1 -U gen make redo1_1128m&vxassist -g datadg1 -U gen make redo1_1_02128m&vxassist -g datadg1 -U gen make redo1_2128m&vxassist -g datadg1 -U gen make redo1_2_02128m&vxassist -g datadg1 -U gen m

6、ake redo1_3128m&vxassist -g datadg1 -U gen make redo1_3_02128m&vxassist -g datadg1 -U gen make redo2_1128m&vxassist -g datadg1 -U gen make redo2_1_02128m&vxassist -g datadg1 -U gen make redo2_2128m&vxassist -g datadg1 -U gen make redo2_2_02128m&vxassist -g datadg1 -U gen make

7、 redo2_3128m&vxassist -g datadg1 -U gen make redo2_3_02128m&vxassist -g datadg1 -U gen make spfile1100m&vxassist -g datadg1 -U gen make system12g&vxassist -g datadg1 -U gen make temp14g&vxassist -g datadg1 -U gen make temp24g&vxassist -g datadg1 -U gen make test_09025g&vx

8、assist -g datadg1 -U gen make tools50m&vxassist -g datadg1 -U gen make undotbs14g&vxassist -g datadg1 -U gen make undotbs24g&vxassist -g datadg1 -U gen make undotbs34g&vxassist -g datadg1 -U gen make undotbs44g&vxassist -g datadg1 -U gen make user1500m&vxassist -g datadg1 -U

9、gen make xdb1100m&vxassist -g datadg1 -U gen make file_data10g&vxassist -g datadg1 -U gen make file_index10g&vxassist -g datadg1 -U gen make file_blob10g&vxedit -g datadg set user=oracle group=dba mode=644temp4#省公司 RAC 裸设备文件的管理命令。vxassist -g datadg -U gen make BPMS_index4 5000m &

10、 vxedit -g datadg set group=dba user=oracle mode=660 BPMS_index4 &由于 OA 系统的使用锣设备存储数据文件,所以需要先创建裸卷用 Root 用户登陆查看当前裸设备情况(vxprint)分配新的裸设备并设置相应的权限,增加 6 个裸卷 . 由于生产上 redo 裸卷的大小为 245760,所以新建也以此大小建立 vxassist -g datadg -U gen make redo1_1_02 245760vxassist -g datadg -U gen make redo1_2_02 245760vxassist -g

11、 datadg -U gen make redo1_3_02 245760vxassist -g datadg -U gen make redo2_1_02 245760vxassist -g datadg -U gen make redo2_2_02 245760vxassist -g datadg -U gen make redo2_3_02 245760设置相应的权限vxedit -g datadg set user=oracle group=dba mode=644redo1_1_02vxedit -g datadg set user=oracle group=dba mode=644

12、 redo2_1_02vxedit -g datadg set user=oracle group=dba mode=644 redo1_2_02vxedit -g datadg set user=oracle group=dba mode=644 redo2_2_02vxedit -g datadg set user=oracle group=dba mode=644redo1_3_02vxedit -g datadg set user=oracle group=dba mode=644redo2_3_02 mode=644为其他人的写权限 , 为其他人的读权限 , 0040为组的读权限相加

13、而来0002 为所有者的写权限， 0004 为所有者的读权限，0020 为组的写权限， 0040为组的读权限， 0200 为其他人的写权限， 0400 为其他人的读权限,切换为数据库用户后登陆到sqlplus 创建 redo 日志成员alter database add logfile member '/dev x/rdsk/datadg/redo1_1_02' to group 1;alter database add logfile member '/dev x/rdsk/datadg/redo1_2_02' to group 2;alter databas

14、e add logfile member '/dev x/rdsk/datadg/redo1_3_02' to group 3;alter database add logfile member '/dev x/rdsk/datadg/redo2_1_02' to group 4;alter database add logfile member '/dev x/rdsk/datadg/redo2_2_02' to group 5;alter database add logfile member '/dev x/rdsk/datadg/

15、redo2_3_02' to group 6;具体可以 select * from v$logfile;查看 ,看到当前的日志成员的状态是INV ALID 可以通过切换日志文件后再查看.vxassist -g datadg -U gen make BPMS_data4 20gvxassist -g datadg -U gen make temp4 4gvxedit -g datadg set user=oracle group=dba mode=644 temp4vxedit -g datadg set user=oracle group=dba mode=644 BPMS_data4alter database add datafile '/dev x/rdsk/datadg/BPMS_data4' size 20gvxassist -g datadg -U gen make BPMS_data5 20gvxedit -g datadg set user=oracle group=dba mode=644 BPMS_data5ALTER TABLESPACE "BPMS_DATA" ADDDA TAFILE '/dev/vx/rdsk/dat