ALTER SYSTEM ARCHIVE LOG CURRENT

How to Resolve ORA-02231: missing or invalid option to ALTER DATABASE

by Ed Chen
December 22, 2022December 28, 2022

ORA-02231 ORA-02231 means that a keyword is missing from the position where it should be in ALTER DATABASE statement. Most likely, it's a syntax error.… Read More »

How to Resolve ORA-16857: member disconnected from redo source for longer than specified threshold

by Ed Chen
February 4, 2022February 2, 2022

Solution Found error ORA-16857 when I checked the data guard status of data synchronization. DGMGRL> show database ORCLSTB; Database - ORCLSTB Role: … Read More »

ALTER SYSTEM SWITCH LOGFILE vs ARCHIVE LOG CURRENT

by Ed Chen
February 26, 2020October 31, 2022

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 »

How to Move Redo Log Location in Oracle

by Ed Chen
February 22, 2020July 10, 2022

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 RMAN Duplicate 19c Standby Database

by Ed Chen
August 11, 2019February 13, 2023
4 Comments

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 Build Asymmetric Standby Database for Data Guard

by Ed Chen
July 14, 2019February 13, 2023
4 Comments

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 »

ALTER SYSTEM ARCHIVE LOG CURRENT Hangs ?

by Ed Chen
December 28, 2016October 1, 2021

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 »

How to Enter BEGIN BACKUP Mode

by Ed Chen
December 27, 2016January 28, 2021

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 Perform Consistent Backups

by Ed Chen
April 30, 2016July 6, 2021

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 »

Duplicate a Standby Database (1/4) - With Active Database

by Ed Chen
January 27, 2013December 11, 2022

Duplicate a Standby Database (0/4) - An Overview For 19c Standby database duplication, you may check the post: How to Duplicate a 19c Physical Standby… Read More »

JavaScript is not enabled. Please enable it and reload the page.