V$LOG

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 Check Oracle Database Size

by Ed Chen
August 30, 2019December 10, 2022

At least two scenarios that you may need to know the database size. Server upgrade or migration You have to plan the size of storage… 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 »