Truncate vs Delete Entire Table
Here I compare the differences between TRUNCATE and DELETE an entire table in the following chart. Question Truncate Table Delete From DDL or DML? DDL… Read More »Truncate vs Delete Entire Table
Redo Log Files
How to Duplicate a 19c Physical Standby Database
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 Duplicate a 19c Physical Standby Database
How to Resolve ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
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 Resolve ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
How to Move Oracle Database
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 Move Oracle Database
How to Resize Redo Logs in Oracle
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 »How to Resize Redo Logs in Oracle
Where to Change Redo Logs in DBCA or OUI
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 »Where to Change Redo Logs in DBCA or OUI
When Database is Not Consistent
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 »When Database is Not Consistent
How to Determine Archived Log Size
Archived Log Size Before determining archived log size, you have to know that archived logs are derived (retired) from online redo logs switching. That is,… Read More »How to Determine Archived Log Size
When Redo Log Files Are All Missing
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 »When Redo Log Files Are All Missing