SWITCH LOGFILE vs ARCHIVE LOG CURRENT
Same Results Both ALTER SYSTEM SWITCH LOGFILE and ALTER SYSTEM ARCHIVE LOG CURRENT force Log Writer process (LGWR) switch to the next redo log group… Read More »SWITCH LOGFILE vs ARCHIVE LOG CURRENT
ALTER SYSTEM SWITCH LOGFILE
How to Move Redo Log Location in Oracle
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
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 Build Asymmetric Standby Database for Data Guard
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
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
ALTER SYSTEM ARCHIVE LOG CURRENT Hangs ?
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 ?
How to Enter BEGIN BACKUP Mode
ALTER DATABASE BEGIN BACKUP From Oracle 10g onward, you can make the whole database enter BEGIN BACKUP mode in one statement in order to get… Read More »How to Enter BEGIN BACKUP Mode
How to Perform Consistent Backups
It depends, depends on what kind of backup mode that you had taken. If you took a full backup by the following ways, then you… Read More »How to Perform Consistent Backups
User-Managed Backup (3/4) - Online Backup All Datafiles
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 (2/4) - Offline Backup The Whole Database With ARCHIVELOG Mode
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