Today we will play with an exciting and not very well-known feature within the Oracle Database, called Application Continuity (AC) which is available with the Oracle Real Application Clusters (RAC), Oracle RAC One Node and Oracle Active Data Guard options and it masks outages from end users and applications by recovering the in-flight database sessions…
Category: 19c
Playing with the new OCI Full Stack Disaster Recovery (Full Stack DR) – Part 2 – It is now time to Play
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…
Playing with the new OCI Full Stack DR – Part 1 – Preparing the Environment
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…
Announcement – Data Guard Mixed Encryption Configuration New Parameter and Behaviour is now available with the DB 19.16 RU
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…
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…