资源描述：
《11g rac 修改redo日志的大小.doc》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。
1、11grac修改redo日志的大小1.查看当前redo日志的情况sys@RACDB>SELECTl.group#,l.thread#,f.member,l.archived,l.status,(bytes/1024/1024)size_mbFROMv$logl,v$logfilefWHEREf.group#=l.group#ORDERBY1,2;2.执行以下语句，创建新的日志组，作为过渡日志组alterdatabaseaddlogfilethread1group5('+DATA/racdb/onlinelog/group
2、_5_1.log')size100M;alterdatabaseaddlogfilethread1group6('+DATA/racdb/onlinelog/group_6_1.log')size100M;alterdatabaseaddlogfilethread2group7('+DATA/racdb/onlinelog/group_7_1.log')size100M;alterdatabaseaddlogfilethread2group8('+DATA/racdb/onlinelog/group_8_1.log')s
3、ize100M;3.多次切换日志组，直到要替换的日志组变为INACTIVE状态（所有节点执行）sys@RACDB>altersystemswitchlogfile;sys@RACDB>selectgroup#,THREAD#,status,archived,bytes/1024/1024MBfromv$log;GROUP#THREAD#STATUSARCMB------------------------------------11INACTIVEYES5021INACTIVEYES5032INACTIVENO5042I
4、NACTIVEYES5051ACTIVEYES10061CURRENTNO10072INACTIVEYES10082INACTIVEYES1001.删除日志组1,2,3,4sys@RACDB>alterdatabasedroplogfilegroup1;sys@RACDB>alterdatabasedroplogfilegroup2;sys@RACDB>alterdatabasedroplogfilegroup3;sys@RACDB>alterdatabasedroplogfilegroup4;sys@RACDB>sel
5、ectgroup#,THREAD#,status,archived,bytes/1024/1024MBfromv$log;GROUP#THREAD#STATUSARCHIVEDMB-------------------------------------------51ACTIVEYES10061CURRENTNO10072INACTIVEYES10082INACTIVEYES1001.重新添加日志组1,2,3,4分配日志文件大小为100MBalterdatabaseaddlogfilethread1group1('+D
6、ATA/racdb/onlinelog/group_1_1.log','+FRA/racdb/onlinelog/group_1_2.log')size100M;alterdatabaseaddlogfilethread1group2('+DATA/racdb/onlinelog/group_2_1.log','+FRA/racdb/onlinelog/group_2_2.log')size100M;alterdatabaseaddlogfilethread2group3('+DATA/racdb/onlinelog/g
7、roup_3_1.log','+FRA/racdb/onlinelog/group_3_2.log')size100M;alterdatabaseaddlogfilethread2group4('+DATA/racdb/onlinelog/group_4_1.log','+FRA/racdb/onlinelog/group_4_2.log')size100M;添加玩后，查看日志组sys@RACDB>selectgroup#,THREAD#,status,archived,bytes/1024/1024MBfromv$lo
8、g;GROUP#THREAD#STATUSARCHIVEDMB-------------------------------------------11CURRENTNO10021INACTIVEYES10032UNUSEDYES10042UNUSEDYES10051INACTIVEYES10061INACTIVEY
