ALTER SYSTEM CHECKPOINT

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

by Ed Chen
February 27, 2021May 19, 2022

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 »

How to Move Redo Log Location in Oracle

by Ed Chen
February 22, 2020July 10, 2022

Rename Redo Log File To improve overall performance, sometimes, we may consider to move redo logs to the location with faster disks, like Solid-State Drive… Read More »

How to Resize Redo Logs in Oracle

by Ed Chen
November 2, 2018March 21, 2023
4 Comments

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