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
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
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
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
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
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