Applying Incremental Backups on Standby Database.
Standby Database is not Sync with Primary and gap is more than 40 days.. We don't have archivelog backups older than 30 days to apply on Standby Database. Instead of Rebuilding entire Standby Database we used Incremental Backup recover Standy database. Steps Followed briefly: 1 . Take current SCN From Standby Database 2. Take Primary DB Backup using FROM SCN. 3.Create standby controlfile 4. Copy Backups to Standby Server 5. shutdown standby ,startup nomount, Restore Standby control file & startup mount 6. REcovery database noredo 7. alter database recover managed standby database disconnect from session; 8. Verify Standby Gap. Standby: ======== Current SCN From Standby Database: ---------------------------------- SQL> col current_scn for 999,999,999,999,999,9999 SQL> select current_scn from v$database; CURRENT_SCN ------------------------- 917,102,315,7647...