Data Guard

How to Resolve ORA-16571: Oracle Data Guard configuration file creation failure

by Ed Chen
August 9, 2019December 10, 2022

ORA-16571 ORA-16571 means that DGMGRL tried to create or save broker files on the destination you designed, but somehow it failed in DGMGRL command line… 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 »

Connect-Time Failover to Standby Database

by Ed Chen
May 11, 2019September 4, 2023
10 Comments

We're going to introduce 3 ways that can failover to a standby database at connect-time in this post. Using a Persistent Service Name Using a… Read More »

How to Resolve ORA-01579 in MRP

by Ed Chen
March 17, 2019December 10, 2022

ORA-01579 in MRP After shrinking (i.e. resizing) a data file successfully, I was worry about the applying state of the standby database. Not surprisingly, I… Read More »

How to Resolve Standby ORA-00600 [3020]

by Ed Chen
November 24, 2018December 12, 2022

ORA-00600 [3020] Found MRP shutdown with ORA-00600 [3020] in alert log of a standby database due to inconsistency of a newly created data file. Wed… Read More »

DGMGRL Enable Configuration Hang

by Ed Chen
April 1, 2017October 7, 2021

At times, you may need to enable configuration or enable database to make the broker work again. $ dgmgrl / ... DGMGRL> enable configuration; If… 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 Resolve ORA-01220: file based sort illegal before database is open

by Ed Chen
October 9, 2016January 12, 2021

When I queried the archive gap on the standby database which is a 9i database, I got this error: SQL> select * from v$archive_gap; select… Read More »

Sometimes Archive Gap is Just Temporary

by Ed Chen
July 10, 2016August 5, 2020

As a DBA, you might see many gaps on the standby database in your career like this.SQL> select * from v$archive_gap; THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#---------- -------------… Read More »

How does Recovery Catalog Recognize Databases Which is Which?

by Ed Chen
May 1, 2016December 22, 2020

Normally and generally, recovery catalog recognizes the databases by DBID which is a unique number among different databases. But there's a problem: the primary database… Read More »

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