Backup with OEM   «Prev  Next»

Lesson 4Schedule a backup in Enterprise Manager
ObjectiveDescribe the requirements to schedule a backup with an Enterprise Manager job.

Scheduling a Backup with Enterprise Manager in Oracle 12c: Requirements Breakdown

As a Database Administrator (DBA) using Oracle 12c, utilizing Oracle Enterprise Manager (OEM) Cloud Control to schedule backups is an essential capability that ensures the resilience and reliability of your data assets. Before you can seamlessly configure a backup job via OEM, there are a series of prerequisites and requirements to be met:
  1. Oracle Enterprise Manager Cloud Control Installation: Ensure that you have a functioning installation of Oracle Enterprise Manager Cloud Control. This tool offers a centralized management interface for your Oracle environments.
  2. Proper Agent Deployment: The Oracle Management Agent (OMA) should be correctly deployed on the target database server. This agent facilitates communication between the OEM Cloud Control and the Oracle Database.
  3. Configuration of the Oracle Recovery Manager (RMAN):
    • RMAN Repository Before initiating a backup, ensure that the RMAN repository, which stores backup metadata, is configured. It can be a part of the target database or a separate dedicated catalog database.
    • Backup Destination Ensure that you've determined and configured the backup destinations (disk or tape) and have adequate storage allocated.
  4. Backup Strategy in Place: It's imperative to decide upon the type of backup (full, incremental, cumulative) and a backup retention policy based on your organization's Recovery Time Objective (RTO) and Recovery Point Objective (RPO).
  5. Access Privileges:
    • SYSDBA Role The Oracle account used within OEM to perform the backup needs to have SYSDBA privileges on the target database.
    • EM_ADMIN Role In OEM Cloud Control, the account should have the EM_ADMIN or EM_OPERATOR role for backup and recovery operations.
  6. Oracle Suggested Backup Configuration: This is an optional but recommended feature in Oracle 12c. The Suggested Backup configuration helps in implementing Oracle’s best practices for backup, especially if you're unfamiliar with RMAN settings.
  7. Required Backup Scripts or Templates: While Oracle Enterprise Manager provides built-in tools to create backups, advanced DBAs may want custom RMAN scripts or use predefined backup templates tailored to their needs.
  8. Network Configuration (if using remote storage): Ensure that the network configuration allows for a seamless transfer of backup data, especially if backups are being transferred to a remote location or network-attached storage.
  9. Notification Settings: Determine your alert and notification preferences. Decide on the conditions under which you wish to receive notifications (e.g., job completion, failures, warnings).
  10. Testing Environment: Before scheduling a production backup, it is a best practice to test the backup job in a non-production environment to ensure it completes successfully and meets the desired backup objectives.
Scheduling a backup via Oracle Enterprise Manager in Oracle 12c necessitates a holistic approach that includes preparation, configuration, and post-setup considerations. Meeting the above requirements ensures that backups are not only scheduled effectively but are also aligned with best practices, ensuring data safety and recoverability.

DBA Tasks | Importing, Exporting, Loading, Backing up, Recovering Data

For conducting database administration tasks such as importing, exporting, loading, backing up, and recovering data, the DBA Management Pack offers Backup Management tools and Data Management tools. These Wizards make the DBA Management Pack applications easy to use. The wizards can be launched from the OEM console as well as from Schema Manager or Storage Manager, as long as these applications are connected to the Oracle Management Server. The Backup Wizard is used for backing up one or more databases, tablespaces, datafiles, or archive log files. The Wizard prompts you to specify the time and frequency to run the backup, as well as the backup configuration and target database(s), then sends your specifications to the job scheduling system for execution. The Backup Wizard provides an intuitive GUI for the backup facility of Recovery Manager, an extremely powerful and flexible command line backup, and a recovery utility designed for the Oracle8 database. This Wizard guides you through the entire backup process. Before attempting to use the Backup Wizard, however, make sure the following requirements are met:
  1. The Oracle target database you want to backup is version 8 or later.
  2. The application is connected to a Management Server.
  3. The preferred credentials are either SYSDBA or that you have created a backup.
  4. The job and event systems are fully functional.

Backup Wizard

The Strategy Choice page allows you to specify whether you want to use a predefined backup strategy or customize your own.
There are two options to choose from:
  1. Predefined backup strategy: Select the appropriate backup strategy.
  2. Customize backup strategy: Select the information you want to backup and the schedule for the execution of the backup.

We will examine both of these strategies in detail as we proceed through this module.
Oracle Backup and Recovery Solutions
Oracle Backup and Recovery Solutions

The next lesson describes backup strategies and options.