Home » RDBMS Server » Server Administration » Increasing size of redolog member (Oracle 10g , Linux AS4)
Increasing size of redolog member [message #302979] Wed, 27 February 2008 08:45 Go to next message
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
Re: Increasing size of redolog member [message #302981 is a reply to message #302979] Wed, 27 February 2008 08:49 Go to previous messageGo to next message
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.
Re: Increasing size of redolog member [message #302984 is a reply to message #302981] Wed, 27 February 2008 08:53 Go to previous messageGo to next message
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
Re: Increasing size of redolog member [message #302986 is a reply to message #302979] Wed, 27 February 2008 08:59 Go to previous messageGo to next message
BlackSwan
Messages: 25036
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.
Re: Increasing size of redolog member [message #302987 is a reply to message #302986] Wed, 27 February 2008 09:01 Go to previous messageGo to next message
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
Re: Increasing size of redolog member [message #302988 is a reply to message #302986] Wed, 27 February 2008 09:03 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

And wait for oracle 12g Smile
Re: Increasing size of redolog member [message #302989 is a reply to message #302979] Wed, 27 February 2008 09:04 Go to previous messageGo to next message
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 /../ ;
Re: Increasing size of redolog member [message #444598 is a reply to message #302989] Mon, 22 February 2010 22:47 Go to previous messageGo to next message
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.

Re: Increasing size of redolog member [message #444600 is a reply to message #302986] Mon, 22 February 2010 23:10 Go to previous message
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.


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


Current Time: Sun Dec 04 02:56:40 CST 2016

Total time taken to generate the page: 0.10663 seconds