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"
Since ALTER SYSTEM ARCHIVE LOG CURRENT is a synchronized fashion of switching redo logs, it has to synchronize the archive log completely to all archive log… Read More »ALTER SYSTEM ARCHIVE LOG CURRENT Hangs ?
ORA-01017 in RMAN Duplication Before troubleshooting error ORA-01017, please make sure that every portion of connection string that you provided is correct. I tried to… Read More »How to Resolve ORA-01017 in RMAN Duplication
When I queried the archive gap on the standby database which is a 9i in the morning, I got this error:SQL> select * from v$archive_gap;select… Read More »How to Resolve ORA-01220: file based sort illegal before database is open
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