Tuesday 22 January 2019

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.

4 comments:

  1. automatic backup really help because sometime a person forget to take backup. and you explained very well. thanks for sharing.
    oceanapart technologies - databackup & transfer

    ReplyDelete
    Replies
    1. Netsoftmate Technical Blog : Oracle Dbcs : Create A Database Deployment With Automatic Backup >>>>> Download Now

      >>>>> Download Full

      Netsoftmate Technical Blog : Oracle Dbcs : Create A Database Deployment With Automatic Backup >>>>> Download LINK

      >>>>> Download Now

      Netsoftmate Technical Blog : Oracle Dbcs : Create A Database Deployment With Automatic Backup >>>>> Download Full

      >>>>> Download LINK fL

      Delete
  2. vCloud Tech provides enterprise endpoint backup solutions from its industry leading partners to protect your system’s data from deletion, corruption and cyber-attacks.

    ReplyDelete
  3. Netsoftmate Technical Blog : Oracle Dbcs : Create A Database Deployment With Automatic Backup >>>>> Download Now

    >>>>> Download Full

    Netsoftmate Technical Blog : Oracle Dbcs : Create A Database Deployment With Automatic Backup >>>>> Download LINK

    >>>>> Download Now

    Netsoftmate Technical Blog : Oracle Dbcs : Create A Database Deployment With Automatic Backup >>>>> Download Full

    >>>>> Download LINK ev

    ReplyDelete

Comparing Oracle Database Appliance X8-2 Model Family

September 2019 Oracle announced Oracle Database Appliance X8-2 (Small, Medium and HA). ODA X8-2 comes with more computing resources com...