I have data Physical Gaurd setup. I found there is gap in tandby DB. I found Missing archive log sequence#. I checked on my primary DB and found that that Archivelog was backed up to disk using RMAN backup and then deleted.
I dont know how to retrive that Archive log from RMAN and put it on disk, move it to standby machine, register and apply it.
If I can able to retrive that backup from RMAN I would be able to resolve a GAP.
Please let me know what command should I execute to get an archive log file from RMAN backup set.
Rman target /
RESTORE ARCHIVELOG FROM SEQUENCE 443 until SEQUENCE 446;
Fetch Archive Log (FAL) process will automatically resolve the Gap.