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.