In this article, we will see how to convert an existing Physical Standby Database into an Active Data Guard configuration in Oracle 19c. The read-only physical standby database can be used to offload reporting and query workloads from the primary database. Users can execute SELECT statements and complex analytical queries on the standby, thereby reducing […]
Synopsis: This post describes a pragmatic, production-oriented procedure to recover a database when all online redo log files are lost on Oracle 19c. It assumes you have valid RMAN backups and the archived redo logs required for recovery. The example is taken from a lab scenario and is copy-paste ready for documentation or an internal […]
Keeping a standby database synchronized with its primary is critical for fast failover, reporting offload, and disaster recovery readiness. When archived redo transfer is slow, missing, or the standby has fallen behind significantly, an SCN-based incremental RMAN refresh is a fast, reliable way to bring the standby forward. This article provides a clear, step-by-step operational […]
Synopsis:This article demonstrates how to recover a dropped table in Oracle 19c using RMAN’s point-in-time tablespace recovery (TSPITR) technique. The procedure uses an auxiliary instance to mount a recovered copy of necessary tablespaces at the requested point in time, performs an export of the target table from the auxiliary instance, and then imports it back […]