数据库

img eygle

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

发表于2004/9/21 22:32:00  1262人阅读

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

Tuesday, 2004-09-14 11:52 Eygle 
    

 

 原文连接:

http://www.eygle.com/faq/How.To.Mangement.redologfile.in.Rac.Raw.htm

本文简单介绍在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  -        -       -

                      

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 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Real Application Clusters option
JServer Release 9.2.0.4.0 - Production

SQL> set linesize 120
SQL> 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-04

SQL> 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-04

7 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-04

7 rows selected.
						

 

阅读全文
0 0

相关文章推荐

img
取 消
img