Rolling forward a standby database involves applying incremental backups to synchronize changes made to the primary database. This process becomes more complicated when a new datafile is added to the primary database. In this article, I will outline the essential steps and considerations involved in rolling forward a standby database using RMAN incremental backups after the addition of a datafile on the primary side.
Thursday, September 18, 2025
How to Roll Forward a Standby Database Using RMAN Incremental Backup After Adding a Datafile to Primary
Rolling forward a standby database involves applying incremental backups to synchronize changes made to the primary database. This process becomes more complicated when a new datafile is added to the primary database. In this article, I will outline the essential steps and considerations involved in rolling forward a standby database using RMAN incremental backups after the addition of a datafile on the primary side.
Subscribe to:
Comments (Atom)
OCI Bastion RDP Failure: Troubleshooting Error 0x708 with VNC Console Access by creating local console connection
Introduction: Oracle Cloud Infrastructure (OCI) provides Bastion as a secure and convenient way to access private resources without ex...
-
Introduction In our existing SQL Server Always On configuration, we had a two-node setup, with each node hosted in a separate data center,...
-
Introduction In Part 1 (SQL Server Always On Across Two Data Centers with Dual Witnesses and DNS CNAME) , I walked through how we designed...
-
Prerequisites 1. Backup File: Ensure you have a valid full backup of the database you want to restore. I used AdventureWorks2019.ba...