OCI Database: Autonomous Database OCI | VMDB | BMDB | ExadataCS

OCI is built on 5 pillars IAM, Networking, Compute, Storage, & OCI Database. In this post, we are going to cover the final pillar of OCI that is Database. It is the place in Oracle Cloud Infrastructure (OCI) to store, arrange, and manage data coming from various sources.

To know in detail about the remaining 4 pillars:

• IAM in OCI
• Networking in OCI
• Compute in OCI
• Storage in OCI

Oracle OCI Database

OCI provides two types of databases based on the involvement of the users in managing the databases.

1) Autonomous Database OCI (ADB):

There are two types of ADB, Autonomous Transaction Processing (ATP) and Autonomous Data Warehouse (ADW)

• To know more about Autonomous Databases click here

2) Co-Managed Databases: There are 3 types of co-managed Databases, VMDB, BMDB, and Exadata DB

• To know more about Co-managed databases in OCI click here 
• Oracle Exadata Cloud Service (ExaCS): Overview for Beginners click here
• Oracle Cloud at Customers(C@C): Overview and Concept for Beginners click here
• Exadata Deployment Options: Cloud Service (ExaCS) vs Cloud at Customer (ExaCC) vs Exadata Machine click here
• To know about Exadata cloud service in detail click here

Database Editions

All 1- node RAC DB systems support the following Oracle Database editions:

• Standard Edition
• Enterprise Edition
• Enterprise Edition – High Performance
• Enterprise Edition – Extreme Performance (required for 2-node RAC DB systems)

To know more about Database Editions in detail, check here

Provisioning & Connecting

We can create a database in OCI using RestAPI, CLI, DBascli, & Console.

• To know the steps to provision & connect to BM, VM & Exadata DB system click here
• [Video] Oracle Exadata Cloud Service (ExaCS) Networking click here
• To know the steps to provision an Autonomous DB system click here
• To know about the steps to connect to ADB created click here

If You haven’t registered for the free trial account yet, then you can register FREE using my step-by-step video & guide. Click here to download the guide

Administer Database On Cloud

Database on the Oracle cloud allows you to:

• Start/Stop Databases
• Scale Up CPU & Storage
• Cloning
• Managing Exadata DB System

To know more Administration of Database click here

Patching

Patching is done for fixing a bug and improving system performance.

The 4 things you should know about Patching.

• Database Patching
• Grid Infrastructure patching
• Cloud tooling patching
• Operating systems patches

You have to apply patches to the User-Managed Databases i.e VM DB, BM DB, and Exadata Cloud Service.

Note: Patching in the Autonomous database is being taken care of by Oracle.

To know more about patching in databases Click here

Backup & Restore

There are two ways to take the backup of Databases. Backup is stored either in Object Storage or in Local NVMe Storage.

1. Managed backup: Taken care by OCI
2. Unmanaged backup: Backup is taken using RMAN, DBCLI, or backup_api

To know more about how to take Backup of the DB System Click here

Migration Of Databases

We can migrate our databases from on-premise to the cloud. Oracle provides a lot of migration options like ZDM( Zero Downtime), MV2ADB (move to ADB), SQL Developer, Data-Pump, RMAN, Plug-Unplug, etc.

• Oracle Database Migration To Cloud (Lift & Shift): Overview & Methodology Click here
• Zero Downtime Migration: Database To Oracle Cloud Using Hybrid Data Guard click here
• Data Loading in Autonomous Database [Migrate Database To Oracle Autonomous Database Cloud Options: Data Pump, SQL Loader, DBMS_CLOUD, GoldenGate] click here
• Zero Downtime Migration In OCI: Overview & Capability click here
• Zero Downtime Migration (ZDM) Database To Oracle Cloud In 8 Steps click here

High Availability (HA) & Disaster Recovery (DR)

Real Application Cluster (RAC) provides HA. In RAC databases multiple machines running database instances are deployed across FD & AD but all instances are connected to a single database.

• What & How to Create RAC Database On Oracle Cloud (OCI) Click here
• [Video] Is RAC possible on Oracle Cloud? If Yes How Click here

Data Guard is used for Disaster recovery. Data Guard creates a secondary DB system in another datacenter so that in case of failover the secondary DB system becomes primary.

• To know in detail about HA & DR using RAC & Data Guard Click here
• Data Guard In Oracle Cloud Infrastructure (OCI): Overview & Concepts Click here

Oracle Cloud Database Certifications

• Oracle Cloud Database Services Specialist Certification [1Z0-1093]

FAQs

Related/Further Readings

• Right Choice for DBA? Amazon AWS | Microsoft AZURE | Oracle (Confused?)
• [Video] Roles & Responsibilities of Oracle Cloud DBA: Tasks
• Oracle Cloud for DBAs: 9 Things Every Beginner Should Know
• Oracle Cloud Infrastructure (OCI): Region, AD, Tenancy, Compartment, VCN, IAM, Storage Service
• OCI Regions | OCI Availability Domain | Oracle Cloud Region | OCI Realms
• Gateways In OCI
• Oracle Cloud Infrastructure 2022 Architect Associate Certification
• Oracle Cloud (OCI)

Begin Your Cloud Journey

Begin your journey towards becoming a Certified Oracle Cloud Infrastructure Architect and earning a lot more in 2024 by joining our FREE CLASS. You will also know more about the Roles and Responsibilities, Job opportunities for OCI Architects in the market, and what to study Including Hands-On labs you must perform to clear the Oracle Cloud Architect Associate Certification (OCI) certification exam by registering for our FREE Masterclass.

Click on the below image to Register Our FREE Class on Master Oracle Cloud (OCI) and Get a Higher Paying Job!