Oracle DBA

Oracle 19c introduces a powerful new feature for Data Guard setups: the Automatic Flashback of Standby Database. This feature simplifies the process of flashing back a physical standby to a restore point from the primary by replicating restore points automatically. Prerequisites Steps 1. Check the Primary Database Configuration Run the following command on the Primary […]

Oracle Database 19c introduced a powerful feature for multitenant environments: the ability to run Automatic Database Diagnostic Monitor (ADDM) analysis on individual pluggable databases (PDBs). With ADDM analysis at the PDB level, administrators can now focus on specific performance issues within a single PDB, making it easier to tune and optimize performance in a multitenant […]