Redo Log Files

How to Resolve ORA-01156: recovery or flashback in progress may need access to files

by Ed Chen
November 29, 2021December 2, 2021

ORA-01156 Tried to add a standby log file to a database, but it failed with ORA-01156. SQL> alter database add standby logfile thread 1 group… Read More »

Truncate vs Delete

by Ed Chen
May 27, 2020September 20, 2021

Truncate vs Delete Here I compare the differences between TRUNCATE and DELETE an entire table in the following chart. Question Truncate Table Delete From DDL… 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 RMAN Duplicate 19c Standby Database

by Ed Chen
August 11, 2019October 10, 2021
4 Comments

You don't have to create an empty database on the standby server for building a standby database. In this post, I will show you how… Read More »

How to Resolve ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

by Ed Chen
April 17, 2019March 15, 2022
2 Comments

Found ORA-19602 When I tried to backup a NOARCHIVELOG database in MOUNT state, I got ORA-19602 like the following case: RMAN> startup mount; ... RMAN>… Read More »

How to Move Oracle Database

by Ed Chen
January 23, 2019October 3, 2021

Actually, this topic "How to Move Oracle Database" follows my previous post: How to Move ORACLE HOME. But I think it can be used in… Read More »

How to Resize Redo Logs in Oracle

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

When Database is Not Consistent

by Ed Chen
October 2, 2016January 16, 2021

There are several different kinds of situation when you recover a database with inconsistent states among files. In the following, I have to assume that… Read More »

How to Check Archive Log Size

by Ed Chen
June 30, 2016June 10, 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 »