Redo Log File

How to Resolve ORA-27038: created file already exists

by Ed Chen
December 29, 2021January 13, 2022

ORA-27038 Tried to add a data file to a tablespace, but it failed with ORA-27038. SQL> alter tablespace example add datafile '/u01/app/oracle/oradata/ORA19C1/ORCLPDB1/example03.dbf' size 10m autoextend… Read More »

Correctly Alter Database Add Logfile

by Ed Chen
October 8, 2021December 3, 2021

ALTER DATABASE ADD LOGFILE clause has two different functions, one is to add a new member to an existing group, the other is to create… Read More »

How to Resolve ORA-00357: too many members

by Ed Chen
October 6, 2021October 7, 2021

ORA-00357 Tried to add more member to an existing group, but it failed with ORA-00357. SQL> alter database add logfile member '+DATA/ORCLCDB/redo01g.log' to group 1;… Read More »

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

by Ed Chen
February 27, 2021September 22, 2021

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 »

SWITCH LOGFILE vs ARCHIVE LOG CURRENT

by Ed Chen
February 26, 2020September 22, 2021

Same Results Both ALTER SYSTEM SWITCH LOGFILE and ALTER SYSTEM ARCHIVE LOG CURRENT force Log Writer process (LGWR) switch to the next redo log group… 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 Resize Redo Logs in Oracle

by Ed Chen
November 2, 2018October 1, 2021
2 Comments

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

Where to Change Redo Logs in DBCA or OUI

by Ed Chen
May 7, 2017January 18, 2021

The default size of redo log files is 50MB during database creation. It could be too small for databases with high volume transactions to switch… Read More »

How to Check Archive Log Size

by Ed Chen
June 30, 2016December 31, 2021

In this post, I will talked about the following 3 topics. How to Define Archive Log Size? Are all Archive Logs the Same Size? How… Read More »

When Redo Log Files Are All Missing

by Ed Chen
April 13, 2016October 2, 2019

If your redo logs are all missing, then you have to know you will lose some data and no longer to recover it. Now let's… Read More »