OraFAQ Forum: Server Administration » Increasing size of redolog member

Home » RDBMS Server » Server Administration » Increasing size of redolog member (Oracle 10g , Linux AS4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Increasing size of redolog member [message #302979]

Wed, 27 February 2008 08:45

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Hello All,

The size of redolog member is 12m . Can I increase the size of that member dynamically, without adding a new member to that group and dropping the old one.

Regards,
Raj

Report message to a moderator

Re: Increasing size of redolog member [message #302981 is a reply to message #302979]

Wed, 27 February 2008 08:49

varu123
Messages: 754
Registered: October 2007

Senior Member

nope,
you cannot resize the redo log files.
you could only drop and recreate them with appropriate sizes.

Report message to a moderator

Re: Increasing size of redolog member [message #302984 is a reply to message #302981]

Wed, 27 February 2008 08:53

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Are you sure about that . No I'm not doubting that . but because me boss argues with me that we can do that . Infact I told that we can't do .

Thank you

Report message to a moderator

Re: Increasing size of redolog member [message #302986 is a reply to message #302979]

Wed, 27 February 2008 08:59

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>but because me boss argues with me that we can do that .
Nothing is impossible for the person who does not have to do it.

Since your boss thinks it can be done, then ask him for actual SQL to accomplish this task.

Report message to a moderator

Re: Increasing size of redolog member [message #302987 is a reply to message #302986]

Wed, 27 February 2008 09:01

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Thanks ana , got the perfect answer , that we can't increase the size of redologs dynamically

Thanks varu

Report message to a moderator

Re: Increasing size of redolog member [message #302988 is a reply to message #302986]

Wed, 27 February 2008 09:03

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

And wait for oracle 12g Smile

Report message to a moderator

Re: Increasing size of redolog member [message #302989 is a reply to message #302979]

Wed, 27 February 2008 09:04

varu123
Messages: 754
Registered: October 2007

Senior Member

If by resize your boss mean something like:

alter database resize redo log group memeber .... size 100m;

then its not possible.

If by resizing your boss mean something like:

alter database add logfile member /../ to group #;

then its possible.

after creating new members with appropriate sizes ,drop the old ones.
alter database drop log file memeber /../ ;

Report message to a moderator

Re: Increasing size of redolog member [message #444598 is a reply to message #302989]

Mon, 22 February 2010 22:47

shiti
Messages: 1
Registered: June 2009

Junior Member

@ .. alter database add logfile member /../ to group #;

there is no option to specify size with "alter database add logfile member..." its takes size of existing member of a group.

Report message to a moderator

Re: Increasing size of redolog member [message #444600 is a reply to message #302986]

Mon, 22 February 2010 23:10

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

anacedent wrote on Wed, 27 February 2008 08:59

>but because me boss argues with me that we can do that .
Nothing is impossible for the person who does not have to do it.

Report message to a moderator

Previous Topic:	oracle 10g what is grid
Next Topic:	Patch information

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 27 01:11:35 CST 2025