Roll-Forward a Standby Database using RMAN Incremental backup
In this post we'll see about Roll-Forwarding a physical standby database using RMAN Incremental backup in a detailed step by step process. Check the status of standby database Identify the issue Identify required SCN for recovery SCN based Incremental backup for standby database Catalog the backup Recover standby database Restore standby controlfile Check Incarnation Switch database to copy Report Schema Catalog datafiles Switch datafile copy List copy of database Final check Recover standby database Start MRP Log switch testing Check the status of standby database We created a standby database using recent backup of our production database, but somehow some of the archive logs are missed and hence Primary and Standby databases are not in synchronization. So now we'll fix this situation using Roll-forward backup based on SCN of the standby database to recover the standby database from required point in time. In the below SS, we can see the latest l...