Skip to Content
avatar image
Former Member

Increase Redo Logs

Hi All

Can any one let me know how to increase the Redo Log in SAP R/3 on Oracle.

V are getting warning as "Checkpoint not complete" and when i searced note - 79341 it says to increase the size of redo logs,

Kindly let how to increase Redo Logs.

Regards!!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Sep 23, 2008 at 09:25 AM

    Hello,

    just check the sapnote #309526

    Regards

    Stefan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Online redo log files should be set up according to the following rules:

      1. Avoid log switches with a frequency lower than one minute.

      2. Always set up the online redo log files with the same size.

      3. Switch on Oracle mirroring.

      Refer SAP Note 309526.

      Note: Setting up Oracle mirroring may slightly degrade the performance of database commit times, but you should implement it to avoid major problems caused by corruption or loss of an online redo log file. To keep performance degradation to a minimum, store the online redo log files on disks without any other major I/O load.

      Minimal size of Online Redo Log Files in bytes If currently its 52428800, then

      go till 100MB if log switches are happening frequently.

  • Sep 23, 2008 at 09:13 PM

    What is the Oracle Version you have?

    If you have 10g you can do all changes graphically using the Oracle Enterprise Manager, it is pretty easy to do it from there and you can switch and watch wich one is working in that moment.

    Edited by: Alberto Castillo on Sep 23, 2008 11:13 PM

    Add comment
    10|10000 characters needed characters exceeded