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…
Category: Backup & Recovery
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…
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…
Playing with Oracle Cloud – Creating a Hybrid DR Deployment
On this article, we will create a Hybrid Disaster Recovery (DR by using Data Guard) Oracle Database Cloud Service database deployment with a primary database on-premises and a standby database in the cloud. This can be used to implement an improve the high availability of your Database by taking advantage of the Cloud, and even to migrate your…
Playing with Oracle Database Cloud – Migrating to Cloud using an Oracle Cloud Backup
The idea for this scenario is to learn how to migrate an Oracle Database from on-premises to Oracle Cloud DBaaS by using a previously done backup using Oracle Cloud Backup Services. First, we will create an Oracle Database Cloud Services database deployment (DBaaS) whose database is instantiated from a cloud backup created by using Oracle Database Backup…
Playing with Oracle Database Cloud Backup Service
This article will show you how easy is to make use of Oracle Cloud to securely store all our on-premises Oracle Database Backups. Note that backups stored in Oracle Cloud can also be used to create new Oracle Database Instances (DBaaS). Requirements: To perform the steps in this tutorial, you will need: An understanding of…