Redo Log File

How to Resolve ORA-32589: unable to drop minimal supplemental logging

by Ed Chen
December 9, 2022November 7, 2022

ORA-32589 Tried to drop the minimal supplemental logging from the database, but it failed with ORA-32589. SQL> alter database drop supplemental log data; alter database… Read More »

How to Resolve ORA-31541: Supplemental logging is not enabled in CDB$ROOT.

by Ed Chen
December 8, 2022November 7, 2022

ORA-31541 Tried to enable flashback transaction query starting from adding minimal supplemental logs, but it failed with ORA-31541. SQL> alter database add supplemental log data;… Read More »

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, 2018March 21, 2023
4 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 »