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.

DBCA Storage Configuration - Change Redo Log Size - 01

DBCA Storage Configuration - Change Redo Log Size - 01

Click on Redo Log Groups, you can change the size on all files.

DBCA Storage Configuration - Change Redo Log Size - 02

DBCA Storage Configuration - Change Redo Log Size - 02

Furthermore, you can add more group members, but be careful filename typos.

DBCA Storage Configuration - Change Redo Log Size - 03

DBCA Storage Configuration - Change Redo Log Size - 03

If the database has been created, you still have chances to do some tricks to resize the redo log files.

In silent mode of DBCA 19c, you can also resize the redo log file as you like.

Leave a Reply

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