Unclear impact of redo log application on data freshness after restore
0 reputation · 30 May 2024, 12:49 UTC
Goal: Determine the appropriate recovery strategy after restoring data files from a backup to ensure the database reflects the desired point‑in‑time state while maintaining data integrity.
Uncertainty: Whether redo logs should be reapplied after the data file restore to bring the database to the latest committed transaction, or whether a point‑in‑time recovery that relies solely on archived logs is sufficient, especially considering variations between DBMS versions (e.g., 12.x vs 13.x) that may alter log application behavior.
Questions:
- Should redo logs be applied after the data file restore to achieve the most recent committed state?
- Is a point‑in‑time recovery that uses only the log files adequate for verifying recovered data integrity?
- How do version‑specific restore mechanics affect the decision between these two approaches?