asked on
Data Gaurd Gap Reolving
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.
Thanks
~Keyur
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.
Thanks
~Keyur
Oracle Database
Last Comment
EE_AutoDeleter
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
On Primary:
Rman target /
run
{
RESTORE ARCHIVELOG FROM SEQUENCE 443 until SEQUENCE 446;
}
Fetch Archive Log (FAL) process will automatically resolve the Gap.
.