Data Guard

How to Build Asymmetric Standby Database for Data Guard

Posted on
Asymmetric Data Guard Usually we build data guard environments with the symmetric architecture design on primary and standby servers, that is, single-instance to single-instance or RAC to RAC. Practically, we could have downgraded standby servers in hardware specifications. For example, we may use 16 cores per instance on the primary side but use 8 cores […]
Data Guard

Connect-Time Failover to Standby Database

Posted on
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 Dynamic Service Name Using a SRVCTL Configured Service Using a Persistent Service Name Connect-Time Failover is a feature of local naming method, and can be easily set up by adding […]
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, […]
RMAN

How to Resolve ORA-19505 and ORA-27037 in Error Stack

Posted on
ORA-19505 with ORA-27037 When I tried to duplicate a target database to an auxiliary one by this run block. RUN {   ALLOCATE AUXILIARY CHANNEL c1 DEVICE TYPE DISK;   ALLOCATE AUXILIARY CHANNEL c2 DEVICE TYPE DISK;   ALLOCATE AUXILIARY CHANNEL c3 DEVICE TYPE DISK;   ALLOCATE AUXILIARY CHANNEL c4 DEVICE TYPE DISK;   DUPLICATE […]
TEMP

How to Resolve ORA-25153: Temporary Tablespace is Empty

Posted on
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 to use space in a temporary tablespace with no files. Action Add files to the tablespace using ADD TEMPFILE command. This is because the temporary tablespaces contain no any temp […]
Data Guard

How to Resolve ORA-16055: FAL request rejected

Posted on
In Oracle MAA, data guard plays a very important role to secure our data on the remote location. Since it involves network and interconnection between two databases, it is pretty complicated to do troubleshooting. That’s why you might see ORA-16055: FAL request rejected at times. The network problem could include host, router, firewall, LAN, VPN, […]
Data Guard

How to Resolve ORA-16826: apply service state is inconsistent with the DelayMins property

Posted on
Here was a data guard incident:DGMGRL> show database standbDatabase – standb  Role:            PHYSICAL STANDBY  Intended State:  APPLY-ON  Transport Lag:   0 seconds  Apply Lag:       2 minutes 13 seconds  Real Time Query: OFF  Instance(s):    standb1 (apply instance)    standb2  Database Warning(s):    ORA-16826: apply service state is […]