Data Guard

How to Resolve ORA-45909: restore, recover or block media recovery may be in progress

by Ed Chen
June 15, 2023June 24, 2023

ORA-45909 Tried to restore a data file by RMAN, it failed with ORA-45909, ORA-19890 and ORA-19573. RMAN> restore datafile 13; ... ORA-19870: error while restoring… 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 »

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 »

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 »

How to Start Data Guard Services

by Ed Chen
April 10, 2016August 9, 2021

Starting data guard services is actually a reverse process of stopping data guard services by any ways. Let's see how we start the services along… Read More »

How to Stop Data Guard Services

by Ed Chen
April 9, 2016December 11, 2022

Stop Data Guard Is Broker Enabled? First of all, you need to know whether the data guard broker is configured, started and controls over the… Read More »

How to Resolve ORA-01196 and ORA-01110

by Ed Chen
March 20, 2016December 12, 2022

ORA-01196 Saw errors ORA-01196 thrown by the database when trying to activate a standby database. SQL> alter database activate standby database; alter database activate standby… Read More »

How to Resolve ORA-16009: remote archive log destination must be a STANDBY database

by Ed Chen
March 22, 2015August 5, 2020

Saw an error in the alert log.... Sat Mar 21 10:28:48 2015Errors in file /oracle/admin/ORCL/bdump/orcl_arc0_9548203.trc:ORA-16009: remote archive log destination must be a STANDBY databaseThere may… Read More »

How to Resolve ORA-25153: Temporary Tablespace is Empty

by Ed Chen
March 14, 2015August 18, 2023
2 Comments

ORA-25153 After activating a physical standby database, I found some SQL statements returned ORA-25153: Description ORA-25153: Temporary Tablespace is Empty Cause An attempt was made… Read More »

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