Data Guard

How to Resolve Standby ORA-00600 [3020]

Posted on
ORA-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 Nov 21 18:32:12 2018 Errors in file /oracle/admin/ORCL/bdump/orcl_mrp0_4589393.trc: ORA-00600: internal error code, arguments: [3020], [1786773511], [1], [37836], [320123], [72], [], [] ORA-10567: Redo is inconsistent with data block (file# 854, […]
Data Guard

ALTER SYSTEM ARCHIVE LOG CURRENT Hangs ?

Posted on
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 destinations including standby databases before returning the prompt to you. It could seem dead, but actually, the background process is transporting the archived log to standbys.If any one of the […]
Data Guard

Sometimes Archive Gap is Just Temporary

Posted on
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#———- ————- ————–         1        113187         113187Just don’t rush to take some actions on archived logs, we can check the arrival of the […]
Data Guard

How to Start Data Guard Services

Posted on
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 the same route of stopping.With the brokerEnable apply service of the standby database.DGMGRL> EDIT DATABASE ‘standby_db’ SET STATE=’APPLY-ON’;Succeeded.Enable transport service of the primary database.DGMGRL> EDIT DATABASE ‘primary_db’ SET STATE=’TRANSPORT-ON’;Succeeded.Without the brokerStart […]
Data Guard

How to Stop Data Guard Services

Posted on
First of all, you need to know whether the broker is started and controls over the data guard.SQL> show parameter dg_broker_startNAME                                 TYPE        VALUE———————————— ———– ——————————dg_broker_start                      boolean […]
Data Guard

How to Resolve ORA-01196 and ORA-01110

Posted on
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 database * ERROR at line 1: ORA-01196: file 1 is inconsistent due to a failed media recovery session ORA-01110: data file 1: ‘+data/system.243.34698032′ Generally, if we’d like to open the […]