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
At times, you may need to enable configuration or enable database to make the broker work again.$ dgmgrl /...DGMGRL> enable configuration;If you were waiting for… Read More »Are You Still Waiting for the Completion of "enable configuration"
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 »Sometimes Archive Gap is Just Temporary
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 does Recovery Catalog Recognize Databases Which is Which?
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-16009: remote archive log destination must be a STANDBY database
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
The answer is definite. Today I created a controlfile for standby database in the primary database. After I mounted the newly created controlfile in the… Read More »Will Newly Created Standby Controlfile Contain Backup Records of Primary Database?