By Joel Peréz ACED.gifSkant Gupta

 

This article is brought by en.enmotech.com

Subscribe to our Oracle Cloud Blog: blog.enmotech.com

 

Full Index of Oracle Cloud Articles:

Sir.CloudDBaaSjoelperez

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta's LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

By backing up your Oracle Database Cloud Service database deployments, you can protect the software, configuration and database against loss if a failure occurs. By restoring from a backup, you can restore the deployment's software, configuration, and database to their state at the time of the backup.

 

Database Cloud Service provides a backup feature that backs up:

  • The database
  • Database configuration files
  • Grid Infrastructure configuration
  • Important system and cloud tooling files

 

Storage Container Configuration

 

A container is a storage compartment that provides a way to organize the data stored in Oracle Storage Cloud Service.

Any user with the Service Administrator role can create containers. You should create at least one container for your account. Containers are similar to a directory structure but with a key distinction: unlike directories, containers cannot be nested. By default, all containers are of the standard storage class.

 

Creating a Container Using the Web Console

 

1. Sign in to the Oracle Storage Cloud Service console. Then Click on Open Service Console.

1.jpg

Figure 1:  Storage Cloud Service console

 

2. Click Create Container.

2.JPG

Figure 2: Create Container

 

3. Enter a Name for the container as Backup and Storage Class as Standard.

3.JPG

Figure 3: Create Container details

 

4. Click Create. The container is created and displayed in the console.

4.JPG

Figure 4: displayed container

 

5. Select the container in which you would like to backup the database.

5.JPG

Figure 5: select the container

 

6. Select Enable Upload and Download in the Container Information pane.

Click OK to enable Cross-Origin Resource Sharing (CORS).

6.JPG

Figure 6: Enable upload and download option.

 

Create the new Cloud Database Service using Storage Container

 

1. Login to your Oracle cloud services account, go to the "Oracle Database Cloud Service" page and create a new service.

 

  • For Service Name, select Backup-Storage.
  • From the Service Level list, select Oracle Database Cloud Service.
  • From the Metering Frequency list, select whatever frequency is appropriate for your environment.
  • From the Software Release list, select Oracle Database 12c Release1.
  • From the Software Edition list, select Enterprise Edition.
  • From the Database Type list, select Single Instance.

 

Then click Next to continue.

7.JPG

Figure7: Creating a new service (Backup-Storage)

 

2. In the Service Details screen, do the following:

  • For DB Name (SID), enter ORCL.
  • For PDB Name, enter PDB1.
  • Set an administrative password of your choice and confirm the password (this will be your sys password).
  • For Usable Database Storage (GB), enter 25.
  • From the Compute Shape list, select OC3 -1 OCPU, 7.5GB RAM (this is the bare minimum required).
  • For SSH Public Key, enter rsa-key-20170111.pub.
  • From the Backup Destination list, Select Cloud Storage Only.
  • For Cloud Storage Container, enter Storage-ustechnolo/Backup.
  • For Username, enter <registered mail>.
  • For Password, enter <your password>.

 

Then click Next to continue.

8.JPG

Figure 8: Specifying the service details

 

3. Finally, review the configuration and click Create to create your cloud database.

9.JPG

Figure 9: Creating the cloud database instance

 

After a few minutes, the cloud database instance has been created successfully.

10.JPG

Figure 10: The cloud database has been created

 

4. Click the service name (Backup-Storage) to open the main page of the database.

11.JPG

Figure 11: Main page of the cloud database

 

Create the Backup of Cloud Database

 

      1. On the main page and select the Administration Pane.

12.JPG

Figure 12: Administration section

 

2. Click on Backup Now button to create a backup of the database.

13.JPG

Figure 13: backup initiated

 

3. After a few minutes, Backup has completed.

14.JPG

Figure 14: available backup

 

4. Switch to the Storage Container, you will see bunch of files created for backup.

15.JPG

Figure 15: files at storage container

 

Deleting a Database Deployment and Backup sets from Storage Container

When you no longer require a database deployment on Oracle Database Cloud Service, you can delete it.

To delete a database deployment:

 

1. Open the Oracle Database Cloud Service console.

16.JPG

Figure 16: service console

 

2. Select Delete from the   service menu corresponding with the database deployment that you want to delete.

17.JPG

Figure 17: delete option from Menu

 

3. You are prompted to confirm the deletion. Use the confirmation dialog to confirm that you want to delete the database deployment. Optionally, you can also select the option to delete the backups associated with the database deployment.

19.JPG

Figure 18: selecting the delete backups

 

Note: The option to delete the backups associated with the database deployment only exists for deployments that are created using Database Cloud Service release 17.1.5 or later.

 

Once deleted, the entry is removed from the list of database deployments displayed on the Oracle Database Cloud Service console. Also Backup sets has deleted from Storage Container.

18.JPG

Figure 19: empty storage container

 

Conclusion

So, now you know that it is very easy to perform Migration Using Data Pump Conventional Export/Import on Oracle Cloud Creating and Deleting the backup sets of the Database on Oracle Cloud.

We hope this article is useful and we invite you to continue reading our next publications focused on Oracle Cloud.

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta's LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

Full Index of Oracle Cloud Articles:

Sir.CloudDBaaSjoelperez

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events  like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.com