ALTER SYSTEM SWITCH LOGFILE
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 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 to Duplicate a 19c Physical 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
User-Managed Backup (1/4) - Offline Backup The Whole Database With NOARCHIVELOG ModeLet's switch to ARCHIVELOG mode and demonstrate the backup and restore process.Shutdown the database[oracle@primary01… Read More »User-Managed Backup (2/4) - Offline Backup The Whole Database With ARCHIVELOG Mode