Re: Re: redo logs
- From: Andy Klock <andy@xxxxxxxxxxxxxxx>
- To: daniel.fink@xxxxxxxxxxxxxx
- Date: Fri, 12 Nov 2010 16:22:39 -0500
To alleviate the other 0.58%, you are correct.
Size directly relates to the redo log groups so when adding a new member it
will be created with the size defined for the group. It's syntactically
impossible to inadvertently add a member of a different size.
On Fri, Nov 12, 2010 at 4:01 PM, Daniel Fink <daniel.fink@xxxxxxxxxxxxxx>wrote:
> I'm 99.42% certain that all the logs in a log group must be the same size.
> My play database is misbehaving today, so I can't test it out. Logically
> having logs of different sizes in a group makes no sense as the log switch
> has to occur at the group level (all logs must switch at the same time), so
> you would be constrained by the smallest log in the group anyway.
> You can have different sized logs across groups, which enables you to add
> larger/smaller logs to the database.
>
> Oracle should not let you drop a log/log group that is either active or not
> archived (if you are archiving)
>
> ------- Original Message -------
>
> On 11/12/2010 8:19 PM Don Seiler wrote:
> Specifically it might be better to create new log GROUPS with bigger logs,
> then do log switches until the old log groups are no longer active and then
> drop them. I'm not sure if it is even possible to add log files of
> different
> sizes to existing groups, but I wouldn't do it anyway.
>
> Don.
>
> On Fri, Nov 12, 2010 at 2:15 PM, <paul.baumgartel@xxxxxxx> wrote:
>
> The latter.
>>
>>
>> *Paul Baumgartel*
>> UBS AG
>> IB Accounting Solutions
>> 400 Atlantic Street
>> Stamford, CT 06904
>>
>> 203.719.4368
>>
>> paul.baumgartel@xxxxxxx
>> www.ubs.com
>>
>>
>> ------------------------------
>> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
>> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Zelli, Brian
>> *Sent:* Friday, November 12, 2010 3:10 PM
>> *To:* oracle-l-freelists
>> *Subject:* redo logs
>>
>> Ok, really lazy question. Can I resize redo log files in 10g? Or do I
>> have to create more that are bigger and drop the smaller ones?
>>
>>
>> ciao,
>>
>> Brian
>>
>>
>>
>>
>>
>> This email message may contain legally privileged and/or confidential
>> information. If you are not the intended recipient(s), or the employee or
>> agent responsible for the delivery of this message to the intended
>> recipient(s), you are hereby notified that any disclosure, copying,
>> distribution, or use of this email message is prohibited. If you have
>> received this message in error, please notify the sender immediately by
>> e-mail and delete this email message from your computer. Thank you.
>>
>> Visit our website at http://www.ubs.com
>>
>> This message contains confidential information and is intended only
>> for the individual named. If you are not the named addressee you
>> should not disseminate, distribute or copy this e-mail. Please
>> notify the sender immediately by e-mail if you have received this
>> e-mail by mistake and delete this e-mail from your system.
>>
>> E-mails are not encrypted and cannot be guaranteed to be secure or
>> error-free as information could be intercepted, corrupted, lost,
>> destroyed, arrive late or incomplete, or contain viruses. The sender
>> therefore does not accept liability for any errors or omissions in the
>> contents of this message which arise as a result of e-mail transmission.
>> If verification is required please request a hard-copy version. This
>> message is provided for informational purposes and should not be
>> construed as a solicitation or offer to buy or sell any securities
>> or related financial instruments.
>>
>>
>> UBS reserves the right to retain all messages. Messages are protected
>> and accessed only in legally justified cases.
>>
>>
>
>
> --
> Don Seiler
> http://seilerwerks.wordpress.com
> ultimate: http://www.mufc.us
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
