This content has been marked as final. Show 20 replies
Can you share what are the sizes of your PROD redo logs? I am just curious how did you size it. I know it depends on how active is your database.Not taking into account issues of performance, size of redo logs determines the size of archive logs. This size should allow you to easy manage the archive logs - copy them to other locations, between systems, archive etc. Small size can lead to a lot of files, control file size can grow. 300 - 500 Mb is good choice.
Is it default 50Mb? or 100Mb or 200Mb or 500Mb or 1Gb.
yxes2013 wrote:good idea will be to put your production DB in archivelog mode :)
So I want to choose 500mb and make my log members 20 (total of 10g), so that It can hold all the days transactions. Just in case If I want recovery I wont needing the archive logs.
Is it a good idea?
number of redo goups is limited by MAXLOGFILES used when database was created, you can change this by creating new controlfile
Ok , the default log group is 3 right? and 1 member each.
I want to make my log group 20 with 1 member each size 1gb. How does it fare for performance? Any comments please :)
And for the sake of argument I am not turning on archiving. Because I do cold backup every night. I just want my redo logs contained all the transaction for the day.
Any problem with this kind of setup?