HP Data Protector User Manual

HP Data Protector Software
HP Data Protector and Oracle 10g RAC configuration best practices
Table of contents
Executive summary ............................................................................................................................... 3

Overview ............................................................................................................................................ 3
Target audience .................................................................................................................................. 3
Review of test configuration .................................................................................................................. 3
10gRAC configurations on hp-ux ....................................................................................................... 6
Oracle Virtual IP Address .................................................................................................................. 7
Oracle Services to manage workloads ................................................................................................ 7
Oracle Services definition ................................................................................................................. 7
Oracle Online Backup Configuration ................................................................................................... 10
Configuration Guidelines ................................................................................................................ 10
Use the hostname and the Instance name to configure the backup ....................................................... 11
Use a VIP and the Instance names to configure the backup ................................................................. 12
Use a VIP and a service name to configure the backup ....................................................................... 12
Use a VIP and allocate the channels to the instances manually ............................................................ 13
Storing the connection string in the Recovery Catalog ......................................................................... 14
Backup Configuration Recommendations .......................................................................................... 16
SAN Backup versus LAN Backup ......................................................................................................... 18
Disk Agent and Media Agent are NOT allocated on the same host ...................................................... 18
Disk Agent and Media Agent are allocated on the same host .............................................................. 18
File System Backup: Oracle Base and Cluster configuration .................................................................... 19
Oracle Cluster Registry (OCR) ......................................................................................................... 20
Oracle Voting Disk ......................................................................................................................... 20
Oracle SPFILE ................................................................................................................................ 21
ORACLE Directories ....................................................................................................................... 21
File system Backup Recommendations ............................................................................................... 21
Oracle RMAN Restore and Recovery ................................................................................................... 22
Oracle Restore Enhancements .......................................................................................................... 22
Oracle RMAN Restore script............................................................................................................ 23
Oracle Restore Configuration .......................................................................................................... 24

HP Data Protector Specifications

General

Category	Backup and Recovery Software
Backup Types	Full, Incremental, Differential, Synthetic Full
Replication	Yes
Developer	Micro Focus
Supported Platforms	Windows, Linux
Key Features	Centralized management, Data deduplication
Deployment	On-premises
License Model	Perpetual, Subscription
Reporting	Customizable reports

Summary

Executive Summary

Overview

Target Audience

Review of Test Configuration

10gRAC Configurations on HP-UX

Oracle Virtual IP Address

Oracle Services to Manage Workloads

Oracle Services Definition

Defines how to create and configure Oracle services for workload management.

Oracle Online Backup Configuration

Configuration Guidelines

Lists essential steps for integrating Data Protector with Oracle.

Use the Hostname and the Instance Name to Configure the Backup

Configures backup using host and instance names, offering no failover.

Use a VIP and the Instance Names to Configure the Backup

Configures backup using VIP and instance names for basic failover.

Use a VIP and a Service Name to Configure the Backup

Configures backup using VIP and service name for load balancing and failover.

Use a VIP and Allocate Channels Manually

Manually allocates RMAN channels for optimal backup performance.

Storing the Connection String in the Recovery Catalog

Secures connection strings by storing them in the recovery catalog.

Backup Configuration Recommendations

Summarizes best practices for Oracle RAC backup configurations.

SAN Backup versus LAN Backup

Disk Agent and Media Agent Not Allocated on the Same Host

Illustrates inefficient backup data flow over LAN.

Disk Agent and Media Agent Allocated on the Same Host

Describes efficient backup data flow using memory buffers.

File System Backup: Oracle Base and Cluster Configuration

Oracle Cluster Registry (OCR)

Oracle Voting Disk

Discusses backup strategy for Oracle Voting Disk.

Oracle SPFILE

ORACLE Directories

File System Backup Recommendations

Oracle RMAN Restore and Recovery

Oracle Restore Enhancements

Details Data Protector enhancements for RMAN restore performance.

Restore Recommendations Summary

Summarizes key recommendations for RMAN restore operations.

Recovery Considerations

Discusses parallelism and considerations for media recovery.

Recovery Using Archived Logs

Explains the process of media recovery using archived logs.

Recovery Using Incremental Backup

Describes recovery scenarios using incremental backups.

Summary

Appendix A. Reference Documentation

Appendix B. RMAN Helpful Scripts

B.1 How to Monitor RMAN Job Progress

Provides SQL query to monitor RMAN job progress.

B.2 How to Monitor RMAN Waits

Provides SQL query to monitor RMAN waits.

B.3 How to Monitor RMAN Wait States

Provides SQL query to monitor RMAN wait states.

B.4 How to Monitor RMAN Channels Current Speed

Provides SQL query to monitor RMAN channel speed.

Appendix C. Session Reports

Session 1: Backup Using ita018 and RAC1

Details a backup session using specific host and instance.

Session 2: Backup Using ita018-vip and RAC1, RAC2, RAC3, RAC4

Details backup using VIP and multiple instances.

Session 3: Backup Using ita018-vip and Service BACKUP

Details backup using VIP and a service name.

Session 4: Backup Using ita018-vip and Service MSL5000

Details backup using VIP and a different service name.

Session 5: Backup Allocating Channels Manually on RAC1 and RAC2

Details backup with manually allocated channels on specific instances.

Session 6: Restore Allocating Channels Manually on RAC1 and RAC2

Details restore with manually allocated channels on specific instances.

Session 7: Restore and Recovery Using an Incremental Backup

Details restore and recovery using an incremental backup.

For More Information