Step by Step "Resolving Gaps in Data Guard Apply Using Incremental RMAN BAckup"

REM: Step by Step "Resolving Gaps in Data Guard Apply Using Incremental RMAN BAckup"
REM: Written By: Hayat Mohammad Khan, SM App&DB
REM: Dated: 07-JAN-2014
REM: Envrionment Used: Laptops, 11g R2 using Windows 7

Run at Primary:
select current_scn from v$database;

assume:1447102
---Maji PR>4393776



Run at Secondary:
select current_scn from v$database;

assume:1301571
---Hay DR>4390455


Run at Primary:
select scn_to_timestamp(1447102) from dual;

Run at Secondary:
select scn_to_timestamp(1301571) from dual;


Run at Secondary:
alter database recover managed standby database cancel;

shutdown immediate;


Run at Primary:

--DR site SCN 1301571
--Hay SCN: 439045

RMAN>
run {
allocate channel c1 type disk format 'E:\app\DBarchivedest\%U.rmb';
backup incremental from scn 439045 database;
}


sql>alter database create standby controlfile as '/u01/oraback/DEL1_standby.ctl';
Actual Command:sql>alter database create standby controlfile as 'E:\app\DBarchivedest\CONTROLFILE01.CTL';



Copy both Backup and Controlfile to Secondary site using OS Commands


Run at Secondary:
sql>startup nomount;


>>Replace the controlfile with the one you just created in primary.


sql>alter database mount standby database;

rman target /

-- backup taken at PR Site path
rman>catalog start with '/u01/oraback';

ActualCommand: rman>catalog start with 'E:\app\DBarchivedest';

Do you really want to catalog the above files (enter YES or NO)? yes


rman> recover database;

alter database recover managed standby database disconnect from session;


Run at both sides to verify:

select current_scn from v$database;



For complete Reading:
http://arup.blogspot.com/2009/12/resolving-gaps-in-data-guard-apply.html