Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: changing redo log file size ?

Re: changing redo log file size ?

From: HansF <news.hans_at_telus.net>
Date: Sat, 23 Oct 2004 16:39:48 GMT
Message-ID: <oPved.32333$_u6.21292@edtnps89>


vertigo wrote:

> hello
> is it possible to change redo log file size ?
> If yes how ?
>

Yes and no ....

You can not change the size of any existing redo log. You can however create new ones at the desired new size and then drop any 'old' ones that are not in use (aka current).

Remember to consider the multiplexing/grouping when doing any maintenance like this. And there may be archive log & backup space considerations.

/Hans Received on Sat Oct 23 2004 - 11:39:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US