How to manage the log (Redolog file) group in a RAC environment

How to manage the log (Redolog file) group in a RAC environment

Tuesday, 2004-09-14 11:52 eygle


Original connection:

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

This article briefly describes how to manage log files in a RAC raw device environment (Redolog file)

This article environment: Oracle9i RAC + VCS4.0 + VxVM4.0 + Solaris9.0 + SunFire210

1. You can first view the current raw equipment situation

# vxprintdisk group:oradgty NAME ASSOC kstate LENGTH ploffs State TUTIL0 PUTIL0DG ORADG ORADG-----DM ORADG01 2s2-244143872---v ctlfile1 gen enabled 204800-active--pl ctlfile1-01 ctlfile1 ENABLED 204800-active--sd ora DG01-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 1 enabled 204800-active--sd oradg01-04 redo101-01 enabled 204800 0---v redo102 gen enabled 204800-active--pl re DO102-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 EN abled 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 ENABLE D 204800 0---v srvcfg gen enabled 1024000-active--pl srvcfg-01 srvcfg ENABLED 1024000-active--sd oradg01-15 SRV CFG-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-activ E--SD oradg01-02 temp-01 enabled 2048000 0------------v undo11 gen enabled 16777216-active--pl undo11-01 undo11 ENABLED 16 777216-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. Assign new raw devices and set appropriate permissions

This step needs to be performed as 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. Re-planning the Redolog file group

$ sqlplus "/as SYSDBA" Sql*plus:release 9.2.0.4.0-production on Tue Sep 10:02:47 2004Copyright (c) 1982, 2002, Oracl E Corporation. All rights reserved. Connected to:oracle9i Enterprise Edition release 9.2.0.4.0-64bit productionwith the real application clusters Ver 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 3196041 14-sep-04 3 2 10485760 1 NO current 3016310 14-sep-04 4 2 10485760 1 NO INACTIVE 1619198 13-sep-04sql> ALTER DATABASE add logfile Thread 1 Group 6 ('/DEV/VX/RDSK/ORADG/R edo104 ') 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 N O 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 10485760 1 no current 3016310 14-sep-04 4 2 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 N O 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 3 234597 14-sep-04 3 2 10485760 1 NO current 3016310 14-sep-04 4 2 10485760 1 NO INACTIVE 1619198 13-sep-047 rows Sele CTED.