Oracle Cloud Infrastructure offers 1-node DB systems on either bare metal or virtual machines, and 2-node RAC DB systems on virtual machines. If you need to quickly spin up a DB system for development or testing purposes, a special fast provisioning 1-node VM 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, Enterprise Manager Express, or SQL Developer.
This documentation is intended for Oracle database administrators and assumes familiarity with Oracle databases and tools. If you need additional information, see the product documentation available at http://docs.oracle.com/en/database/.
All 1- node RAC DB systems support the following Oracle Database editions:
- Standard Edition
- Enterprise Edition
- Enterprise Edition - High Performance
- Enterprise Edition - Extreme Performance
2-node 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 19c (19.0)
- Oracle Database 18c (18.0)
- Oracle Database 12c Release 2 (12.2)
- Oracle Database 12c Release 1 (12.1)
- Oracle Database 11g Release 2 (11.2)
- Oracle Database 20c (20.0) - Preview version only
- Oracle Database 19c (19.0)
- Oracle Database 18c (18.0)
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 read the information in Updating a DB System and back up your DB system's databases.
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. See To create a DB system for instructions on provisioning a Virtual Machine DB system using preview version software.
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 systems, Exadata systems, or VM 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.
Current Preview Version Software
Oracle Cloud Infrastructure currently offers Oracle Database 20c as preview version software.
For virtual machine DB systems, Oracle Cloud Infrastructure also supports the creation of DB systems using older database versions. For each shape, the latest version and the two prior versions of the release are available at provisioning.
If you need to launch your DB system with an older database version, see Critical Patch Updates for information on known security issues with your chosen database version. You will also need to analyze and patch known security issues for the operating system included with the older database version. See Securing Database for information on security best practices for databases in Oracle Cloud Infrastructure.
Bare Metal DB Systems
Bare metal DB systems consist of a single bare metal server running Oracle Linux 6.8, with locally attached NVMe storage. If the node fails, you can simply launch another system and restore the databases from current backups.
When you launch a bare metal DB system, you select a single Oracle Database Edition that applies to all the databases on that DB system. The selected edition cannot be changed. Each DB system can have multiple database homes, which can be different versions. Each database home can have only one database, which is the same version as the database home.
When you launch a DB system, you choose a shape, which determines the resources allocated to the DB system. The available shapes for a bare metal DB system are:
- BM.DenseIO2.52: Provides a 1-node DB system (one bare metal server), with up to 52 CPU cores, 768 GB memory, and eight 6.4 TB locally attached NVMe drives (51.2 TB total) to the DB system.
BM.DenseIO1.36: Limited availability. Provides a 1-node DB system (one bare metal server), with up to 36 CPU cores, 512 GB memory, and nine 3.2 TB locally attached NVMe drives (28.8 TB total) to the DB system.
Note: BM.DenseO1.36 is available only to monthly universal credit customers existing on or before November 9th, 2018. This shape is available only in the US West (Phoenix), US East (Ashburn), and Germany Central (Frankfurt) regions.
The shape you choose for a bare metal DB system determines its total raw storage, but other options, like 2- or 3-way mirroring and the space allocated for data files, affect the amount of usable storage on the system. The following table shows how various configurations affect the usable storage for bare metal DB systems.
|Shape||Raw Storage||Usable Storage with Normal Redundancy (2-way Mirroring)||Usable Storage with High Redundancy (3-way Mirroring)|
|51.2 TB NVMe||
DATA 16 TB
RECO 4 TB
DATA 9 TB
RECO 2.3 TB
|28.8 TB NVMe||
DATA 9.4 TB
RECO 1.7 TB
DATA 5.4 TB
RECO 1 TB
There are two types of DB systems on virtual machines:
- A 1-node virtual machine DB system consists of one virtual machine.
- A 2-node virtual machine DB system consists of two virtual machines.
When you launch a virtual machine DB system, you select the Oracle Database Edition that applies to the database on that DB system. The selected edition cannot be changed. Unlike a bare metal DB system, a virtual machine DB system can have only a single database home, which in turn can have only a single database. The database can be a container database (CDB) with multiple pluggable databases (PDBs), if the edition is High Performance or Extreme Performance. The database will be the same version as the database home.
Virtual machine DB systems also differ from bare metal DB systems in the following ways:
- A virtual machine DB system database uses Oracle Cloud Infrastructure block storage instead of local storage. You specify a storage size when you launch the DB system, and you can scale up the storage as needed at any time.
- The number of CPU cores on an existing virtual machine DB system cannot be changed.
For 1-node virtual machine DB systems, Oracle Cloud Infrastructure provides have a "fast provisioning" option that allows you to create your DB system using Logical Volume Manager as your storage management software. The alternative ("standard provisioning") is to provision with Oracle Automatic Storage Management (ASM).
- When using the fast provisioning option, the number and size of the block volumes specified during provisioning determines the maximum total storage available through scaling. See Storage Scaling Considerations for Virtual Machine Databases Using Fast Provisioning for details.
Multi-node Virtual Machine DB systems require Oracle Automatic Storage Management and cannot be created using the fast-provisioning option.
When you provision a 2-node RAC DB systems, the system assigns each node to a different fault domain by default. Using the Advanced Options link in the provisioning dialog, you can select the fault domain(s) to be used for your 2-node RAC DB systems and the system will assign the nodes to your selected fault domains. Oracle recommends that you place each node of a 2-node RAC DB system in a different fault domain. For more information on fault domains, see Fault Domains.
When you launch a DB system, you choose a shape, which determines the resources allocated to the DB system.
The following table shows the available shapes for a virtual machine DB system on X7.
The following table shows the available shapes for a virtual machine DB system on X5.see note
|VM.Standard1.1see note||1||7 GB|
|VM.Standard1.2see note||2||14 GB|
|VM.Standard1.4see note||4||28 GB|
|VM.Standard1.8see note||8||56 GB|
|VM.Standard1.16see note||16||112 GB|
Storage Options for Virtual Machine DB Systems
Virtual machine DB systems use Oracle Cloud Infrastructure block storage. The following table shows details of the storage options for a virtual machine DB system. Total storage includes available storage plus recovery logs.
|Available Storage (GB)||Total Storage (GB)|
For 2-node RAC virtual machine DB systems, storage capacity is shared between the nodes.
See Backing Up a Database for information about the backup options you have for your cloud databases. See Backing Up a Database to Oracle Cloud Infrastructure Object Storage for information about managed automatic backups in Oracle Cloud Infrastructure.