Oracle DBCS : Create A Database Deployment With Automatic Backup

When creating a new database deployment on Oracle Database Cloud Service, you have option to choose whether you want to configure automatic backup or not. The options are as follows:

• Both Cloud Storage and Local Storage

30 days worth of backups are kept and the 7 most recent days worth available directly on the compute node’s local storage. 

• Cloud Storage Only

30 days worth of backups are kept with all backups on cloud storage container.

• None

No automatic Backup are configured

In this article we will demonstrate how to Create A Database Deployment with Automatic Backup configured using Create Service Wizard.

Prerequisites:

• Oracle Account
• Oracle Cloud Subscription
• SSH Public/Private Key pair
• Oracle Storage REST Endpoint

Steps to Create a Database Deployment

• Open a web browser and enter the URL you received in the Welcome email to login to Oracle Cloud Account

• Enter your username and password

• Get the REST Endpoint by connecting to Container Classic. This REST Endpoint will be used when creating the Database Deployment.

• Open the Service Console from the Database Server as show below

• Click on "Create Service"

• Fill in all the details and click Next
• Service Name: Enter the service name, It only accepts hyphen (-) as special character
• Description (optional): Enter a description on the service
• Notification Email: To send the update on Instance creation
• Service level: Oracle Database Cloud Service
• Metering Frequency: Monthly or Hourly
• Software Release: 11gR2, 12cR1 or 12cR2
• Software Edition: Enterprise, standard, Enterprise Edition - Extreme performance or Enterprise Edition - High performance
• Database Type: Single Instance, Single Instance with Data Guard, RAC, RAC with Data Guard, Hybrid DR

Once the information is filled, Click Next.

• Fill in all the details 
• DB Name: This will be your container DB name
• PDB Name: This will be your pluggable DB name
• Administrator password: This will be your administrator password for users sys, system, dbaas_monitor and so on
• Backup and Recovery Configuration: Cloud and Local, Cloud only or None
• Compute Shape: select the configuration you need for your business
• SSH Public Key: choose the public key you generated in steps

Once the information is filled, Click Next.

• Review the Summary and click "Create"

• At this moment the Service creation is in progress. Click on the Service Name

• This page shows that the provisioning is in-progress. Click on Oracle Database Cloud Services to go back to the home page

• The service has been created successfully

• Up on the completion you will also receive the email that the service is created and is now available for use

• Connect to the Compute node and verify the database.

Conclusion

In this article we have learned how to create a database deployment and configure automatic backups in Oracle Database Cloud Service.