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
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
Since ALTER SYSTEM ARCHIVE LOG CURRENT is a synchronized fashion of switching redo logs, it has to synchronize the archive log completely to all archive… Read More »ALTER SYSTEM ARCHIVE LOG CURRENT Hangs ?
ALTER DATABASE BEGIN BACKUP From Oracle 10g onward, you can make the whole database enter BEGIN BACKUP mode in one statement in order to get… Read More »How to Enter BEGIN BACKUP Mode