How to Resolve ORA-01109: database not open
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
ALTER SYSTEM SWITCH LOGFILE vs ARCHIVE LOG CURRENT
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
How to Move Redo Log Location in Oracle
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
How RMAN Duplicate 19c 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 RMAN Duplicate 19c 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
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 »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