Using Oracle Database Backup Cloud Service

Version 1

    by Dean Halbeisen

     

    Oracle Database Backup Cloud Service provides secure and scalable storage for backing up Oracle Database to Oracle Cloud. This article provides information on getting started using Oracle Database Backup Cloud Service.

     

    Table of Contents

     

    Introduction

     

    The procedures in this article work on any system type, and they have been verified on Oracle's SPARC servers, Oracle MiniCluster, Oracle SuperCluster, and Oracle Exadata systems.

     

    For more detailed information, refer to the Oracle Database Backup Cloud Service online documentation.

     

    The procedures in this article assume the following steps have already been completed:

     

    • Oracle Enterprise Manager 13c has been installed.
    • Oracle Database has been installed and a database has been registered with Oracle Enterprise Manager 13c.

     

    Getting Started with Database Backup and Recovery

     

    The following steps illustrate how to get started with database backup and recovery using Oracle Enterprise Manager Cloud Control 13c.

     

    1. From the Oracle Enterprise Manager Cloud Control 13c dashboard, select Targets > Databases.

      f1.png

      Figure 1. Choose Databases from the list of targets.

       

    2. Select a database target. This example uses the database target oosbur1z3o.

      f2.png

      Figure 2. Select a database target.

       

    3. To configure the backup settings for this database, select Availability > Backup & Recovery > Backup Settings.

      f3.png

      Figure 3. Select the option to configure backup settings.

       

    4. Log in to the database using the saved credentials from the database setup procedure. Enter the username and password and then click Login.

      f4.png

      Figure 4. Log in to the database.

       

    5. Click the Oracle Cloud Backup Service Settings link to configure the settings.

      f5.png

      Figure 5. Configure Oracle Cloud Backup settings. (Note: In the screenshot above, "Oracle Cloud Backup Service" should instead say "Oracle Database Backup Cloud Service.")

       

    6. Complete the Oracle Cloud Backup Service Settings page. Enter the requested information, and then click Save.

      f6.png

      Figure 6. Enter the Oracle Cloud Backup Service settings.

       

    7. Click OK to confirm the Oracle Cloud Backup Service settings have been saved.

      f7.png

      Figure 7. Confirm the Oracle Cloud Backup Service settings have been saved.

       

    8. Enter database host credentials: Under the Host Credentials section, enter the username and password, select None for Run Privilege, and enter the name for the backup job in the Save As field. Then click Submit to submit the job.

      f8.png

      Figure 8. Enter database host credentials and submit the job.

       

    9. A hyperlink for the job is displayed. Click this link to monitor the backup configuration procedure.

      f9.png

      Figure 9. Monitor the backup configuration procedure using the provided hyperlink.

       

    10. View the backup configuration procedure results and details.

      f10.png

      Figure 10. Backup configuration procedure results and details.

       

    11. Click Cancel to exit the Oracle Cloud Backup Service settings page.

      f11.png

      Figure 11. Oracle Cloud Backup Service settings.

       

    Scheduling a Backup

     

    The following steps illustrate how to schedule a backup using Oracle Enterprise Manager Cloud Control 13c.

     

    1. To schedule a backup, select Availability > Backup & Recovery > Schedule Backup.

      f12.png

      Figure 12. Schedule a backup.

       

    2. Click Schedule Oracle-Suggested Backup.

      f13.png

      Figure 13. Select the option for an Oracle-suggested backup.

       

    3. Choose the destination media. Select the Tape option, and then click Next.

      f14.png

      Figure 14. Choose the destination media.

       

    4. Update the tape settings as desired, and then click Next. This example uses 16 tape drives and a recovery window of 8 days.

      f15.png

      Figure 15. Update the tape settings.

       

    5. Update the schedule settings as desired, and then click Next.

      f16.png

      Figure 16. Update the schedule settings.

       

    6. Review the settings, and then click Submit Job.

      f17.png

      Figure 17. Review the settings and submit the backup job.

       

    Oracle Database Backup Cloud Service Management and Monitoring

     

    This section provides an example of managing the cloud-related portion of the database backup and recovery service. The next section shows how to manage and monitor the database backup and recovery activity.

     

    The following steps illustrate how to perform management and monitoring of backup processes in Oracle Cloud.

     

    1. Go to cloud.oracle.com and sign in to your Oracle Cloud account.

      f18.png

      Figure 18. Sign in to Oracle Cloud.

       

      The Oracle Cloud My Services dashboard is displayed.

       

      f19.png

      Figure 19. The Oracle Cloud My Services dashboard.

       

    2. Customize the Oracle Cloud My Services dashboard. Click Customize Dashboard, and then drag the Database Backup module to the upper left of the dashboard for ease of access.

      f20.png

      Figure 20. Customize the Oracle Cloud My Services dashboard.

       

    3. Display the Oracle Database Backup Service overview by clicking either the title or the graph in the Database Backup module (see Figure 20).

      f21.png

      Figure 21. Oracle Database Backup Service overview.

       

    4. Click the Billing Metrics tab on the left to display billing metrics for this database backup service.

      f22.png

      Figure 22. Billing metrics for Oracle Database Backup Service.

       

    5. Click the Documents tab on the left to display billing history (if any) for this database backup service.

      f23.png

      Figure 23. Documents for the Oracle Database Backup Service.

       

    Backup and Recovery Management and Monitoring

     

    The following steps illustrate how Oracle Enterprise Manager Cloud Control 13c can be used to manage and monitor backup and recovery of databases to Oracle Cloud.

     

    1. Open the Oracle Enterprise Manger Cloud Control 13c dashboard, and then click the Last Backup link (on the right of the dashboard) to display information about the most recent backup.

      f24.png

      Figure 24. Use the Last Backup link to display information about the most recent backup.

       

    2. A list of database backups is displayed. Click the link for a backup job to display detailed job reporting. This example selects the most recent backup (the top entry in the list).

      f25.png

      Figure 25. Select a job from the list of backup jobs for a database.

       

    3. View detailed job reporting for the selected backup job.

      f26.png

      Figure 26. Detailed backup job information.

       

    4. To manage scheduling with Oracle Enterprise Manager Cloud Control 13c, select Enterprise > Job > Activity.

      f27.png

      Figure 27. Manage scheduling with Oracle Enterprise Manager.

       

    5. A list of jobs is displayed. You can click the name of a backup job to edit that job's schedule.

      f28.png

      Figure 28. Display job activity.

       

    See Also

     

    For more information, please see the following resources:

     

     

    About the Author

     

    Dean Halbeisen is a solutions manager at Oracle. He has over 20 years of IT experience and is an expert in enterprise computing solutions, most recently applying these practices to next-generation data center solutions, integrated systems, and Oracle engineered systems. In his current role, he is responsible for solution architecture and development around Oracle Optimized Solutions, including communicating about Oracle's systems, solutions, technology strategies, and roadmaps to customers, partners, and internal stakeholders.