Tags » Data Guard

ORA-16157: media recovery not allowed following successful FINISH recovery

Where this error would be reported:

In physical standby

Why this error was reported ?
Before this error was reported someone have executed the below command, on physical standby… 272 more words


Corruption while applying Redo

Problem Description – We are getting following error while MRP is applying archive logs on standby side.
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 2048 change 358410026274 time 01/20/2015 11:08:11… 346 more words

Data Guard

Remote Archive



Sync –> Which means, we are making sure that standby will send acknowledge once it receives the redo. From primary once we send redo information lgwr will wait for acknowledgement, if it receive the acknowledgement then it will send the next… 314 more words


Real time apply & Active data guard

What is real time apply in oracle (data guard):
Ans: Applying the changes upto date, which means once we commit in primary it gets applied in standby… 270 more words


Recover standby database when the primary and standby are out of sync with archvies missing in primary .

Step 1 :

  1. a) Identify SCN of standby using the following query


  1. b) Last logseq# of standby

Identify the last logseq# applied on standby database using below query. 145 more words

Data Guard

optimizing Data Guard Configuration - II


In the previous part https://rajat1205sharma.wordpress.com/2015/09/12/optimizing-data-guard-configuration-i/  we have seen optimizing Data Guard configuration for few attributes and parameters for physical standby database, Now we are going to cover few more attributes which are pending, They are Redo compression, Delaying the redo to standby/remote destinations and Finally we will cover with the best practices to optimize the TCP send and receive socket buffer sizes. 2,035 more words

optimizing Data Guard Configuration - I


We all know well how easy to build standby database and configure Data Guard between Primary and Standby database(s) with predefined steps. But have you ever noticed that the current configuration is suitable to the environment? 1,984 more words