Where to Change Redo Logs in DBCA or OUI

  • by

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.

After creation of a database, you have to do some tricks to resize the redo log files.

Leave a Reply

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