How RMAN Duplicate 19c Standby Databaseby Ed ChenAugust 11, 2019February 13, 20234 CommentsYou 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
How to Build Asymmetric Standby Database for Data Guardby Ed ChenJuly 14, 2019February 13, 20234 CommentsAsymmetric 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 Databaseby Ed ChenMay 11, 2019January 29, 20218 CommentsWe'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 MRPby Ed ChenMarch 17, 2019December 10, 2022ORA-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]by Ed ChenNovember 24, 2018December 12, 2022ORA-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 fileby Ed ChenMarch 11, 2017November 5, 20212 CommentsORA-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 Enabledby Ed ChenMay 2, 2015March 26, 2018RECOVER 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 Emptyby Ed ChenMarch 14, 2015March 20, 20232 CommentsORA-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 rejectedby Ed ChenJanuary 17, 2014December 11, 20223 CommentsIn 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 propertyby Ed ChenApril 3, 2013January 18, 2021Here 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