ALTER SYSTEM SWITCH LOGFILE

How to Resolve ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

by Ed Chen
March 10, 2023February 15, 2023

ORA-28009 Tried to connect to a database, but it failed with ORA-28009. SQL> conn sys/password@orclpdb ERROR: ORA-28009: connection as SYS should be as SYSDBA or… Read More »

How to Resolve ORA-01109: database not open

by Ed Chen
June 5, 2021June 2, 2023
2 Comments

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 »

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, 2020November 16, 2023

Move LogFile Performance Considerations 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 »

How to Resize Redo Logs in Oracle

by Ed Chen
November 2, 2018November 16, 2023
4 Comments

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 »

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 »

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