Forum Stats

  • 3,727,079 Users
  • 2,245,318 Discussions
  • 7,852,571 Comments

Discussions

Database Backups with Oracle Secure Backup and StorageTek Tape Systems

steph-choyer-Oracle
steph-choyer-Oracle Member Posts: 101
edited May 2017 in Optimized Solutions

by Dean Halbeisen

This article is a click-by-click walk-through illustrating how to get started with database backups using Oracle Secure Backup and Oracle's StorageTek Tape systems with Oracle Enterprise Manager Cloud Control 13c.

Table of Contents
image

Introduction

This article starts at the point where the installation and configuration of the initial system and applications have been completed. The following steps must be completed before the steps provided in this article can be used.

  • The system (such as Oracle MiniCluster) must be installed and configured.
  • The database must be installed and configured.
  • Oracle Secure Backup must be installed and configured with disk pools and tape storage.
  • Oracle Enterprise Manager 13c host agents must be installed on each system.
  • The Oracle Secure Backup plugin for Oracle Enterprise Manager 13c must be promoted on the Oracle Secure Backup administrative server in the Oracle Secure Backup domain.

Getting Started with Database Backup and Recovery

The following sections illustrate how to configure backup settings and schedule a database backup using the Oracle Enterprise Manager Cloud Control 13c GUI.

Configure Backup Settings

The following steps walk through the process to configure backup settings using the Oracle Enterprise Manager Cloud Control 13c GUI.

  1. Select Targets > Databases.

    f1.png

    Figure 1. Navigate to the screen where you can select databases.

  2. Select the database. This example selects orcl.HOL.COM.

    f2.png

    Figure 2. Select the database.

  3. Select Availability > Backup & Recovery > Backup Settings.

    f3.png

    Figure 3. Select the option to edit backup settings.

  4. Enter the credentials used to connect to the database, and then click Login.

    f4.png

    Figure 4. Enter the credentials used to connect to the database.

  5. In the Host Credentials pane, do the following:

    a. Select New and enter the username and password.

    b. Click Save As to save these credentials, and select the checkbox to set them as the preferred credentials.

    c. Click Apply to continue.

    f5.png

    Figure 5. Configure host credentials to connect to the database host.

  6. Select Configure to configure Oracle Secure Backup for the database.

    f6.png

    Figure 6. Configure Oracle Secure Backup for the database.

  7. Provide Oracle Secure Backup credentials (saved from setup), and then click OK to continue.

    f7.png

    Figure 7. Provide Oracle Secure Backup credentials.

  8. Select an Oracle Secure Backup domain target, and click OK to continue.

    f8.png

    Figure 8. Specify the Oracle Secure Backup domain target.

  9. On the Backup Storage Selectors screen, click Add.

    f9.png

    Figure 9. Add a storage selector.

  10. On the Add Backup Storage Selector screen, select all database types (archive logs, auto backup, full, and incremental), and then click OK to continue.

    f10.png

    Figure 10. Configure the storage selector.

  11. Click Return to exit the Backup Storage Selectors screen.

    f11.png

    Figure 11. Exit the Backup Storage Selectors screen.

  12. Click Apply to save the backup settings.

    f12.png

    Figure 12. Save the backup settings.

Schedule a Backup

The following steps walk through the process to schedule a backup using the Oracle Enterprise Manager Cloud Control 13c GUI.

  1. Select Availability > Backup and Recovery > Schedule Backup.

    f13.png

    Figure 13. Choose the Schedule Backup option.

  2. Click Schedule Oracle-Suggested Backup.

    f14.png

    Figure 14. Choose the option to schedule an Oracle-suggested backup.

  3. Review the backup options and click Next to continue. This example uses the default options.

    f15.png

    Figure 15. Configure backup options.

  4. Select Tape and then click Next to continue.

    f16.png

    Figure 16. Select tape as the destination media.

  5. Review the backup schedule, and then click Next to continue. This example uses the default settings of an immediate, one-time backup.

    f17.png

    Figure 17. Select the backup schedule.

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

    f18.png

    Figure 18. Submit the backup job.

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.

Sign In or Register to comment.