cancel
Showing results for 
Search instead for 
Did you mean: 

How to Change the Redolog File size

Former Member
0 Kudos

Hi,

i want increase the "Redo log" File size from 50 MB to 75 MB.

pl. tell me the steps involved.

we r using SAP ECC 5.0, Oracle 9.2.0.6 on AIX 5.3

SAP has recommended to increase the Redo log File size to 75MB.

presently g11, g12, g13, g14 groups are using.

thanks in advance.

Rama Koteswara Rao

Accepted Solutions (0)

Answers (7)

Answers (7)

vince_laurent
Active Participant
0 Kudos

Wow. Do you want all the gory details/commands? It is 6 pages of my Enterprise DBA course book. Let me know and I could type it up.

Former Member
0 Kudos

Hi Vince,

Can you please paste is or 6 pages means.. can mail to venki_nw@yahoo.co.in

I am also in need of it now.

Thanks.

Former Member
0 Kudos

Hi Vince,

Can you please paste to my email id punit.maini&gmail.com

Thanks in Advance

Punit Maini

Former Member
0 Kudos

Hi, please check this note: 3809

Pay attention to redolog order when you apply this note.

Cheers,

David

Former Member
0 Kudos

Hi

#1 Make each redolog group in OFFLINE mode and extnd the size

#2 If a particular offline log group is active, forcibly switch to other log group and then convert to OFFLINE mode and make changes..

#3 After extnd each redo log group, make it ONLINE.

Regards

Madhu

Former Member
0 Kudos

Alternatively, you can refer to "Note 491160 - Restore scenarios for lost files of oracle databases" for following SAP's standard practice

Former Member
0 Kudos

Hello Rama,

The best & easy method to change the redolog size is:

1. Backup the controlfile to trace

2. Shutdown SAP & Database

3. Edit the size of the redolog files in the trace file.

And Delete the unwanted / repeated portion of the trace file

(Do this with caution, cross check again)

4. Save the trace file with .sql extention

5. Move the Mirrlog* & Origlog* to different location

6. Move the existing controlfile to different location

7. Create the controlfile by executing the .sql script.

New control file will be created with new Mirrlog* and Origlog* files

thus, redo log size is changed.

Regards,

Ammey Kesarkar

Former Member
0 Kudos

Create a new group and add more log members to it:

ALTER DATABASE

ADD LOGFILE GROUP 10 ('/oracle/dbs/log1c.rdo', '/oracle/dbs/log2c.rdo')

SIZE 500K;

former_member185954
Active Contributor
0 Kudos

Hi,

you can use something like:

alter database

add logfile member 'redo03a.log'

to group 3;