Redo Log File

How to Resolve ORA-01624: log needed for crash recovery of instance

by Ed Chen
February 27, 2021September 22, 2021

ORA-01624 ORA-01624 means that the redo log group that you want to operate with is needed for recovery once the database startup after a crash.… Read More »

SWITCH LOGFILE vs ARCHIVE LOG CURRENT

by Ed Chen
February 26, 2020September 22, 2021

Same Results Both ALTER SYSTEM SWITCH LOGFILE and ALTER SYSTEM ARCHIVE LOG CURRENT force Log Writer process (LGWR) switch to the next redo log group… Read More »

How to Move Redo Log Location in Oracle

by Ed Chen
February 22, 2020September 19, 2021

To improve overall performance, sometimes, we may consider to move redo logs to the location with faster disks, like Solid-State Drive (SSD). Once you decide… Read More »

How to Resize Redo Logs in Oracle

by Ed Chen
November 2, 2018September 22, 2021
2 Comments

Resize Redo Logs The default size of redo logs during installation is 50MB which is too small for production databases. Of course, you can change… Read More »

Where to Change Redo Logs in DBCA or OUI

by Ed Chen
May 7, 2017January 18, 2021

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… Read More »

How to Check Archive Log Size

by Ed Chen
June 30, 2016July 6, 2021

In this post, I will talked about the following 3 topics. How to Define Archive Log Size? Are all Archive Logs the Same Size? How… Read More »

When Redo Log Files Are All Missing

by Ed Chen
April 13, 2016October 2, 2019

If your redo logs are all missing, then you have to know you will lose some data and no longer to recover it. Now let's… Read More »