ORA-01109 ORA-01109 is pretty normal when the database you want to connect or operate with is at MOUNT or NOMOUNT state. In this post, we… Read More »How to Resolve ORA-01109: database not open
ALTER SYSTEM SWITCH LOGFILE
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 »ALTER SYSTEM SWITCH LOGFILE vs ARCHIVE LOG CURRENT
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 Move Redo Log Location in Oracle
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 RMAN Duplicate 19c Standby Database
Asymmetric Data Guard Usually we build data guard environments with the symmetric architecture design on primary and standby servers, that is, single-instance to single-instance or… Read More »How to Build Asymmetric Standby Database for Data Guard
Since ALTER SYSTEM ARCHIVE LOG CURRENT is a synchronized fashion of switching redo logs, it has to synchronize the archive log completely to all archive… Read More »ALTER SYSTEM ARCHIVE LOG CURRENT Hangs ?
User-Managed Backup (2/4) - Offline Backup The Whole Database With ARCHIVELOG ModeTo backup all datafiles online with user-managed mode, you can force the all datafiles… Read More »User-Managed Backup (3/4) - Online Backup All Datafiles