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

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

在RAC环境中如何管理日志(redolog file)组 在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.首先可以查看当前裸设备情况

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.