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.
Exploring Bigfile Tablespaces with Default Settings in oracle 23ai
BIGFILE Tablespace A bigfile tablespace is a tablespace with a single, but large datafile. Traditional small file tablespaces, in contrast...
-
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: Managing data security in SQL Server goes beyond enabling Transparent Data Encryption (TDE)—it also requires proper lifecycl... -
Introduction In Part 1 (SQL Server Always On Across Two Data Centers with Dual Witnesses and DNS CNAME) , I walked through how we designed...
