Transportable Tablespaces were first introduced in Oracle 8i to allow entire tablespaces to be copied between databases in the time it takes to copy the datafiles. In Oracle 8i, the major restriction was that both source and target databases had to use the same block size. With the introduction of multiple block sizes in Oracle […]
Oracle Database 12c Release 1 (12.1) introduced a modern and unified way to manage encryption keys, keystores, and secrets through the ADMINISTER KEY MANAGEMENT command.This replaced the legacy commands: The Oracle documentation often uses both wallet and keystore interchangeably, but the preferred and forward-looking term is keystore, aligning with Java standards. Understanding TDE in a […]
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 […]