# vxprintdisk group: oradgty name assoc kstate length ploffs state tutil0 putil0dg oradg oradg - - - - - -dm oradg01 c2t0d2s2 - 244143872 - - - -v ctlfile1 gen enabled 204800 - active - -pl ctlfile1-01 ctlfile1 enabled 204800 - active - -sd oradg01-13 ctlfile1-01 enabled 204800 0 - - -v ctlfile2 gen enabled 204800 - active - -pl ctlfile2-01 ctlfile2 enabled 204800 - active - -sd oradg01-14 ctlfile2-01 enabled 204800 0 - - -v redo101 gen enabled 204800 - active - -pl redo101-01 redo101 enabled 204800 - active - -sd oradg01-04 redo101-01 enabled 204800 0 - - -v redo102 gen enabled 204800 - active - -pl redo102-01 redo102 enabled 204800 - active - -sd oradg01-05 redo102-01 enabled 204800 0 - - -v redo103 gen enabled 204800 - active - -pl redo103-01 redo103 enabled 204800 - active - -sd oradg01-06 redo103-01 enabled 204800 0 - - -v redo201 gen enabled 204800 - active - -pl redo201-01 redo201 enabled 204800 - active - -sd oradg01-07 redo201-01 enabled 204800 0 - - -v redo202 gen enabled 204800 - active - -pl redo202-01 redo202 enabled 204800 - active - -sd oradg01-08 redo202-01 enabled 204800 0 - - -v redo203 gen enabled 204800 - active - -pl redo203-01 redo203 enabled 204800 - active - -sd oradg01-09 redo203-01 enabled 204800 0 - - -v spfile gen enabled 204800 - active - -pl spfile-01 spfile enabled 204800 - active - -sd oradg01-12 spfile-01 enabled 204800 0 - - -v srvcfg gen enabled 1024000 - active - -pl srvcfg-01 srvcfg enabled 1024000 - active - -sd oradg01-15 srvcfg-01 enabled 1024000 0 - - -v system gen enabled 1638400 - active - -pl system-01 system enabled 1638400 - active - -sd oradg01-01 system-01 enabled 1638400 0 - - -v temp gen enabled 2048000 - active - -pl temp-01 temp enabled 2048000 - active - -sd oradg01-02 temp-01 enabled 2048000 0 - - -v undo11 gen enabled 16777216 - active - -pl undo11-01 undo11 enabled 16777216 - active - -sd oradg01-10 undo11-01 enabled 2048000 0 - - -sd oradg01-17 undo11-01 enabled 14729216 2048000 - - -v undo21 gen enabled 2048000 - active - -pl undo21-01 undo21 enabled 2048000 - active - -sd oradg01-11 undo21-01 enabled 2048000 0 - - -v users gen enabled 16777216 - active - -pl users-01 users enabled 16777216 - active - -sd oradg01-03 users-01 enabled 2048000 0 - - -sd oradg01-16 users-01 enabled 14729216 2048000 - - -
2.分配新的裸设备并设置相应的权限
这一步需要以root身份执行
# vxassist -g oradg -u gen make redo104 100m # vxassist -g oradg -u gen make redo105 100m # vxedit -g oradg set user=oracle mode=644 redo104 # vxedit -g oradg set user=oracle mode=644 redo105
3.重新规划redolog file组
$ sqlplus "/ as sysdba"sql*plus: release 9.2.0.4.0 - production on tue sep 14 10:02:47 2004copyright (c) 1982, 2002, oracle corporation. all rights reserved.connected to:oracle9i enterprise edition release 9.2.0.4.0 - 64bit productionwith the real application clusters optionjserver release 9.2.0.4.0 - productionsql> set linesize 120sql> select * from v$log; group# thread# sequence# bytes members arc status first_change# first_tim---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- 1 1 6313 52428800 1 no active 3193855 14-sep-04 2 1 6312 52428800 1 no inactive 3191691 14-sep-04 5 1 6314 52428800 1 no current 3196041 14-sep-04 3 2 17 10485760 1 no current 3016310 14-sep-04 4 2 16 10485760 1 no inactive 1619198 13-sep-04sql> alter database add logfile thread 1 group 6 ('/dev/vx/rdsk/oradg/redo104') size 90m;database altered.sql> alter database add logfile thread 1 group 7 ('/dev/vx/rdsk/oradg/redo105') size 90m;database altered.sql> select * from v$log; group# thread# sequence# bytes members arc status first_change# first_tim---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- 1 1 6316 52428800 1 no inactive 3200415 14-sep-04 2 1 6315 52428800 1 no inactive 3198233 14-sep-04 5 1 6317 52428800 1 no active 3202621 14-sep-04 6 1 6318 94371840 1 no current 3204811 14-sep-04 7 1 0 94371840 1 yes unused 0 3 2 17 10485760 1 no current 3016310 14-sep-04 4 2 16 10485760 1 no inactive 1619198 13-sep-047 rows selected.sql> alter database drop logfile group 5;database altered.sql> alter database add logfile thread 1 group 5 ('/dev/vx/rdsk/oradg/redo103') size 90m;database altered.....sql> select *from v$log; group# thread# sequence# bytes members arc status first_change# first_tim---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- 1 1 6327 94371840 1 no inactive 3238534 14-sep-04 2 1 6329 94371840 1 no current 3246417 14-sep-04 5 1 0 94371840 1 yes unused 0 6 1 6328 94371840 1 no active 3242482 14-sep-04 7 1 6326 94371840 1 no inactive 3234597 14-sep-04 3 2 17 10485760 1 no current 3016310 14-sep-04 4 2 16 10485760 1 no inactive 1619198 13-sep-047 rows selected.
