What is Oracle Database Cloud Service?
Oracle Database Cloud Service lets you easily build, scale, and secure Oracle databases in the cloud. You create databases on DB systems, which are either bare metal servers (with local NVMe flash or SSD storage) or virtual machines with block volumes, both of which provide high performance and cost-efficient pricing. The service also enables support for 'cloud-first' Oracle RAC implementation on virtual machine servers at the virtual cloud network layer.
You can manage your databases using simplified tools like patching, Data Guard or backup/recovery, all of which can be accessed using the Oracle Cloud Infrastructure REST APIs or console. Alternatively, you can access your database host and use your existing tools to manage your databases in the cloud, the same way you manage them on-premises.
What capabilities does Oracle Database Cloud Service provide?
Oracle Database Cloud Service provisions a DB system with the requested number of cores on a high performance bare metal server or virtual machine, deploys Oracle Database software with the edition of your choice, and creates the DB system in a virtual cloud network (VCN). The VCN is a private network with user-configured security lists which protects the DB system from unauthorized access.
Oracle Database Cloud Service also provides manageability features like database service patching, configuring high availability using Oracle Data Guard and backup/restore which simplifies day-to-day tasks required to run your Oracle databases.
How can I create my first database?
How do I pay for the resources I consume?
Both bare metal servers and virtual machines support Oracle's Universal Credit Model with both 'license included' and 'bring your own license' pricing. Pricing is flexible with both pay as you go option as well as discounted commit prices through Oracle Sales. Pricing depends on the selected database edition, database shape and number of cores you choose.
You can consume Oracle Database Cloud Service database instances by creating an account at shop.oracle.com. Alternatively, existing customers can contact their sales representative to create and account and enable an existing pool of credits, or purchase a new pool, to consume Oracle Cloud Infrastructure resources. Refer to database pricing section for more details.
Existing Metered/Non-Metered tenancies will be billed under their existing plan until converted to a Universal Credit Model tenancy.
Which Oracle Database software versions are supported?
Currently, Oracle Database Cloud Service supports Oracle Database versions 220.127.116.11, 18.104.22.168, 22.214.171.124, and 126.96.36.199.
Which Oracle Database software editions are supported?
The following Oracle Database software editions are supported and optimized for the cloud.
- Standard Edition
- Enterprise Edition
- Enterprise Edition High Performance
- Enterprise Edition Extreme Performance
What database options are available with the different software editions of Oracle Database?
The following list describes the database options available with each edition. Note that all packages include Oracle Database Transparent Data Encryption (TDE).
|Database Edition||Database Options|
|Standard Edition||Includes the Oracle Database Standard Edition Package.|
|Enterprise Edition||Includes the Oracle Database Enterprise Edition Package, Data Masking and Subsetting Pack, Diagnostics and Tuning Packs, and Real Application Testing.|
|Enterprise Edition High Performance||Extends the Enterprise package with the following options: Multitenant, Partitioning, Advanced Compression, Advanced Security, Label Security, Database Vault, OLAP, Advanced Analytics, Spatial & Graph, Database Lifecycle Management Pack, and Cloud Management Pack for Oracle Database.|
|Enterprise Edition Extreme Performance||Extends the High Performance package with the following options: Real Application Clusters (RAC), In-Memory Database, and Active Data Guard.|
What shapes (storage and CPU configurations) are available when launching a DB system?
Bare Metal shapes
To meet the extreme performance demands of critical enterprise applications, Oracle Database Cloud Service supports three bare metal shapes that can achieve greater than 200,000 TPS or IOPS for a single database. Bare Metal DB systems use locally attached NVMe or SSD storage to ensure maximum performance. The amount of storage is determined by the shape specified when the DB system is launched.
|Bare Metal Shape||Cores/OCPUs||Memory||Storage Type||Raw Storage||Storage (2-Way Mirroring)||Storage (3-Way Mirroring)|
|BM.HighIO1.36*||2 – 36||512 GB||NVMe||12.8 TB||3.5 TB||2.3 TB|
|BM.DenseIO1.36||2 – 36||512 GB||NVMe||28.8 TB||9.4 TB||5.4 TB|
|BM.DenseIO2.52||2 – 52||768 GB||NVMe||51.2 TB||16 TB||9 TB|
(consists of two physical nodes)
|2 – 36 per node||512 GB per node||SSD||64 TB||22.1 TB||14 TB|
Note that when using Standard Edition with High IO & Dense IO shapes, the maximum allowed OCPUs is 8 OCPUs per instance.
*BM.HighIO1.36 and BM.RACLocalStorage1.72* shapes are no longer available, but continue to be supported for existing customers.
Virtual Machine shapes
Oracle Database Cloud supports a variety of virtual machines based on Standard VM compute shapes. The choice of VM shapes provides cost efficiency and flexibility to select one to 24 cores and 256-GB to 40-TB of scalable and durable remote storage.
|VM Shape||Cores/OCPUs||Memory||Storage (Block Only)||Network Bandwidth|
|VM.Standard.1.1||1||7 GB||256 GB - 40 TB||Up to 600 Mbps|
|VM.Standard.1.2||2||14 GB||256 GB - 40 TB||Up to 1.2 Gbps|
|VM.Standard.1.4||4||28 GB||256 GB - 40 TB||1.2 Gbps|
|VM.Standard.1.8||8||56 GB||256 GB - 40 TB||2.4 Gbps|
|VM.Standard.1.16||16||112 GB||256 GB - 40 TB||4.8 Gbps|
|VM.Standard.2.1||1||15 GB||256 GB - 40 TB||1 Gbe|
|VM.Standard.2.2||2||30 GB||256 GB - 40 TB||2 Gbe|
|VM.Standard.2.4||4||60 GB||256 GB - 40 TB||4 Gbe|
|VM.Standard.2.8||8||120 GB||256 GB - 40 TB||8 Gbe|
|VM.Standard.2.16||16||240 GB||256 GB - 40 TB||16 Gbe|
|VM.Standard.2.24||24||320 GB||256 GB - 40 TB||25 Gbe|
Note: For any shape greater than 2 cores, you can specify Total Number of nodes=2 to get RAC configuration. When using Standard Edition, the maximum allowed shape is VM.Standard1.8.
What upgrade options are recommended for prior generation shapes?
The following Oracle Database Cloud Service bare metal "X5" based Dense IO and Bring Your Own License options are no longer available, but continue to be supported for existing customers:
|SKU||Compute Instance Shape||Recommended Alternatives|
|Bare Metal – "X5" Dense I/O – Standard Edition||Bare Metal "X5" Dense/IO
||Bare Metal "X7" – Dense I/O
|Bare Metal – "X5" Dense I/O – Enterprise Editions (Enterprise Edition, High Performance, Extreme Performance)||Bare Metal "X5" Dense/IO
||Bare Metal "X7" – Dense I/O
|Bare Metal – "X5" Dense I/O – BYOL||Bare Metal "X5" Dense/IO
||Bare Metal "X7" – Dense I/O
|Virtual Machine Standard – "X5" – all editions (Standard, Enterprise, High Performance, Extreme Performance, BYOL)||VM.Standard1.1
||"X7" Based VM.Standard2.1
|Virtual Machine Standard – "X5" – all editions (Standard, Enterprise, High Performance, Extreme Performance, BYOL)||VM.Standard1.2
||"X7" Based VM.Standard2.2
|Virtual Machine Standard – "X5" – all editions (Standard, Enterprise, High Performance, Extreme Performance, BYOL)||VM.Standard1.4
||"X7" Based VM.Standard2.4
||"X7" Based VM.Standard2.8
||"X7" Based VM.Standard2.16
What is a DB system?
A DB system is a bare metal server or a virtual machine that has the Oracle Database software deployed and configured with a user-specified number of cores, software edition, and database version.
Can I create multiple databases within a DB system?
Yes. A bare metal DB system can have multiple DB Homes, which can have multiple databases within them. All the databases within a DB Home will have the same version, but each DB Home can have a different version. For example, an Enterprise Edition DB system might contain DB_Home11, which contains only Enterprise Edition 188.8.131.52 databases, and DB_Home12, which contains only Enterprise Edition 184.108.40.206 databases. Note, however, that Virtual Machine DB systems are single Database instances.
Can I change the database edition after launching a DB system?
No, the edition can't be changed. However, you can easily terminate the DB system and launch another with the preferred edition.
Can I change the database character sets after launching a DB system?
When you launch a DB system, the initial database created on the system uses the default character sets AL32UTF8 and AL16UTF16. However, you can easily pick a character set of your choice during launch in the Database advanced options.
Can I bring my own license (BYOL) to Oracle Database Cloud Service?
Yes, you can bring your own license. Oracle Database Cloud service supports both license included and BYOL pricing models.
What are the recommended best practices for monitoring the DB system?
Oracle highly recommends that you use Enterprise Manager for your database monitoring needs. Oracle plans to add support for returning metrics directly from the Database service soon.
What are the limits on the number of DB systems that I can create in my account?
Refer to the Service Limits documentation for the default limits for each instance type and instructions on how to request a service limit increase. We are happy to increase the limits for your account as needed.
Is Oracle RAC supported on Oracle Database Cloud Service?
Yes. Oracle Database Cloud Service supports a 'cloud-first' Oracle RAC on virtual machines within a virtual cloud network.
Oracle RAC on virtual machines is configurable by setting the "Total Number of Nodes" as 2 during the DB system launch.
What is Oracle Cloud Infrastructure Database Service on virtual machines (VMs)?
Database Service on VMs is a database service offering that enables customers to build, scale, and manage full featured Oracle databases on virtual machines. The key benefits of running databases on VMs are cost effectiveness, ease of getting started, durable and scalable storage, and the ability to run Real Application Clusters (RAC) to improve availability.
RAC databases will run in a single Availability Domain (AD), while ensuring each node is on a separate physical rack ensuring high availability. Database Cloud Service on VMs is built on the same high performance, highly available cloud infrastructure used by all Oracle Cloud Infrastructure services.
What are the benefits Database service on VMs?
Database service on VMs provides several benefits ranging from low cost to flexible storage. Specifically,
- Cost Effective & Flexible - Customers can start as low as single OCPU VM up to 24 OCPUs. Customers pay only for OCPUs and Storage used.
- Ease Of Getting Started - Customers can easily create Oracle Certified, full featured, fully supported 11g, 12c (both 12.1 & 12.2) databases with choice of any database edition.
- Built-in High Availability Constructs - Customers can easily deploy 2-node RAC configurations with all the VM shapes. For example: Easily deploy a 2-node RAC configuration with 2 core Virtual Machines and shared block storage of up to 40 TB.
- Durable & Scalable Storage - Customers can use remote storage starting 256GB up to 40 TB. Storage can be scale up with no downtime.
- Secure - Customers still get all the advantages of our Oracle IAM for management control and VCN Security lists for securing their database environments.
Are RAC databases supported on Database service on VMs?
Yes, RAC (Real Application Cluster) databases are supported on Database Cloud Service on VMs as a 2-node RAC configuration. 2-node RAC is enabled by selecting node=2 when setting up your VM database. Note, only Enterprise Edition Extreme Performance supports RAC database and the minimum number of cores per VM is two.
Can I change the number of cores associated with a DB system in a VM shape after initial creation?
No. Currently, you cannot change the number of cores used by the DB system after it is created.
Can I create multiple DB Homes in a database on a VM?
No, you cannot create multiple DB Homes in a VM database. Each VM database instance can only launch one database per instance.
How can I scale the storage available to a Database service running in a VM?
You can easily scale up storage for a DB system by using the console, REST APIs, CLI and SDKs. Database Cloud Service on VM uses remote block storage, so you can configure available storage anywhere from 256GB to 40TB. Scale up of storage happens without any downtime. Note: The total storage attached to an instance will be a sum of available storage, reco storage, and software size. Available storage is selected by the customer, reco storage is automatically calculated based on available storage, and software size is a fixed size Oracle database cost.
How will I be metered and billed for Oracle Database Cloud Service usage?
Oracle Cloud Infrastructure supports Oracle's Universal Credit Model with both license included and bring your own license pricing. Pricing is flexible with both pay as you go, as well as discounted commit prices through Oracle Sales. Oracle Database is charged on the following usage elements:
- Hosted Environment per hour - Hosted Environment is defined as the base DB system instance which has a base CPU capacity, local storage (for bare metal only), and enabled OCPUs for the edition of your choice. Each partial Hosted Environment Hour consumed is billed as a full hour.
- OCPU per hour - You can enable additional OCPUs per Hosted Environment or DB system. Each partial OCPU Hour consumed is billed as a full hour.
- Block volumes - Database service on VM uses remote block volumes. You can attach storage anywhere from 256GB to 40TB and pay for the total storage, which is the sum of available storage, reco storage, and software size. Available storage is selected by you, while Reco storage is automatically calculated based on available storage, and software size is a fixed size Oracle database cost. Please refer to Storage pricing for more details.
- Object storage - Your automatic incremental backups, on-demand full backups and on-premises to cloud backups are stored in Oracle Cloud Infrastructure Object Storage and you will be charged standard object storage cost. Please refer to Storage pricing for more details.
What is the pricing model for Oracle Database Cloud Service?
Refer to database pricing section from more details.
What does per core-hour billing mean for my DB system?
Oracle Database Cloud Service is on-demand and elastic, which means you are charged only for what you use. Your charges are rounded up to the hour. For example: if an instance runs for 45 minutes before being terminated, you are charged for an hour.
What are the costs for taking backups of my database?
How will I be billed when I set up high availability for my database using Data Guard?
Setting up Data Guard across two DB systems deployed in separate Availability Domains configures high availability for your databases. The pricing for each DB system follows the standard pricing models described in database pricing.
Does Oracle Database Cloud Service support stop billing?
Yes, Oracle Database Cloud Service supports stop billing for virtual machine databases. To take advantage of this capability, go to the virtual machine database system and select the desired node to stop. The database remains intact while the node is stopped. You are not billed for hours the node is not running. For partial hours, you are billed for the maximum number of OCPUs used by the database system during that hour.
Stop billing is not applicable to Bare Metal Dense I/O or Exadata DB systems, and billing continues after stopping a node, since you continue hold on to the entire hosted environment. To reduce costs for Bare Metal Dense I/O or Exdata shapes you can make use of the online CPU scaling capability of the database shape and reduce the OCPUs to 2 for DenseIO and 0 for Exadata in unused and minor used environments. Setting the OCPU count to 0 in an Exadata Cloud Service will shut down the VMs as well as any databases running.
What is an Oracle Virtual Cloud Network (VCN) and why are DB systems deployed into a VCN by default?
A VCN is a customizable private network in Oracle Cloud Infrastructure. Just like a traditional data center network, a VCN provides you with complete control over your network environment. This includes assigning your own private IP address space, creating subnets, creating route tables and configuring stateful firewalls. A single tenant can have multiple VCNs, thereby providing grouping and isolation of related resources.
By deploying into a VCN by default, you get the security and flexibility of:
- Deploying your databases into a private network, protected from the internet.
- Configuring security lists (inbound/outbound) to protect malicious users from accessing the DB system.
In which subnets, do I place the DB system during deployment?
We highly recommend that you create separate subnets in each Availability Domain and place your DB systems in those subnets. This allows you to precisely define inbound/outbound security lists for the subnet and control network access.
How do I set up TDE for my databases?
DB systems are configured with TDE by default during provisioning. You have the flexibility to log in and control other security policies on the DB system. You can follow the standard database security best practices.
How can I control management access and secure the DB systems?
With Oracle Cloud Infrastructure Identity and Access Management (IAM), you can configure your cloud environment to support your security and compliance requirements. From a database perspective, you configure IAM policies that allow you to restrict access to bare metal and virtual machine DB systems only to a select set of users (DBAs) from a management perspective. Please refer to our technical documentation on how to use Oracle IAM with Oracle Database Cloud Service.
Can I audit the operations that are performed on the DB system?
Yes, with full root access to the DB system you can configure auditing for all operations on the DB system. Oracle Database Cloud Service provides robust audit support in all editions of the database. Audit records include information about the operation that was audited, the user performing the operation, and the date and time of the operation. Audit records can be stored in the database audit trail or in files on the operating system. Standard auditing includes operations on privileges, schemas, objects, and statements.
In addition, you can use Oracle Cloud Infrastructure Audit to audit all the API management calls that were made on your tenancy.
How do I select the correct shape for my database needs?
For the shapes offered today on Oracle Cloud Infrastructure, costs, available storage, performance or the need for Oracle RAC databases will drive your selection within the Database service. Keep your database size growth plan in mind as you select the shape.
Can I change the number of cores associated with the DB system after initial creation?
Yes, for bare metal systems you can change the number of cores used by the DB system from the console directly or through our APIs without any downtime. Core scaling is currently not supported for virtual machines.
Will my instance be restarted when the cores in a bare metal DB system are scaled up or down?
No, the instance is not restarted when scaled up or down. This capability allows you to save costs by reducing the number of cores used when not needed in Development and Test scenarios.
Can I attach block storage volumes to a bare metal server DB system?
No, you cannot attach block storage volumes to a bare metal server DB system. However, the Database Cloud Service on virtual machines services uses remote block volumes for databases that are completely managed by the platform.
Can I SSH into the DB system?
You are provided with full root access to your bare metal and virtual machine system. You can SSH into the DB system by using the SSH key information.
What do I do if the performance of my instance is extremely slow?
Oracle Database Cloud Service offers full root SSH access to the database instance and the capability to define the schemas and any performance tuning on the database instances. You can parse the Oracle trace file to understand the reason behind the slow queries. We also recommend using Enterprise Manager to monitor the performance metrics (CPU utilization, Network Throughput, etc.) of the DB system to understand if there are system level metrics that deviate from normal behavior.
You can get support for debugging and troubleshooting by submitting a service request via My Oracle Support. In addition, you can sign up for Oracle Premium Support, which provides options for 24x7 support. Contact your sales representative for more information.
What is Oracle Cloud Infrastructure Database Cloud Service patching feature?
The Database Cloud Service patching feature simplifies the steps required to patch your DB systems and databases. You can use the Oracle Cloud Infrastructure console and APIs to view applicable patches for your DB system or database home and submit a patching request. The Database Cloud Service will then run the end-to-end patching steps for you while displaying the status.
You can view all patches that have been applied, and if required, re-apply a patch. In addition, you can use Oracle Identity and Access Management (IAM) controls to manage access to patching features.
How can I access the patching feature?
You can use the Oracle Cloud Infrastructure console and Rest APIs to access the feature.
What are the networking requirements to enable patching feature?
Your DB system's cloud network (VCN) must be configured with an Internet Gateway. The network traffic between the DB system and Oracle Object Storage will be on Oracle Database Cloud Service internal servicing backbone
What DB systems, shapes and editions can I patch using the patching feature?
You can use the feature to patch all 1-node and 2-node bare metal DB systems across all shapes and editions. 2-node RAC, VMs, and Exadata Systems are currently not supported. However, you can patch these system by logging on to your host and using the OPatch utility.
What kind of patches can I apply using the patching feature?
Database Cloud Service specific patches for DB systems and database homes can be applied. Only the latest patch is available for DB systems while database homes supports both latest and older patches. You can find the list of currently available DB system and database home patches in the Oracle Cloud Infrastructure technical documentation.
Can I apply patches to all Database Cloud Service database versions?
Yes, if one or more patches are available for those versions. Patches are currently available for 220.127.116.11, 18.104.22.168 and 22.214.171.124 database versions.
How can I apply interim patches or quarterly bundle patches that are not yet supported by the Database Cloud Service?
You can log on to your host and apply interim patches using the OPatch utility. We recommend that you do not apply on-premises quarterly bundle patches using the OPatch utility. These patches may not work without applying additional cloud specific patches. Instead, you should apply cloud-customized quarterly patches that are available through the Oracle Cloud Infrastructure Database Cloud Service console and REST APIs.
How can I patch Virtual Machines and Exadata DB systems and databases?
You can patch these systems by accessing your host and using the OPatch utility. Learn more about the OPatch utility.
Will there be any downtime while a patch is being applied?
Yes, there will be downtime for 1-node DB systems if you have not configured Oracle Data Guard. You should follow the Maximum Availability Architecture (MAA) best practices to avoid any downtime.
What happens if I use the patching feature and patching fails?
Your DB system or database home will be in the ”Available” state if the patch fails. The patch history can indicate the reason the operation failed. To debug the root cause of failure, you can access detailed patching-related logs by accessing your host. If the log information is not helpful in debugging the issue, you can file a request with Oracle Support to help determine the root cause.
How can I learn about the patches that were installed on my DB system or database home using the patching feature?
Do I need to follow a patching order for DB system and database home patches?
Yes, your DB system should be on the same or higher version than your database home. To avoid version conflicts, you should apply DB system patches first, followed by database home patches. If you do not follow this order, you will get an error message while applying the patch.
Can I pre-check or roll back an applied patch using the patching feature?
Yes, you can pre-check a patch before applying. However, to rollback a patch, you need to login to your database host and use OPatch utility.
Can I restrict patching access to a defined set of users?
Yes, you can use Oracle Identity and Access Management (IAM) service to restrict access at a user and group level.
Are there any differences between the Oracle database bundle patches available for on-premises vs. the patches available for Oracle Cloud Infrastructure Database Cloud Service?
Yes, Oracle database bundle patches and Oracle Cloud Infrastructure database patches are different. Oracle Cloud Infrastructure database patches are a superset containing Oracle database bundle patches, Oracle Cloud Infrastructure-specific MLRs (Merge Label Requests), and other patches.
Can I patch my Operating system (OS) using the patching feature?
No, OS patching is currently not supported. You access the host directly to manually patch the OS. Refer to Bare Metal and Virtual Machine DB system OS Updates and Exadata DB system OS Updates documentation for more details.
Are Oracle Cloud Infrastructure Database Cloud Service patches cumulative?
Yes, database patches are cumulative. New Oracle Cloud Infrastructure database patches contain patches from previous DB system or DB Home patches of the same version.
How will Oracle communicate about critical security patches? Will Oracle auto patch my system with a critical security patch?
Oracle Cloud Infrastructure will send email notification informing you about a critical security patch. Depending on the criticality of the patch, we will set a time window for you to apply the security patch.
How long will it take for patching to complete?
This depends on the type of patch. A DB system or database home state will change to ”Available” once a patch has been applied.
Backup and Recovery
How do I set up backup and recovery for my databases?
Backing up your database is a key aspect of any Oracle database environment. There are multiple options available for storing and recovering your backups. You can use the backup and restore feature either within the Oracle Cloud Infrastructure Console, CLI or REST APIs, or manually set up and manage backups using dbcli or RMAN. You can read about all the options in the technical documentation here.
What is the Oracle Cloud Infrastructure Database Cloud Service backup and restore feature?
The database backup and restore feature enables you to use the Oracle Cloud Infrastructure Console, CLI and REST APIs to create and manage backups of your databases. You can also restore your existing database from a backup, or create a new database from a backup.
What are the benefits of using the backup and restore feature vs. managing backups manually?
The backup and restore feature provides Console, CLI and Rest APIs to create and manage backups. When you use the Console, you can create full backups or set up automatic incremental backups with a few clicks. Similarly, you can view your backups and restore your database using the last known good state, a point-in-time, or SCN (System Change Number). You can also create a new database from your backup in an existing or a new DB system.
Is there additional cost associated with using the backup and restore feature?
Your backups are stored in Oracle Cloud Infrastructure Object Storage and the service fees apply for storing your backups. Learn more about Object Storage pricing. There are no additional charges for using the feature.
What database shapes, editions, and database versions are supported by the backup and restore feature?
The backup and restore feature supports all bare metal and virtual machines shapes, editions, and database versions. Exadata is currently not supported. However, for Exadata, you can manually set up RMAN (Recovery Manager) for backup and recovery.
What kind of backups are currently supported by the backup and restore feature?
On-demand full backups and automatic incremental backups are currently supported.
What is the retention period for automatic incremental backups setup using backup and restore feature?
The retention period for automatic incremental backups is 30 days.
Can I set my own backup retention period or frequency of my automatic incremental backups?
No, you cannot control these settings using the backup and restore feature. However, you can use the manual RMAN option to set up custom retention period and frequency.
What is the schedule for automatic incremental backups that you set up using the backup and restore feature?
When you enable automatic backups for a database, Oracle Cloud Infrastructure Database Cloud Service will create the first level 0 backup. After the first backup, level 1 backups will run every day until the next weekend. Every weekend, a new level 0 backup will be created. Automatic backups enabled for the first time after November 20, 2018 on any database will run between 00:00 AM and 06:00 AM in the time zone of the DB system's region. If you have enabled automatic backups on a database before this date, the backup window for the database will continue to be between 00:00 AM and 06:00 AM UTC.
Are the database backups encrypted?
Yes, all your backups are encrypted with the same master key used for TDE encryption.
What measures are taken to ensure that my backups are not lost?
Your backups are stored in Oracle Cloud Infrastructure Object Storage. Oracle Object Storage was designed from the ground up to be highly durable. Data is stored redundantly across multiple storage servers and across multiple Availability Domains. Data integrity is actively monitored using checksums, and corrupt data is detected and auto-repaired. Any loss in data redundancy is automatically detected and self-healed, without any customer impact.
Under what circumstances can my backups fail while using the backup and restore feature?
If you are using the backup and restore feature, your backup operations can fail if the database or DB system is not in an ”Available” state. Actions like patching, SSH key addition, and Data Guard operations can change the DB system or database state. To avoid backup failure, ensure that these actions are not performed during the backup window (00:00 - 06:00 UTC). If an automatic incremental backup fails, the Database Cloud Service retries the backup operation during the next day’s backup window. For a failed on-demand backup, you must manually retry the operation when both DB system and database is available.
What options are available to restore my database from a backup?
If you are using the backup and restore feature, you can restore your database to the latest state, a point-in-time state, or to a committed state of database defined by System Change Number (SCN). However, you can use dbcli or RMAN option for more restore options.
How can I find my SCN?
You can find the SCN number either by accessing your database or accessing any online or archived logs.
Can I create a new database from a backup?
Yes, you can create a new database from a backup in an existing or new DB system. However, the database from which the backup was generated should be deleted before using the backup for this purpose. For a backup from a virtual machine DB system, you should terminate the database instance from which backup was taken before using that backup in a new or an existing DB system.
Can I choose a different DB system, Compartment, or Availability Domain to create a new database from a backup?
Yes, you can choose any existing DB system, or create a new DB system in any compartment. However, the new or the existing DB system should be in the same Availability Domain where your backup is hosted. If you create a new DB system, the Oracle Database software edition you specify must be an equal or greater edition than that of the backed up database. Also, the shape you specify must be the same type as the database from which the backup was taken. For example, if you are using a backup of a 1-node database, then the DB system you select as your target must also be a 1-node DB system.
Are automatic incremental backups enabled by default?
No, automatic incremental backups are not enabled by default. You can enable the option during database creation or at any time after the database is provisioned.
What happens to my backups after I terminate my DB system?
Oracle highly recommends that you terminate all databases in a DB system before you terminate the DB system. When you terminate a database, you can select to create a final backup which will remain in Object Storage as a standalone backup. You can later restore this standalone backup as a new database.
How do I migrate my data from my on-premises Oracle Database to Database Cloud Service?
You can manually set up RMAN to move your database backup to Oracle Cloud Infrastructure Object Storage, and use that backup to create a database in a new or existing DB system.
How do I set up highly available databases with Oracle Database Cloud Service?
You can launch DB systems in different Availability Domains and configure Data Guard for setting up highly available Oracle databases. Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases.
You can review Data Guard for High Availability and Maximum Availability Architecture (MAA) best practices for information about setting up a zero data loss, highly available configuration of Oracle databases.
What is an Availability Domain and why is it relevant for setting up databases on Oracle Database Cloud Service?
An Availability Domain (AD) is the subcomponent of a region designed to be independent and highly reliable. Each AD is built with fully independent infrastructure such as building(s), power generators, cooling equipment, and network connectivity. In the event of extremely uncommon disasters such as fires or flooding, only one AD is affected. In addition, the ADs within the same region are connected with high speed, low latency network, allowing customers to build and run highly reliable applications and workloads with minimum impact to the application latency and performance.
These fault-independent ADs enable customers to build highly available applications in the cloud without sacrificing performance. We highly recommend you place the primary and standby databases in different ADs to ensure they are protected from the common failures illustrated above.
Which Database Cloud Service database editions support Data Guard feature?
All Enterprise database editions support Data Guard. Enterprise Extreme Performance edition supports Active Data Guard.
What are the benefits of setting up Data Guard through Database Cloud Service vs. setting up Data Guard manually?
Database Cloud Service provides Data Guard configuration using the Oracle Cloud Infrastructure console and REST APIs.
In a few clicks, you can enable Data Guard and perform switchover, failover, and reinstate actions. You can also set up granular access control for the feature using Oracle Identity and Access Management Service. There is no cost associated with using this feature
Which shapes and database versions support the Data Guard feature?
All virtual machine and bare metal 1-node and 2-node shapes are supported by the Data Guard feature. Exadata is currently not supported. However, you can set up Data Guard manually for Exadata by logging on to you host and accessing Data Guard command-line interface (DGMGRL). Learn more about DGMGRL.
Which features are currently supported by the Data Guard feature?
Switchover, Failover, and Reinstate features are currently supported. However, you can manually set up Data Guard by logging on to you host and accessing Data Guard command-line interface (DGMGRL). Learn more about DGMGRL.
What protection modes and transport types are supported by the Data Guard feature?
Maximum Performance protection mode and Async transport type are currently supported. However, you can configure additional protection modes and transport types by logging on to the DB system and accessing Data Guard command-line interface( DGMGRL). Learn more about DGMGRL.
What are the network set up pre-requisites for using the Data Guard feature?
To set up Data Guard, both primary and secondary DB systems should be in the same VCN, and port 1521 should be open on both DB systems. DB systems can be in different subnets.
Can I set up Data Guard across Availability Domains?
Yes, you can set up Data Guard in the same or different Availability Domains in a region. However, Oracle recommends that you set up your Data Guard configuration across Availability Domains.
Can I set up Data Guard across Oracle Cloud Infrastructure regions?
Yes, you can set up Data Guard across regions, but the Database Cloud Service Data Guard feature currently does not support it. You can manually set up Data Guard across regions by logging on to your host and using DGMGRL. You must enable an internet gateway on the primary and standby DB system VCN for Data Guard to transport logs across regions. Learn more about DGMGRL.
Can I set up Data Guard across compartments?
No, cross-compartment Data Guard set up is currently not supported.
Should the DB system of primary and standby databases be the same shape and edition?
Yes, to enable a Data Guard association using the Data Guard feature, the standby’s DB system shape and edition should be the same as the primary’s DB system.
What version will the standby database be when created by the Database Cloud service Data Guard feature?
The standby database is created with the same database version as that of the primary.
Can I set up Managed Broker and perform actions like automated switchover using the Data Guard feature?
No, currently the Managed Broker feature is not supported by the Data Guard feature. However, you can manually set up Managed Broker configurations by logging on to your database host and accessing Data Guard command-line interface (DGMGRL). Learn more about DGMGRL.
How can I remove the Data Guard associations using the Data Guard feature?
To remove the Data Guard association using the Data Guard feature, you must first delete the standby database. Once you delete the standby database, the Data Guard association will be removed automatically.
How can I terminate my primary database in a Data Guard set up?
Using the Data Guard feature, you will need to first delete your standby database before you can delete your primary database. Alternatively, you can initiate a switchover operation so the primary is now a standby, and then you can terminate the standby.
Can I create multiple standby databases?
No, you can only create a single physical standby database using the Data Guard feature. However, you can manually create multiple standby databases by logging on to your DB system and accessing DGMGRL. Learn more about DGMGRL.
Can I configure Data Guard between my on-premises database and an Oracle Cloud Infrastructure database?
Yes, you can configure Data Guard between an on-premises database and an Oracle Cloud Infrastructure database. You can manually set up Data Guard between your on-premises database and an Oracle Cloud Infrastructure database using DGMGRL. Learn more about DGMGRL.
Can I control access to Data Guard actions using Oracle Identity and Access Management controls?
Yes, you can control access to Data Guard features using Oracle Identity and Access Management. Learn more about Oracle Identity and Access Management.
How can I patch databases in a primary and standby Data Guard set up?
You can patch database in primary and standby Data Guard set up. You need to manually patch your standby first, and then switch over your primary to patch it.
How can I back up databases in a Data Guard set up?
You can use the Oracle Cloud Infrastructure Database backup and restore feature to back up and restore your primary databases. If you want to enable backup for a standby, you can do so by accessing your standby database host and using RMAN (Recovery Manager).
How can I reinstate my failed primary database back to a primary database state?
Using the Data Guard feature, once you fail over your primary database, it assumes a “Disabled Standby” state. After you fix the issue with this disabled standby, you can reinstate it to a functioning Standby role. Then, you can switch over this standby database back to the primary role.
Can I use my standby instance for read or write operations?
Yes, with Active Data Guard set up, you can use the standby instances for read only operations. Write operations are not enabled on a standby.
How can I learn when my database primary failed over to the standby?
Our recommendation is to use Enterprise Manager for monitoring your DB systems managed by Oracle Cloud Infrastructure. If you enable audit log operations on the instance, you can also view the logs to understand when the primary failed over.
How long does a database failover take?
For 2-node RAC configurations, the failover should be in tens of seconds. However, if the failover is between two instances that are in different ADs with Data Guard, the failover should be less than two minutes.
Does the 2-node RAC shape span across Availability Domains (AD)?
No, the 2-node RAC shape is a set on two servers within the same AD but different racks. Storage is shared across both instances. This set up protects against hardware failures on the instance. For higher availability, we recommend that your set up another 2-node RAC shape in a separate AD.
Can I access the instance to directly look through the logs for any database operation?
Yes, with root access to the DB system, you can review and audit all the operations for the databases on the DB system.