Increase Redo Logs

[Former Member]

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!!

[stefan_koehler · Accepted solution]

Hello,

just check the sapnote #309526

Regards

Stefan

[Santanu · Accepted solution]

Hi

I have a query regrding the same . The note 309526 suggest the follwong command to add logfile :

alter database add logfile group 11

('/oracle/<SID>/origloga/log_g11_m1.dbf',

'/oracle/<SID>/mirrloga/log_g11_m2.dbf') size 50M;

I beleive this is a SQL command . I just want to confirm whethere the physical logfiles need to be created from OS manually or this SQL will create the same automatically.

Thanks

Santanu Haoladar

[Former Member · Accepted solution]

Hi,

In SAP note 309526 it's explained already that

SQL creates log file group 11 with two members of the size 50MB

after creating new redo log file you must have to delete the old one.

regards,

kaushal

[Former Member · Accepted solution]

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.

[Former Member]

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