资源描述：
《oracle调整redo日志组步骤》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。
1、本文档说明普通架构及DG架构下，调整wdo日志组大小的方法，也可作为调整redo文件位置的方法。普通架构仁创建2个新的日志组4/5SQL>alterdatabaseaddlogfilegroup4(7oradata0/redo4a」og7oradata1/redo4b」ogf)size128MB;SQL>alterdatabaseaddlogfilegroup5(7oradata1/redo5a.log7oradata2/redo5b.log')size128MB;2、确认redoFl志组状态,触发redolog归档，令group1/
2、2/3状态为非currentselectGROUP执SEQUENCE执MEMBERS,BYTES,ARCHIVED,statusfromv$log;altersystemcheckpointlocal;altersystemswitchlogfile;(多次)selectGROUP#,SEQUENCE#,MEMBERS,BYTES,ARCHIVED,statusfromv$log;3、确认group1/2/3状态为非current后,删除group1/2/3SQL>alterdatabasedroplogfilegroupl;SQL>al
3、terdatabasedroplogfilegroup2;SQL>alterdatabasedroplogfilegroup3;4、重命名redolog文件(慎用rm删除命令)selectGROUP执SEQUENCE#,MEMBERS,BYTES,ARCHIVED,statusfromv$log;mv/oradataO/redola」ogmv/oradata1/redo1b」ogmv/oradata1/redo2a」ogmv/oradata2/redo2b」ogmv/oradata2/redo3a.logmv/oradata0/redo3
4、b」og/oradataO/redola」og.bak/oradatal/redolb.log.bak/oradata1/redo2a.log.bak/oradata2/redo2b」og.bak/oradata2/redo3a」og.bak/oradata0/redo3b」og.bak5、重新创建3个新的日志组groupl/2/3SQL>alterdatabasesize128MB;SQL>alterdatabasesize128MB;SQL>alterdatabaseaddaddaddlogfilelogfilelogfilegrou
5、pgroupgroup1(7oradata1/redo1a.log',7oradata2/redo1b.log')2(7oradata2/redo2a.log,,7oradata3/redo2b.log,)3(,/oradata3/redo3a.log7/oradata1/redo3b.log,)size128MB;6、确认redoFl志组状态，触发redolog归档，令group4/5状态为非currentselectGROUP执SEQUENCE#,MEMBERS,BYTES,ARCHIVED,statusfromv$log;alter
6、systemswitchlogfile;(多次)selectGROUP#,SEQUENCE#,MEMBERS,BYTES,ARCHIVED,statusfromv$log;7^确认group4/5状态为非current后，删除group4/5SQL>alterdatabasedroplogfilegroup4;SQL>alterdatabasedroplogfilegroup5;8、操作系统物理删除redolog文件rm/oradata0/redo4a.logrm/oradata1/redo4b」ogrm/oradata1/redo5a」
7、ogrm/oradata2/redo5b.logDG架构对于搭建了DG架构的数据库，如需调整redoH志组，需要主备数据库都同时调整，涉及停止日志自动应用、对standby数据库的redo日志组进行clear操作等。Instandby备机停止日志应用SQL>ALTERDATABASERECOVERMANAGEDSTANDBYDATABASECANCEL;SQL)selectNAME,DATABASE_ROLE,SWITCHOVER_STATUSfromv$database;将STANDBY_FILE_MANAGEMENT设置为MANUAL
8、SQL)altersystemsetstandby_file_management二manual;SQL)showparameterSTANDBY_FILE_MANAGENT2、primary
