Lesson 5	Backup Management with Enterprise Manager Cloud Control
Objective	Configure, monitor, and perform backup and recovery operations using Oracle Enterprise Manager Cloud Control 13c

Managing Backups with Enterprise Manager Cloud Control 13c

Oracle Enterprise Manager Cloud Control 13c provides centralized backup and recovery management for Oracle Database environments, enabling DBAs to configure automated backup policies, monitor backup operations across database fleets, perform guided recovery procedures, and generate compliance reports—all through a unified web-based console. For organizations managing multiple Oracle databases, Enterprise Manager eliminates the need to configure backups individually on each database server, instead providing enterprise-wide policies, scheduling, and monitoring from a single interface.

This lesson demonstrates practical backup and recovery operations in Enterprise Manager Cloud Control 13c for Oracle 23ai environments, including backup job configuration, policy management, fleet-wide monitoring, guided recovery workflows, and compliance reporting. Whether managing a handful of departmental databases or hundreds of enterprise instances, Enterprise Manager streamlines backup administration while ensuring consistent protection across your Oracle estate.

Why Use Enterprise Manager for Backup Management

While RMAN command-line operations provide maximum flexibility, Enterprise Manager Cloud Control offers significant advantages for enterprise backup management:

Centralized Management

Single console: Manage backups for all databases from one web interface
Fleet-wide policies: Apply consistent backup strategies across hundreds of databases
Unified monitoring: View backup status for entire database estate in real-time
Centralized reporting: Generate compliance reports across all managed databases

Simplified Operations

Guided wizards: Step-by-step backup configuration without writing RMAN scripts
Template-based policies: Reusable backup configurations applied to multiple targets
Automated scheduling: Set-and-forget backup schedules with automatic execution
Visual monitoring: Dashboards show backup health, trends, and failures at a glance

Enterprise Features

Multi-database jobs: Execute backup operations across multiple databases simultaneously
Role-based access: Delegate backup management to team members with appropriate permissions
Compliance frameworks: Verify backup policy adherence for regulatory requirements
Alert integration: Automatic notifications for backup failures via email, SNMP, or custom scripts

Accessing Enterprise Manager Cloud Control

Enterprise Manager Cloud Control 13c is accessed through a web browser, requiring no client software installation:

Logging In

Open web browser and navigate to Enterprise Manager URL:
```
https://<em-server>:7803/em
```
Enter credentials: Username and password for Enterprise Manager administrator account
Click Login: Access the Cloud Control home page

Navigating to Database Backup Management

To manage backups for a specific database:

From the top menu, select: Targets → Databases
Locate target database in the database list
Click database name to open Database Home page
From database menu, expand: Availability
Select: Backup and Recovery

The Backup and Recovery page provides access to all backup management features including job scheduling, policy configuration, backup reports, and recovery operations.

Configuring Automated Backup Jobs

Enterprise Manager provides wizards for configuring automated backup jobs that execute on defined schedules without manual intervention.

Creating a Standard Backup Job

Step-by-step procedure:

Navigate to Backup and Recovery for target database
Click "Schedule Backup" button
Backup Type Selection:
- Full Backup: Complete database backup (recommended for weekly schedule)
- Incremental Backup: Changed blocks only (recommended for daily schedule)
- Customized Backup: Advanced options for specific tablespaces or datafiles
Select appropriate backup type and click Next
Backup Configuration Options:
- Include archived redo logs: Check this option (required for complete recovery)
- Delete archived logs after backup: Check if disk space is limited
- Also backup all recovery files: Includes control files and SPFILE
- Check for block corruption: Recommended for data integrity verification
Configure options and click Next
Backup Destination Settings:
- Disk: Select for backup to file system or ASM
  - Specify Fast Recovery Area or custom directory
  - Configure parallelism (number of channels)
- Tape: Select for backup to tape library
  - Configure media management library
  - Specify tape device parameters
- Cloud: Select for backup to OCI Object Storage
  - Configure cloud credentials
  - Specify bucket name and region
Configure destination and click Next
Advanced Backup Options:
- Compression: Enable to reduce backup storage (MEDIUM recommended)
- Encryption: Enable for sensitive data protection
- Section size: For large datafiles, specify section size for parallel backup
Configure advanced options and click Next
Schedule Definition:
- One Time: Execute backup immediately or at specific date/time
- Repeating: Configure recurring schedule
  - Frequency: Daily, Weekly, Monthly
  - Start time: Specify time during maintenance window
  - Days: Select specific days for weekly schedules
Configure schedule and click Next
Credentials:
- Select preferred credentials or enter database credentials
- Username: User with SYSDBA or SYSBACKUP privilege
- Select "Save as Preferred Credential" for future jobs
Enter credentials and click Next
Review and Submit:
- Review backup job configuration summary
- Verify schedule, destination, and options
- Click Submit to create backup job

Enterprise Manager creates the backup job and begins execution according to the defined schedule. The job appears in the Job Activity page for monitoring.

Example Backup Strategy Configuration

Recommended enterprise backup schedule:

Frequency	Backup Type	Schedule	Configuration
Weekly	Full (Level 0)	Sunday 2:00 AM	Disk destination, compression enabled, archived logs included
Daily	Incremental (Level 1)	Mon-Sat 2:00 AM	Disk destination, differential incremental, archived logs included
Hourly	Archived Logs Only	Every 4 hours	Backup to disk, delete after backup if space limited
Monthly	Full to Cloud	First Sunday 3:00 AM	OCI Object Storage, compression and encryption enabled

This layered approach provides daily incremental backups for quick recovery, weekly full backups for baseline protection, and monthly cloud backups for disaster recovery.

Backup Policy Management

Enterprise Manager enables creation of reusable backup policies that can be applied to multiple databases, ensuring consistent protection across your database fleet.

Creating Backup Policies

Backup policies define standard backup configurations that can be applied to multiple targets:

Navigate to: Enterprise → Provisioning and Patching → Database Provisioning
Select: Backup Policies
Click: Create Policy
Configure policy parameters:
- Policy name and description
- Backup type and frequency
- Retention settings
- Destination configuration
- Compression and encryption options
Save policy for reuse across multiple databases

Applying Policies to Database Targets

Once created, policies can be applied to individual databases or groups:

Navigate to target database Backup and Recovery page
Click: Apply Policy
Select policy from available policies list
Review configuration and click Apply

Policy changes automatically propagate to all databases using that policy, ensuring consistent backup protection across the fleet.

Retention Policy Configuration

Configure automatic backup retention and deletion:

-- Via Enterprise Manager interface:
Settings → Backup Settings → Retention Policy

Options:
- Recovery Window: Keep backups for N days of point-in-time recovery
- Redundancy: Keep N copies of each backup
- Apply to Archived Logs: Automatically delete archived logs after backup

Example configuration:

Recovery Window: 30 days
Redundancy: Keep 2 copies of each backup
Delete obsolete backups automatically

Monitoring Backup Operations

Enterprise Manager provides comprehensive monitoring capabilities for tracking backup job execution, identifying failures, and analyzing backup trends.

Job Activity Monitoring

Monitor active and completed backup jobs:

Navigate to: Enterprise → Job → Activity
Filter by: Job Type = "Backup"
View job status:
- Running: Jobs currently executing
- Scheduled: Jobs waiting to execute
- Succeeded: Completed successfully
- Failed: Completed with errors
Click job name for detailed execution information:
- RMAN output log
- Execution duration
- Bytes backed up
- Compression ratio
- Error messages (if failed)

Backup Reports

Access comprehensive backup reports for compliance and analysis:

From database Availability menu, select Backup Reports:

Backup Status Report: Shows all backups for selected database with status, size, and completion time
Backup Summary: High-level overview of backup coverage and recoverability
Recovery Window Report: Verifies point-in-time recovery capability within defined window
Obsolete Backups Report: Lists backups eligible for deletion based on retention policy

Fleet-Wide Backup Monitoring Dashboard

Monitor backup status across all managed databases:

Navigate to: Enterprise → Summary → Backup Dashboard
View fleet metrics:
- Databases with successful backups in last 24 hours
- Databases with backup failures
- Databases missing backups
- Backup storage consumption trends
Drill down on any metric to view affected databases

Configuring Backup Alerts

Set up automatic notifications for backup failures:

Navigate to: Setup → Notifications → Rules
Create notification rule:
- Type: Job-related events
- Condition: Job status = Failed
- Target: All databases or specific database group
- Notification method: Email, SNMP trap, or custom script
- Recipients: DBA team email addresses

Enterprise Manager automatically sends alerts when backup jobs fail, enabling rapid response to backup issues.

Performing Recovery Operations

Enterprise Manager provides guided recovery wizards that simplify complex restore and recovery scenarios.

Complete Database Recovery

Recover entire database to current state after media failure:

Navigate to database: Availability → Perform Recovery
Recovery Type Selection:
- Select Whole Database
- Click Next
Recovery Point:
- Current Time: Recover to latest available state (most common)
- Prior Point in Time: Specify date/time or SCN for incomplete recovery
Select recovery point and click Next
Restore Configuration:
- Enterprise Manager analyzes available backups
- Displays optimal restore path
- Shows required backups and archived logs
- Verify configuration and click Next
Credentials:
- Enter host credentials (to shutdown/startup database)
- Enter database credentials (SYSDBA privilege)
- Click Next
Review and Submit:
- Review recovery operations to be performed
- Estimated recovery duration displayed
- Click Submit to begin recovery

Enterprise Manager orchestrates the complete recovery process: shutting down the database, restoring required datafiles from backup, applying archived redo logs, and opening the database.

Tablespace Point-in-Time Recovery (TSPITR)

Recover specific tablespace to prior point without affecting rest of database:

Select Recovery Type: Tablespace Point-in-Time
Select tablespace(s) to recover
Specify recovery time (date/time or SCN)
Review auxiliary destination (temporary location for recovery)
Submit recovery job

TSPITR is useful for recovering from logical errors affecting specific tablespaces without performing full database recovery.

Block Media Recovery

Recover individual corrupted blocks without restoring entire datafiles:

Corruption detected automatically via alert or validation job
Navigate to: Availability → Perform Recovery
Select: Block Recovery
Review corrupted blocks detected by Data Recovery Advisor
Click Recover to repair blocks automatically

Block recovery minimizes downtime by restoring only corrupted blocks while database remains online for unaffected data.

Data Recovery Advisor Integration

For complex failures, Data Recovery Advisor provides automated diagnosis and repair:

Failure detected automatically or via manual check
Navigate to: Availability → Advisors → Data Recovery Advisor
View detected failures with severity and impact assessment
Click "Advise" to generate repair recommendations
Review repair options:
- Automatic repair (recommended when available)
- Manual repair with RMAN commands displayed
Execute repair directly from advisor interface

Compliance and Reporting

Enterprise Manager provides compliance frameworks for verifying backup policy adherence across database fleets.

Backup Compliance Standards

Define organizational backup standards and verify compliance:

Navigate to: Enterprise → Compliance → Library
Create Compliance Standard:
- Standard name: "Corporate Backup Policy"
- Define rules:
  - Full backup within last 7 days
  - Incremental backup within last 24 hours
  - Archived logs backed up and available
  - Backup encryption enabled for production databases
  - Recovery window of 30 days maintained
Associate standard with database targets or groups
Schedule compliance evaluation (daily recommended)

Generating Compliance Reports

Create executive-level compliance reports for auditors:

Navigate to: Enterprise → Compliance → Results
Select compliance standard (e.g., "Corporate Backup Policy")
View compliance dashboard:
- Percentage of databases in compliance
- List of non-compliant databases with specific violations
- Compliance trends over time
Generate report:
- Select report format (PDF, HTML, Excel)
- Include compliance score and violation details
- Export for audit documentation

Regulatory Compliance Reporting

Enterprise Manager supports compliance reporting for common regulatory frameworks:

SOX (Sarbanes-Oxley): Demonstrate backup protection for financial data
HIPAA: Verify encrypted backups for protected health information
PCI-DSS: Document backup and retention policies for payment card data
GDPR: Show data protection measures and recovery capabilities

Cloud Backup Integration

Enterprise Manager Cloud Control 13c integrates with Oracle Cloud Infrastructure for hybrid backup strategies.

Configuring Cloud Backup Destinations

Set up backup to OCI Object Storage:

Prerequisites:
- OCI account with Object Storage bucket created
- Oracle Cloud credentials configured
- Network connectivity from database server to OCI
Configure cloud credentials in Enterprise Manager:
- Navigate to Setup → Cloud → Cloud Credentials
- Add OCI credentials (tenancy, user, fingerprint, private key)
Create cloud backup job:
- Select "Cloud" as backup destination in Schedule Backup wizard
- Choose OCI Object Storage
- Select bucket and region
- Configure backup schedule

Hybrid Backup Strategies

Combine on-premises and cloud backups for optimal protection:

Backup Type	Destination	Frequency	Purpose
Incremental	Local Disk/FRA	Daily	Fast local recovery
Full	Local Disk/FRA	Weekly	Local baseline backup
Full	OCI Object Storage	Monthly	Off-site disaster recovery
Archived Logs	OCI Object Storage	Every 6 hours	Point-in-time recovery

This strategy provides fast local recovery while maintaining off-site cloud copies for disaster scenarios.

Managing Autonomous Database Backups

For Autonomous Database instances, view automatic backup status through Enterprise Manager:

Add Autonomous Database as managed target in Enterprise Manager
View automatic backup configuration:
- Daily full backups (automatic)
- Continuous incremental backups every 5 minutes
- 60-day retention (configurable)
Monitor backup status through standard Enterprise Manager interfaces

Oracle 23ai Specific Features

Enterprise Manager Cloud Control 13c includes enhanced support for Oracle 23ai capabilities:

Multitenant Container Database Support

PDB-level backup jobs: Schedule backups for individual pluggable databases
CDB-wide operations: Back up entire container database with all PDBs
PDB point-in-time recovery: Restore individual PDBs to different points in time
PDB cloning from backup: Create PDB clones directly from backup sets

JSON Relational Duality Views

Backup and recovery of databases containing JSON Relational Duality Views
Preserve JSON document structure during restore operations

Blockchain Tables

Backup immutable blockchain tables while preserving chain integrity
Verify blockchain table consistency after recovery

Enhanced Automation

AI-driven backup scheduling: Machine learning optimizes backup windows based on workload patterns
Predictive validation: Proactively validates backups likely to be needed for recovery
Smart compression: Automatically selects compression algorithms based on data characteristics

Best Practices for Enterprise Manager Backup Management

Optimize Enterprise Manager backup operations with these proven practices:

Use backup policies for consistency: Define standard policies and apply across database fleets rather than configuring each database individually
Implement layered backup strategy: Combine daily incrementals, weekly fulls, and monthly cloud backups for comprehensive protection
Configure automatic alerts: Set up email notifications for backup failures to enable rapid response
Monitor compliance dashboard daily: Review backup compliance status each morning to identify missing backups
Test recovery procedures quarterly: Use Enterprise Manager recovery wizards to perform test restores on non-production systems
Validate backups automatically: Schedule weekly validation jobs to verify backup integrity before disasters occur
Enable backup encryption: For databases containing sensitive data, configure automatic backup encryption in backup policies
Optimize backup windows: Use Performance Hub to identify low-activity periods for scheduling resource-intensive full backups
Implement role-based access: Delegate backup monitoring to junior DBAs while restricting recovery operations to senior staff
Document recovery procedures: Create runbooks documenting Enterprise Manager recovery workflows for different failure scenarios

Troubleshooting Common Issues

Resolve common Enterprise Manager backup problems:

Backup Job Failures

Symptom: Backup jobs fail with RMAN errors

Resolution steps:

Navigate to Job Activity and click failed job
Review RMAN output log for specific error messages
Common causes:
- Insufficient disk space: Expand Fast Recovery Area or configure automatic deletion
- Permission issues: Verify database credentials have SYSBACKUP privilege
- Media manager errors: Check tape library configuration and connectivity
- Archived log gaps: Ensure all required archived logs are available
Correct underlying issue and resubmit backup job

Missing Backups in Reports

Symptom: Backup reports show databases missing recent backups

Resolution:

Verify backup jobs executed successfully (check Job Activity)
Ensure Enterprise Manager agent is running on database server
Refresh backup catalog: Database → Availability → Backup Settings → Resynchronize Catalog
Check for database downtime during scheduled backup window

Slow Backup Performance

Symptom: Backup jobs take excessively long to complete

Optimization steps:

Increase parallelism (number of backup channels) in backup configuration
Enable block change tracking for faster incremental backups
Use section-based backup for large datafiles
Review I/O performance to backup destination (disk, tape, or cloud)
Consider backup compression to reduce I/O volume

Summary and Next Steps

Oracle Enterprise Manager Cloud Control 13c provides comprehensive backup and recovery management capabilities that simplify operations, ensure consistency across database fleets, and provide centralized monitoring and reporting. By leveraging Enterprise Manager's guided wizards, automated scheduling, fleet-wide policies, and compliance frameworks, DBAs can implement robust backup strategies that protect business-critical data while minimizing administrative overhead.

Key capabilities covered in this lesson:

✅ Configuring automated backup jobs with scheduling and retention policies
✅ Creating reusable backup policies applied across multiple databases
✅ Monitoring backup operations through dashboards and reports
✅ Performing guided recovery operations for common failure scenarios
✅ Generating compliance reports for regulatory requirements
✅ Integrating cloud backups with OCI Object Storage
✅ Managing Oracle 23ai features including multitenant and JSON support

Enterprise Manager Cloud Control is the recommended solution for enterprise environments managing 10 or more Oracle databases. For smaller deployments or cloud-only environments, OCI Console provides simplified backup management with automated policies and minimal configuration.

The next lesson concludes this module with a comprehensive review of backup and recovery concepts and a final assessment.

Using OEM - Quiz

Test your understanding of Enterprise Manager Cloud Control backup and recovery operations.

Using OEM - Quiz