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
Data Guard
DGMGRL Enable Configuration Hang
At times, you may need to enable configuration or enable database to make the broker work again. $ dgmgrl / ... DGMGRL> enable configuration; If… Read More »DGMGRL Enable Configuration Hang
Sometimes Archive Gap is Just Temporary
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
How does Recovery Catalog Recognize Databases Which is Which?
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?
How to Start Data Guard Services
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 Start Data Guard Services
How to Stop Data Guard Services
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 Stop Data Guard Services
How to Resolve ORA-01196 and ORA-01110
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-01196 and ORA-01110
How to Resolve ORA-16009: remote archive log destination must be a STANDBY database
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
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 RMAN List Backup in Standby DB
Recently, I created a controlfile for standby database in the primary database. After I mounted the newly created controlfile in the standby database. I tested… Read More »How RMAN List Backup in Standby DB