在RAC环境中如何管理日志(redologfile)组

文章作者 100test 发表时间 2007:03:14 13:45:39
来源 100Test.Com百考试题网

本文简单介绍在RAC裸设备环境下如何管理日志文件(redolog file)

本文环境:Oracle9i Rac VCS4.0 VxVM4.0 Solaris9.0 SunFire210

1.首先可以查看当前裸设备情况

# vxprint
Disk group: oradg

TY NAME ASSOC KSTATE LENGTH PLOFFS STATE TUTIL0 PUTIL0
dg 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 - - -