How RMAN Duplicate 19c Standby Database
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 RMAN Duplicate 19c Standby Database
Standby Database
How to Build Asymmetric Standby Database for Data Guard
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 Build Asymmetric Standby Database for Data Guard
Connect-Time Failover to Standby Database
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 »Connect-Time Failover to Standby Database
How to Resolve ORA-01579 in MRP
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 ORA-01579 in MRP
How to Resolve Standby ORA-00600 [3020]
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 Standby ORA-00600 [3020]
How to Resolve ORA-19505: failed to identify file
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 Resolve ORA-19505: failed to identify file
How to Interrupt "Recover Standby Database" with AUTO Enabled
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 Interrupt "Recover Standby Database" with AUTO Enabled
How to Resolve ORA-25153: Temporary Tablespace is Empty
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-25153: Temporary Tablespace is Empty
How to Resolve ORA-16055: FAL request rejected
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 »How to Resolve ORA-16055: FAL request rejected
How to Resolve ORA-16826: apply service state is inconsistent with the DelayMins property
Here was a data guard incident: DGMGRL> show database standb Database - standb Role: PHYSICAL STANDBY Intended State:… Read More »How to Resolve ORA-16826: apply service state is inconsistent with the DelayMins property