Data Guard

How to Resolve ORA-01579 in MRP

Posted on
ORA-01579 in MRP After shrinking (i.e. resizing) a data file successfully, I was worry about the applying state of the standby database. Not surprisingly, I found ORA-01579: write error occurred during recovery in Managed Recovery Process (MRP) log. oracle@boston>tail -f orcl_mrp0_23309410.trc … *** 2019-03-15 08:51:13.521 Media Recovery Log /oradata/ORCL/ARCH/ORCL_1_342376.arc *** 2019-03-15 09:02:01.230 Media Recovery Log […]
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
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 data guard. SQL> show parameter dg_broker_start NAME                                 TYPE        VALUE ———————————— ———– […]