Yes we did.. It's a non-issue.
We just print Yellow Pages ;) Applicaton Recovery time is not very critical.
- Kirti
- Murali_Pavuloori/Claritas_at_claritas.com wrote:
>
> Have you looked at MTTR to see if it meets the needs of the recovery
> scenarios at your site?
>
> Murali.
>
>
> |---------+-------------------------------->
> | | Kirtikumar Deshpande |
> | | <kirtikumar_deshpande|
> | | @yahoo.com> |
> | | Sent by: |
> | | ml-errors_at_fatcity.com|
> | | |
> | | |
> | | 10/17/2003 04:04 PM |
> | | Please respond to |
> | | ORACLE-L |
> | | |
> |---------+-------------------------------->
>
>
>--------------------------------------------------------------------------------------------------------------|
> |
> |
> | To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> |
> | cc:
> |
> | Subject: Re: Redo Log (Largest size used)
> |
>
>
>--------------------------------------------------------------------------------------------------------------|
>
>
>
>
> I have redo log sized to 800MB in a one of our databases. I am considering
> to double its size, as
> the application generates too much redo, due to bad application code. Even
> for one column change,
> the rest of the row gets updated with the same values.
>
> I have heard of no issues with large redo log files. I just need to make
> sure I have enough log
> groups and enough archived dest space to not affect archiving of redo
> logs..
>
> This is on AIX 5.2 with Oracle 9.2.0.4
>
> - Kirti
>
> --- Denny Koovakattu <groups_at_koovakattu.com> wrote:
> > Hi,
> >
> > Platform : HP-UX 11.11 (64bit) PA-RISC
> > Oracle : 8.1.7.4 EE (64bit)
> >
> > On a system I am looking at, during peak loads the redo logs are
> switching
> > almost every minute. The logs are currently sized at 1G. I am
> recommending the
> > redo logs be resized to a much larger value. (The largest I have had to
> use in
> > Prod. is 2G). Before we implement I want to confirm there are no
> issues/bugs I
> > should be aware of. (We would be testing it in a test environment before
> > implementing but just wanted to pick the knowledge of the collective.)
> >
> > It would also be interesting to know what's the size of the largest
> redo
> > logs being used and amount of redo being generated during peak loads.
> >
> > Thanks,
> > Denny
> > --
> > Denny Koovakattu
> >
> >
> >
> >
> > -------------------------------------------------
> > This mail sent through IMP: http://horde.org/imp/
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Denny Koovakattu
> > INET: groups_at_koovakattu.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
>
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product search
> http://shopping.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Kirtikumar Deshpande
> INET: kirtikumar_deshpande_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: Murali_Pavuloori/Claritas_at_claritas.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kirtikumar Deshpande
INET: kirtikumar_deshpande_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Oct 17 2003 - 15:39:25 CDT
