Redo Log File

How to Resolve ORA-15005: name is already used by an existing alias

by Ed Chen
February 9, 2022February 11, 2022

ORA-15005 ORA-15005 means that there's already a file with the same name existing in the same path. Therefore, Oracle cannot create the file for you.… Read More »

How to Resolve ORA-27038: created file already exists

by Ed Chen
December 29, 2021May 18, 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/ORCLCDB/ORCLPDB/example03.dbf' size 10m autoextend… Read More »

Alter Database Add Logfile Correctly

by Ed Chen
October 8, 2021April 1, 2022

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, 2021April 21, 2022

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

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 »

ALTER SYSTEM SWITCH LOGFILE vs ARCHIVE LOG CURRENT

by Ed Chen
February 26, 2020October 31, 2022

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

by Ed Chen
November 2, 2018October 29, 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 »

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, 2016August 30, 2022

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 »