Re: Resize redo logs

r406 wrote:
>
> Hi,
> I'm running Oracle 8i. I have 2 redo log groups (1 & 2), 2
> members each. Each member (.log file) is 500k, I want to
> increase them to 5m each. Since members in a group must be the
> same size, is there any easier way to do this other than create
> a group 3 & 4, drop groups 1 & 2, recreate 1 & 2, then drop 3 &
> 4? Thanks.
>
> -r
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!

You can build a new create controlfile command and then open the database with a RESETLOGS (after a clean shutdown).

You can decide whether that is less or more effort that just dropping the old ones and adding new ones...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse