Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Increase redo log size

Beauty_and_dBestMay 19 2017 — edited May 19 2017

Hi ALL,

11gR2

OL6

Our database is frequently doing redo log switch every 2 minutes. the current redo logs size is 50M.

I want to increase it to 500M each. But I am afraid I might mess up our PROD db if I drop the old small redo.

I understand you can not mix redo logs of  different sizes as in 50M and 500M?

Please share me the right steps/docs on how to drop the smaller redo logs.

Kind regards,

jc

This post has been answered by Andy Klock on May 19 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 16 2017
Added on May 19 2017
5 comments
806 views