Oracle Cloud: OCI, Autonomous Database and Multicloud

62.1 OCI Database Services

Autonomous Database (ADB): ATP, ADW, AJD (JSON), APEX Service

Self-driving, self-securing, self-repairing. Serverless or dedicated.

Base Database Service (VM DB systems) Customer-managed Oracle DB on VMs Exadata Database Service Exadata in OCI Exadata Cloud@Customer OCI-managed Exadata in your data center

Oracle Database@Azure / @AWS / @Google Cloud Exadata and ADB running inside hyperscaler data centers MySQL HeatWave, NoSQL Other OCI databases

62.2 Autonomous Database Concepts

Automated: provisioning, patching, tuning (auto indexing, auto stats), scaling (CPU auto-scaling, ECPU billing model), backups (60-day retention by default), encryption (TDE always on), Data Guard (Autonomous Data Guard), and Elastic Pools.

Connecting: mTLS with a wallet, or TLS with access control lists. Private endpoints. Service names _high, _medium, _low, _tp, _tpurgent.

Restrictions: no OS access, no SYSDBA (the ADMIN user instead), some parameters locked, lockdown profiles.

Built-in tools: Database Actions (SQL, Data Load, Data Studio), APEX, ORDS, OML notebooks, Graph Studio, MongoDB API, Select AI.

DBMS_CLOUD and DBMS_CLOUD_PIPELINE for object storage loading and external tables. Cloud links. Data sharing (Delta Sharing).

Always Free tier for learning.

62.3 OCI Fundamentals for DBAs

Tenancy, compartments, regions and availability domains, VCN/subnets/security lists/NSGs, IAM policies, Vault, Object Storage, Data Safe, Operations Insights, Database Management service, Terraform/Resource Manager, the OCI CLI.

62.4 Migrating to the Cloud

Zero Downtime Migration (ZDM), OCI Database Migration (DMS), Data Pump with object storage, RMAN backup to the cloud, GoldenGate, and the Cloud Premigration Advisor Tool (CPAT).