on 02-03-2007 10:16 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, please check this note: 3809
Pay attention to redolog order when you apply this note.
Cheers,
David
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Alternatively, you can refer to "Note 491160 - Restore scenarios for lost files of oracle databases" for following SAP's standard practice
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
you can use something like:
alter database
add logfile member 'redo03a.log'
to group 3;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.