oracle表空間管理

1、用 oracle 企業(yè)管理器登陸oracle,選擇表空間 ,查看 oracle 表空間的使用率重點(diǎn)查看 bpms_data bpms_index temp 這三個(gè)表空間 ,如果表空間使用率達(dá)到 80%,就須擴(kuò)容 .擴(kuò)容命令如下 :例: 給 bpms_data 擴(kuò)容 20G1.在 datadg1 邏輯卷組分配新的邏輯卷bpms_data4vxassist -g datadg1 -U gen make BPMS_data420g&2.將權(quán)限分配給 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以前擴(kuò)容命令如下 :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 裸設(shè)備文件的管理命令。vxassist -g datadg -U gen make BPMS_index4 5000m &

10、 vxedit -g datadg set group=dba user=oracle mode=660 BPMS_index4 &由于 OA 系統(tǒng)的使用鑼設(shè)備存儲(chǔ)數(shù)據(jù)文件,所以需要先創(chuàng)建裸卷用 Root 用戶登陸查看當(dāng)前裸設(shè)備情況(vxprint)分配新的裸設(shè)備并設(shè)置相應(yīng)的權(quán)限,增加 6 個(gè)裸卷 . 由于生產(chǎn)上 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設(shè)置相應(yīng)的權(quán)限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為其他人的寫權(quán)限 , 為其他人的讀權(quán)限 , 0040為組的讀權(quán)限相加

13、而來(lái)0002 為所有者的寫權(quán)限， 0004 為所有者的讀權(quán)限，0020 為組的寫權(quán)限， 0040為組的讀權(quán)限， 0200 為其他人的寫權(quán)限， 0400 為其他人的讀權(quán)限,切換為數(shù)據(jù)庫(kù)用戶后登陸到sqlplus 創(chuàng)建 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;查看 ,看到當(dāng)前的日志成員的狀態(tài)是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