Maximum Availability Architecture (MAA), Data Guard and other topics – Remember: Knowledge is only valuable if shared!
Oracle has released today (April 4, 2023) the new Oracle Database 23c Free (Developer Release). This marks a significant change within the Oracle delivery model of only delivering a free database (as per example XE) after the full version is available to the public. This clearly shows Oracle’s commitment to the developer community, allowing developers…
This middle November, I will be presenting three sessions at one of my favourite events, the DB Tech Showcase in Tokyo, Japan. This is a free event, and if you are in Japan, please feel free to register and come to meet me at any of my following sessions (Dates and Times in Japan Time…
Note: You can review the environment setup part of the tutorial here. Now that we have all DRPGs created and associated, it is time to add members to each DRPG (primary and standby). For the primary (Ashburn) DRPG we will add: The primary DB (ATP) The 2 Mushop Compute VM’s Two Volume Groups (Boot volumes…
I am very happy to announce the GA of the new Oracle Cloud Infrastructure (OCI) solution that the Oracle MAA team has been working very hard to bring to you (Thank you, Suraj Ramesh). Today we will play with the new, Full Stack DR it is a fully managed OCI disaster recovery orchestration and management…
This week is Oracle Cloud World in Las Vegas. Can’t make it in-person? Not a problem, there’s STILL a way to catch much of the content, digitally. And, I have a code you can use to get a free Cloud World Digital Pass! The comp code to use at https://www.oracle.com/cloudworld/register/ is: OCWDIGITAL Of course, do…
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…
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…
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…
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…
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…