Re: redo log file

Posted by ErmanArslansOracleBlog on Sep 01, 2016; 3:06pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/redo-log-file-tp1277p1278.html

The time to start the database is related with the "redo" and "undo".
Increasing the "redolog" file size, is someting different.
During the start database of the database, both redo and undo is used to put your database in a consistent state. So it depends on the db activity and it depends on how you shutdown your database.
For ex: If you shut down your db normally (shutdown normal), your startup should be faster.
Because, after a "shutdown normal"; no instance recovery is required on the next database startup.
So, for a fast startup, being on a consistent state is important.

Having a big redolog file  is irrelevant with the startup..
Having a big redolog file can be done for performance reasons not for a fast db startup.
However, it seems you still need to have more redolog files, as all of them are active, so your database may hang... (again not for db startup)