Saturday 2 April 2016

How to work on Gap Resolution in Dataguard

If we have a gap in Dataguard... it doesnt mean that without thinking anything, we will start to rebuild the standby again..

First of all, we have to see why the gap came, there is 2 type of issue occur, 
firstly the archive are not shipping to standby, or after shipping, it is not applying to standby, so first you need to check are they shipped or not, if they are not shipping , check the error in the alertlog of primary or v$archive_dest_
status, through which you can all the info easily, if there is a eror of pasword file, thus archives are not shipping, you just SCP that  "password file" to standby and rename it..through the above view you will get all the info, why the gap occured, what is the actual reason behind it, first correct that error, then according to need take the incremental or full and build the standby

No comments:

Post a Comment