V$LOGFILE

Recreate Standby Redo Logs, How and Why?

by Ed Chen
February 11, 2022March 30, 2022

Apply Lag Increasing After initiating data guard service by broker, we saw something unusual about redo applying. DGMGRL> show database ORCLSTB Database - ORCLSTB … Read More »

How to Move Redo Log Location in Oracle

by Ed Chen
February 22, 2020October 1, 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 Move Temp File Location in Oracle

by Ed Chen
February 19, 2020September 22, 2021
2 Comments

As we have talked about how to move a whole Oracle database, it's an offline operation. Here we introduce how to change temp file location… Read More »

How to Resize Redo Logs in Oracle

by Ed Chen
November 2, 2018April 21, 2022
2 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 »