If you are a DBA/Apps DBA planning to learn Database on Oracle Cloud or someone already working on Cloud wanting to have a high-level overview of Oracle Database options available on Oracle Cloud, then this blog post is for you.
Here are the 9 things every beginner should know to build, manage, and migrate databases to Oracle Cloud:
1) The very first thing you should know before starting your Cloud journey is the Cloud Service Models i.e. SaaS, PaaS & Iaas. As a DBA, you will work on PaaS & Iaas. To know about Cloud Service Models, check Here.
2) IaaS in Oracle Cloud is available in two flavours: OCI & OCI-C. As a Cloud DBA, you work to manage Databases on OCI.
Oracle Cloud@Customer enables you to consolidate applications and databases on high-performance cloud infrastructure without moving to the public cloud. Reliably run your Oracle and third-party applications, create cloud-native applications, and upgrade existing ones with machine learning and modern cloud services.
To know more about the basic services in Oracle Cloud Infrastructure (OCI), check here, and to understand the differences between OCI & OCI-C, check Here.
Note: As Oracle has depreciated OCI -C and it’s only available for old Cloud Customers, I would recommend you to go with Oracle Cloud Infrastructure (Oracle OCI).
3) In OCI, there are different categories of Oracle Database Cloud Services
4) Database Choices & Options
In the diagram shown below, from left to right are the On-premises platform choices (i.e. all manual tasks), Automated, and Cloud choices (i.e. Autonomous).
- Traditional Database Deployment (On-premises): The most common deployment model prior to the evolution of the Cloud where your DB is on the commodity hardware.
- Oracle Exadata On-premises: You will purchase Exadata and deploy your database & heavy workload on Exadata On-premise.
- Exadata Cloud@Customer: Oracle Cloud at Customer delivers Oracle Cloud services in your data center that would be managed by Oracle.
Note: Check our blog to know more about Cloud@Customer.
- DB on Compute (OCI): This is similar to the database on On-premise, however instead of running on-premise, you are running it on Cloud. In this type, you will not get any tooling. (For testing only not a recommended approach)
- DBCS (VMDB & BMDB): Databases run on OCI as a DBCS & this is where you get all the Cloud tooling like automated cloning, patching, backing up & restoring.
Note: Read our blog to know more about how to provision VMDB system.
- Exadata Cloud Service: Running Exadata but on Cloud, you subscribe to either a Quater rack, Half rack or a full rack.
Note: Check our blog to know more about Oracle Exadata Cloud Service(ExaCS) Architecture.
- Autonomous DB Serverless: this is the simplest configuration, you share the resources of an Exadata cloud infrastructure. You can quickly get started with no minimum commitment.
- Autonomous DB Dedicated: This type enables you to provision autonomous databases into their own dedicated Exadata cloud infrastructure, instead of a shared infrastructure.
Note: Check out our blog to know more about Oracle Autonomous Database Overview: ADW, ATP, Serverless & Dedicated Infrastructure.
6) Database Editions Supported In OCI
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)
Note: RAC is only supported in VM DB System & Bare Metal DB System
7) For the User-Managed Database, you will be performing the following tasks:
- Configuring DB systems on OCI.
- Managing DB system (Start, Stop Scale-Up/Down) & DBCLI.
- Patching DB system using Console & CLI.
- Configuring & Monitoring a DB on OCI.
- Backing up and Recovering a DB on OCI.
- Configuring Data Guard For HA
- Migrating (Lift & Shift) On-prem Database to Cloud (OCI). To know more about Migration, check Here.
8) For the Autonomous Database, the task you will perform includes:
- Provisioning ADW.
- Connecting DB with Application.
- Migrating from On-Prem to Cloud.
- Performance Tuning & Monitoring.
- Loading Data into the Autonomous Database. To know more, check here.
- Configuring Reporting & Analytics.
- Backup & Restoring ADW & ATP.
- Scale-Up & Scale-Down.
9) Certification for DBA’s
Related/Further Readings
- Database On Oracle Cloud (OCI): User-Managed and Autonomous Database
- OCI for DBAs & Apps DBAs: Oracle Cloud Infrastructure (OCI) Why Should You Learn & In What Order
- [Video] Oracle Exadata Cloud Service (ExaCS): Overview for Beginners
- Amazon AWS or Oracle Cloud (Confused ?): Right Choice for DBA’s
What’s Next For You?
If you want to upgrade your career from an Oracle DBA to Oracle Cloud DBA, and want to clear Oracle Cloud Database Migration and Integration Specialist 2021 then register for our FREE class and don’t miss an opportunity to gain a plethora of insights on becoming a certified Oracle Cloud DBA.
Leave a Reply