11g rac 修改redo日志的大小

1、11g rac 修改redo日志的大小1. 查看當前redo日志的情況sysRACDB>SELECT l.group#, l.thread#, f.member, l.archived, l.status, (bytes/1024/1024) size_mb FROM v$log l,v$logfile f WHERE f.group# = l.group# ORDER BY 1,2;2. 執(zhí)行以下語句，創(chuàng)建新的日志組，作為過渡日志組alter database add logfile thread 1 group 5 ('+DATA/racdb/onlinelog/group_

2、5_1.log') size 100M;alter database add logfile thread 1 group 6 ('+DATA/racdb/onlinelog/group_6_1.log') size 100M;alter database add logfile thread 2 group 7 ('+DATA/racdb/onlinelog/group_7_1.log') size 100M;alter database add logfile thread 2 group 8 ('+DATA/racdb/onlinelog/

3、group_8_1.log') size 100M;3. 多次切換日志組，直到要替換的日志組變?yōu)镮NACTIVE狀態(tài)（所有節(jié)點執(zhí)行）sysRACDB>alter system switch logfile;sysRACDB>select group#,THREAD#,status,archived,bytes/1024/1024 MB from v$log;GROUP# THREAD# STATUS ARC MB- - - - - 1 1 INACTIVE YES 50 2 1 INACTIVE YES 50 3 2 INACTIVE NO 50 4 2 INACTIVE

4、YES 50 5 1 ACTIVE YES 100 6 1 CURRENT NO 100 7 2 INACTIVE YES 100 8 2 INACTIVE YES 1004. 刪除日志組1,2,3,4sysRACDB>alter database drop logfile group 1;sysRACDB>alter database drop logfile group 2;sysRACDB>alter database drop logfile group 3;sysRACDB>alter database drop logfile group 4;sysRACD

5、B>select group#,THREAD#,status,archived,bytes/1024/1024 MB from v$log;GROUP# THREAD# STATUS ARCHIVED MB- - - - - 5 1 ACTIVE YES 100 6 1 CURRENT NO 100 7 2 INACTIVE YES 100 8 2 INACTIVE YES 1005. 重新添加日志組1,2,3,4分配日志文件大小為100MBalter database add logfile thread 1 group 1 ('+DATA/racdb/onlinelog/gr

6、oup_1_1.log','+FRA/racdb/onlinelog/group_1_2.log') size 100M;alter database add logfile thread 1 group 2 ('+DATA/racdb/onlinelog/group_2_1.log','+FRA/racdb/onlinelog/group_2_2.log') size 100M;alter database add logfile thread 2 group 3 ('+DATA/racdb/onlinelog/group_3_

7、1.log','+FRA/racdb/onlinelog/group_3_2.log') size 100M;alter database add logfile thread 2 group 4 ('+DATA/racdb/onlinelog/group_4_1.log','+FRA/racdb/onlinelog/group_4_2.log') size 100M;添加玩后，查看日志組sysRACDB>select group#,THREAD#,status,archived,bytes/1024/1024 MB from v$

8、log;GROUP# THREAD# STATUS ARCHIVED MB- - - - - 1 1 CURRENT NO 100 2 1 INACTIVE YES 100 3 2 UNUSED YES 100 4 2 UNUSED YES 100 5 1 INACTIVE YES 100 6 1 INACTIVE YES 100 7 2 CURRENT NO 100 8 2 INACTIVE YES 1006. 切換日志組，使日志組5,6,7,8變?yōu)镮NACTIVE sysRACDB>alter system switch logfile;sysRACDB>select grou

9、p#,THREAD#,status,archived,bytes/1024/1024 MB from v$log;GROUP# THREAD# STATUS ARCHIVED MB- - - - - 1 1 CURRENT NO 100 2 1 INACTIVE YES 100 3 2 INACTIVE YES 100 4 2 CURRENT NO 100 5 1 INACTIVE YES 100 6 1 INACTIVE YES 100 7 2 INACTIVE YES 100 8 2 INACTIVE YES 1007. 刪除過渡日志組5,6,7,8sysRACDB>alter database drop logfile group 5;sysRACDB>alt