Standby Database

How to Resolve ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

by Ed Chen
November 19, 2021June 13, 2023

ORA-01610 Tried to perform RECOVER DATABASE on a mounted database by SQL statement, but it failed with ORA-01610. SQL> recover database until cancel; ORA-00283: recovery… 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 »

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 »

How to Resolve ORA-19505: failed to identify file

by Ed Chen
March 11, 2017November 5, 2021
2 Comments

ORA-19505 There're two error patterns of ORA-19505 in this post. Cloning a PDB Duplicating a Database 1. Cloning a PDB Tried to clone a Pluggable… Read More »

How to Interrupt "Recover Standby Database" with AUTO Enabled

by Ed Chen
May 2, 2015March 26, 2018

RECOVER STANDBY DATABASE is also call manual recovery of standby database, it has the same effect with RECOVER STANDBY DATABASE UNTIL CANCEL. You can set AUTO to… 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 »

How to Resolve ORA-16055: FAL request rejected

by Ed Chen
January 17, 2014June 24, 2023
3 Comments

In Oracle MAA, data guard plays a very important role to secure our data on the remote location. Since it involves network and interconnection between… Read More »

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