Installation and UpgradeRedo Log File

Where to Change Redo Logs in DBCA or OUI

The default size of redo log files is 50MB during database creation. It could be too small for databases with high volume transactions to switch logs smoothly. If IO capacity of the database server was not good enough, you may see that the database crashed with ORA-00494.

Someone asked me that where to change the size of redo logs in DBCA. I took the screenshot as an example to show you the location.

In step 11 of 15, you can see an option button “Customize Storage Locations” in left-bottom.

Click on Redo Log Groups, you can change the size on all files.
 Furthermore, you can add more group members, but be careful filename typos.

Leave a Reply

Your email address will not be published. Required fields are marked *