oracle调整redo日志组步骤.doc

本文档说明普通架构及DG架构下，调整redo日志组大小的方法，也可作为调整redo文件位置的方法。 普通架构 1、创建2个新的日志组4/5??????????????????????????????????????????????????????????????????????SQL alter database add logfile group 4(/oradata0/redo4a.log,/oradata1/redo4b.log)size 128MB;???SQL alter database add logfile group 5(/oradata1/redo5a.log,/oradata2/redo5b.log)size 128MB;?2、确认redo日志组状态，触发redolog归档，令group1/2/3状态为非current???selectGROUP#,SEQUENCE#,MEMBERS,BYTES,ARCHIVED,status from v$log;???alter system checkpoint local;???????????????????????????????????????????????????????????????alter system switch logfile;(多次)?????????????????????????????????????????????????????????????????selectGROUP#,SEQUENCE#,MEMBERS,BYTES,ARCHIVED,status from v$log;????????3、确认group1/2/3状态为非current后，删除group1/2/3??SQL alter database drop logfile group1;?SQL alter database drop logfile group2;?SQL alter database drop logfile group3;?????4、重命名redo log文件?（慎用rm删除命令）????????????????????????????????????????????????????????????????selectGROUP#,SEQUENCE#,MEMBERS,BYTES,ARCHIVED,status from v$log;??????mv /oradata0/redo1a.log?????? /oradata0/redo1a.log.bak??mv /oradata1/redo1b.log?????? /oradata1/redo1b.log.bak??mv /oradata1/redo2a.log?????? /oradata1/redo2a.log.bak?mv /oradata2/redo2b.log?????? /oradata2/redo2b.log.bak?mv /oradata2/redo3a.log?????? /oradata2/redo3a.log.bak?mv /oradata0/redo3b.log?????? /oradata0/redo3b.log.bak????5、重新创建3个新的日志组group1/2/3??????????????????????????????????????????????????????????????????SQL alter database add logfile group 1(/oradata1/redo1a.log,/oradata2/redo1b.log) size 128MB;?SQL alter database add logfile group 2(/oradata2/redo2a.log,/oradata3/redo2b.log) size 128MB;?SQL alter database add logfile group 3(/oradata3/redo3a.log,/oradata1/redo3b.log) size 128MB;?6、确认redo日志组状态，触发redolog归档，令group4/5状态为非current???selectGROUP#,SEQUENCE#,MEMBERS,BYTES,ARCHIVED,status from v$log;???alter system switch logfile;(多次)?selectGROUP#,SEQUENCE#,MEMBERS,BYTES,ARCHIVED,status from v$log;??7、确认group4/5状态为非cur