Drop Standby Redo Log, How and Why?
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 »Drop Standby Redo Log, How and Why?
V$LOGFILE
How to Move Redo Log Location in Oracle
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 Move Redo Log Location in Oracle
How to Move Temp File Location in Oracle
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 Move Temp File Location in Oracle
How to Resize Redo Logs in Oracle
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 »How to Resize Redo Logs in Oracle