We have a gap in our Data guard setup because we dont have backup in primary and some archive log files has been removed in primary Database. How to recover those archivelogs? Flashback is disabled.
REFRESH STANDBY USING INCREMENTAL(SCN BASED) BACKUP
1. Get SCN of both PRIMARY and STANDBY
2. Take a note of this SCN
3. Stop the managed STANDBY apply process
4. Shutdown the STANDBY database
5. Take an incremental backup in PRIMARY from the SCN number
6. Create a new STANDBY controlfile in PRIMARY
7. Copy the RMAN backup file and new STANDBY controlfile to STANDBY database
8. Start STANDBY in startup nomount
9. Find the location of controlfile in STANDBY
10. Replace the controlfile in STANDBY side with the one you just created in PRIMARY
11. Mount STANDBY database
12. Catloging rman files as RMAN does not know about these files yet; so you must let it know – by a process called cataloging.
13. Cancel MRP
14. Recover the STANDBY database
15. Start MRP
16. Now check the archive status in both the databases
17. Check the processes running on STANDBY
18. On PRIMARY switch logfiles to confirm whether new archives are getting applied or not
Further for more information on Data Gaurd, visit our support website:
Thank you guys !! Issue got cleared.