Re: Changing size of redo logs
Date: 1996/09/11
Message-ID: <517jjt$qqt_at_news.istar.ca>#1/1
Oracle organizes redo logs by group. The information is available in the V$LOGFILE dictionary view.
You need to have equally sized members in each redo log group, and the same number of members ine ach group. Look in the Server Admin guide for how to add two or more groups with larger members, then drop the existing groups with the members that you find too small.
It's all in the Server Admin Guide.
Michael
yimfam_at_pc.jaring.my (B. Yim) wrote:
>I have a database with rather small redo logs. Now the number of
>transactions are tripled and I need to increase the size of the redo
>logs so as not to generate so many archive logs.
>Is there any way to do this, especially without shutting down the
>database.
>TIA
Received on Wed Sep 11 1996 - 00:00:00 CEST