Bare Metal Cloud - Database Services

Oracle DB 12.2 RAC

Database Administrators can now create database deployments that use Oracle Database 12c Release 2 (12.2) to host an Oracle Real Application Clusters (RAC) database.

Oracle Database 12.2 (Cloud First)

Oracle Database 12c Release 2 (12.2.0.1) is now available.

Test it on Oracle Cloud !

MySQL now available in Oracle Cloud

Oracle announced the General Availability of Oracle MySQL Cloud Service
Oracle MySQL Cloud Service, built on Oracle’s proven MySQL Enterprise Edition and powered by the Oracle Public Cloud, provides a simple, automated, integrated and enterprise-ready MySQL cloud service.
Customers can now rapidly, securely and cost-effectively deliver MySQL-based applications in the cloud at global scale !

More information :

• MySQL Blog 
• eBook

Continuous Integration for the Oracle Database with Oracle Developer Cloud Service

Database Deployment Using a Cloud Backup

DBAs can now create an Oracle Database Cloud deployment whose database is taken from a cloud backup.

More information:

• Documentation

DBCS Snapshot

OPC users can now create snapshots of the Oracle Compute Cloud Service storage volumes that support a Database as a Service database deployment hosting a single-instance database.





These snapshots can be used to create database deployments quickly because their storage is linked to the snapshot’s storage using “copy on write” technology provided by Oracle Compute Cloud Service.

Oracle GoldenGate Cloud Service 16.3.1

Oracle GoldenGate Cloud Service 16.3.1 was released today.
In this release, the following new features are supported:

• Cloud to On-Premise Replication (with Socks5 proxy +SSH connection)
• DBaaS with High Memory Compute
  (All DBaaS editions are supported by GGCS)
• GGCS VM Recovery from Shared ZFS Storage
• ...

Oracle Data Guard configuration

With June release, two options for Oracle Data Guard configuration are now available!

High Availability
The primary and standby database are automatically placed in different availability domains to provide isolation at the infrastructure level.

Disaster Recovery
The primary and standby database are automatically placed in different data centers to provide isolation at the infrastructure level and geographical separation to provide availability in the event of catastrophic events.

Create DBCS Instance using REST API

Since my previous post, REST API changed !
The following shows how to create an Oracle Database Cloud Service instance 12g using the REST API:

Documentation:

https://docs.oracle.com/cloud/latest/dbcs_dbaas/CSDBR/op-paas-service-dbcs-api-v1.1-instances-%7BidentityDomainId%7D-post.html#examples

Command:

curl --include --request POST --cacert "D:\Distribs\cacert.pem" --user "user:my_password" --header "X-ID-TENANT-NAME:my_identity_domain" --header "Content-Type:application/json" --data "@D:\OPC_Demo\createMyDB.json" https://dbcs.emea.oraclecloud.com/paas/service/dbcs/api/v1.1/instances/my_identity_domain

Result

createMyDB.json file :

 {
  "serviceName": "DB12RESTDemo",
  "version": "12.1.0.2",
  "level": "PAAS",
  "edition": "EE",
  "subscriptionType": "MONTHLY",
  "description": "VM Created using REST API",
  "shape": "oc3",
  "vmPublicKeyText": "ssh-rsa AAAAB3NzaKvGXmw== rsa-key-20150105",
  "parameters": [
    {
      "type": "db",
      "usableStorage": "15",
      "adminPassword": "Manager12#",
      "sid": "ORCL",
      "pdb": "PDB1",
      "failoverDatabase": "no",
      "backupDestination": "NONE"
    }
  ]
  }
}}

Database Backup & Recovery Configuration

In the Backup and Recovery Configuration section, DBAs choose a backup option for the database deployment.
A new backup destination is now available : Cloud Storage Only
With this option, backups are configured to be created automatically and stored on an Oracle Storage Cloud Service container only.

Database Backup &recovery through the console

With the latest release introduced recently, It's now possible to create backups (full backups) and perform recovery using the Oracle Database Cloud Service console

Exadata Cloud Service - Quarter Rack - Minimum OCPU

Oracle have recently lowered the minimum CPU requirement to 16 for Exadata quarter rack.

Disaster Recovery in the Oracle Cloud Webcast

Join this informative webcast to learn how Oracle Cloud services and Oracle Technologies can ease your High Availability & Disaster Recovery challenges.

Event : Expert Summit Paris 2016

Backup to Oracle Cloud using Enterprise Manager 13c

With Enterprise Manager 13, it's now so easy to perform database backup to Oracle Cloud !

Develop & Deploy Applications in the Cloud

Event : Expert Summit 2016 Paris

DBCS & Timezone

It's now possible to choose the time zone for the new service instance. The default is Coordinated Universal Time (UTC).

RAC now available

Weeks ago, Oracle introduced a 2-node clustered database using RAC (Real Application Clusters)

Selecting 2 OCPU (Trial only) or 4, 8 or 16 OCPU shapes in Service Configuration section will allow Cluster Database creation choice.