I am very happy to announce that with the new 19.16 RU (July 2022 Release Update) for Oracle Database released last week (Doc ID 2521164.1), Data Guard is now more flexible regarding how it deals with mixed encryption configurations with the introduction of the new TABLESPACE_ENCRYPTION initialization parameter. Previously when having a hybrid DR environment…
Month: July 2022
Announcement – Oracle Data Guard per Pluggable Database (DGPDB) is available today with the 21.7 RU
I am very happy to announce that with the new 21.7 RU for Oracle Database released today (Doc ID 2796590.1), a new functionality for Data Guard is out! Data Guard per Pluggable Database, or DGPDB for short, fully enables multi-tenancy at high availability level. Ludovico Caldara is talking about this new functionality in an official…
Back-to-Basics: Understanding Backup and Recovery plus High Availability(Part II – Redo)
What is redo? Let’s look briefly at the redo process. When Oracle blocks (the smallest unit of storage in a database) are changed, including UNDO blocks, Oracle records the changes in vector changes, which are referred to as redo entries or redo records. The changes are written by the server process to the redo log…
Back-to-Basics: Understanding Backup and Recovery plus High Availability(Part I)
The constant evolution of IT has, among other things, affected the role of a database administrator (DBA). Today the DBA is not merely a Database Administrator anymore but is morphing more into the Database Architect role. If you want to become a successful DBA and be more competitive in the market, you should have a…
Playing with Active Data Guard – DML Redirection and Automatic Block Media Recovery
Today we will be playing with two functionalities of Oracle Active Data Guard (ADG): DML Redirection Automatic Block Media Recovery DML Redirection is the capability ADG has to redirect DML operations made in the active-standby node to the primary node without impacting its protection of it (by redirecting all DML transactions to the primary database…