Which types of db system is not available in oci

Oracle Cloud Infrastructure offers single-node DB systems on either bare metal or virtual machines, and 2-node RAC DB systems on virtual machines.

If you need to provision a DB system for development or testing purposes, a special fast-provisioning single-node virtual machine system is available.

You can manage these systems by using the Console, the API, the Oracle Cloud Infrastructure CLI, the Database CLI (DBCLI), Enterprise Manager, or SQL Developer.

Note

This documentation is intended for Oracle database administrators and assumes familiarity with Oracle databases and tools.

Supported Database Editions and Versions

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

• Standard Edition
• Enterprise Edition
• Enterprise Edition - High Performance
• Enterprise Edition - Extreme Performance

Two-node Oracle RAC DB systems require Oracle Enterprise Edition - Extreme Performance.

For standard provisioning of DB systems (using Oracle Automatic Storage Management (ASM) as your storage management software), the supported database versions are:

• Oracle Database 21c
• Oracle Database 19c
• Oracle Database 12c Release 2 (12.2)
• Oracle Database 12c Release 1 (12.1)
• Oracle Database 11g Release 2 (11.2) (available only with standard shapes)

For fast provisioning of single-node Virtual Machine DB System (using Logical Volume Manager as your storage management software), the supported database versions are:

• Oracle Database 21c
• Oracle Database 19c
• Oracle Database 12c Release 2 (12.2)

Tip:

Your DB system's operating system will periodically need to be updated, just as your Oracle Database software will need to be updated. Before attempting an OS update, be sure to back up your DB system's databases and read the information in Update a DB System.

Upgrade the Oracle Database Software in Your DB System

You can upgrade database instances that use Oracle Database 18c and earlier to Oracle Database 19c (Long Term Release). For information on prerequisites and upgrade instructions, see Upgrade a Database.

Oracle Database Preview Version Availability

Oracle Cloud Infrastructure periodically offers preview software versions of Oracle Database for testing purposes. You can provision a Virtual Machine DB System using preview version software to test applications before the general availability of the software in the Database service. When you provision a DB system with preview version software, the system remains available to you until you decide to terminate it.

Preview version DB systems are provisioned in the same manner as non-preview systems. If available, preview version software is displayed as one of the choices in the Database version selector in the Create DB System dialog. For instructions on provisioning a Virtual Machine DB System using preview version software, see the Overview of Creating a DB System article.

Current Preview Version Software

There is no Oracle Database preview software version available at this time for Bare Metal and Virtual Machine DB Systemss in Oracle Cloud Infrastructure.

Oracle Database Preview Version Restrictions

Preview version software cannot be used for production databases. The following restrictions apply to preview version software:

• Only available for non-RAC Virtual Machine DB Systems. Preview software is not available for Bare Metal DB Systems, or Virtual Machine DB Systems using RAC.
• Uses Logical Volume Manager (LVM) storage management software only. Automatic Storage Management (ASM) is not available.
• Patching and database version upgrades (including upgrades to the generally available release of the preview software) are not available.
• You cannot create a new DB system from a backup of a database that uses preview version software.
• Standalone backups cannot be created.
• Data Guard is not available.
• Preview version software DB systems cannot be created from backups. In-place restores are supported.

Per-Second Billing for Bare Metal and Virtual Machine Database Resources

For databases using bare metal and virtual machine infrastructure, Oracle Cloud Infrastructure uses per-second billing. This means that OCPU and storage usage is billed by the second, with a minimum usage period of 1 minute for Virtual Machine DB Systems and 1 hour for Bare Metal DB Systems.

Customer Managed Keys for Databases

Customer-managed keys is a feature that enables you to encrypt your data using encryption keys that you control using the OCI Vault service. The Vault service provides you with centralized key management capabilities that are highly available and durable. For more information on Vault service, see Overview of Vault and Database Encryption Keys.

Database Backups, Restoring from a Backup, and Creating a Database or DB System from a backup

Backup Options

Oracle Cloud Infrastructure offers you the ability to create and store automatic daily backups and on-demand full backups. You can store backups in your DB system's local storage, or in Oracle Cloud Infrastructure Object Storage. For information about the backup storage options you have for your cloud databases, see Overview of Backing Up a Database. For information about managed automatic backups in Oracle Cloud Infrastructure, see Back Up a Database to Object Storage.

Creating a Database or DB System Using a Backup

See Create a DB System from a Backup Using the Console to create a DB system from a backup and Create a Database article for information about creating a database or DB system from the following sources:

• Daily automatic backups or on-demand full backups.
• The last archived redo log backup. Requires that you have automatic backups enabled. This backup combines data from the most recent daily automatic backup and data from archived redo logs, and represents the most current backup available.
• Daily automatic backup data used to create a point-in-time copy of the source database based on a specified timestamp.
• Standalone Backups.

Move Databases to Oracle Cloud DB Systems Using Zero Downtime Migration

Oracle now offers two new solutions for migrating Oracle database workloads from on-premises and Oracle Cloud Infrastructure Classic to a variety of Oracle Database Cloud services: Oracle Cloud Infrastructure Database Migration Service and Zero Downtime Migration.

Zero Downtime Migration (ZDM) is an installable tool which provides you with a simplified and automated migration experience, providing zero to negligible downtime for the production system.

Oracle Cloud Infrastructure Database Migration Service is based on the ZDM tool, and as a managed Oracle Cloud Infrastructure service it provides you with a user interface to move Oracle databases to Oracle Cloud.

For more information, see the following topics:

• Get started with Zero Downtime Migration
• Get started with Oracle Cloud Infrastructure Database Migration Service