You are currently browsing the tag archive for the ‘incremantal backup’ tag.
Sometimes standby database lags far behind from the primary database leading to Archive Gap. There are some reasons could be for that such as
- Network issue between the primary and the standby database leading to the archive gaps.
- Standby archive log dest may be full or Standby db disk becomes full so the primary and the standby database leading to the archive gaps.
In those cases(or some other cases) where the standby lags far behind from the primary database, incremental backup is very useful to roll forward the physical standby database to have it in sync with the primary database.
Helios's Blog 