HP Data Protector User Manual

14
Although the backup specification could also be edited on the cell server, located in
$OMNICONFIG/barlists/oracle8, using the GUI is the only supported method to edit a backup
script.
Figure 12. Data Protector RMAN script edit window
The complete RMAN script is shown below:
run {
allocate channel 'dev_0' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=RAC,OB2BARLIST=RAC_POOL_man_ch_1_2)'
connect 'sys/xxx@rac1';
allocate channel 'dev_1' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=RAC,OB2BARLIST=RAC_POOL_man_ch_1_2)'
connect 'sys/xxx@rac2';
backup incremental level <incr_level>
format 'RAC_POOL_man_ch_1_2<RAC_%s:%t:%p>.dbf'
tablespace 'POOL';
}
As it can be seen, two channels will be allocated, one on instance RAC1 and one on instance RAC2.
For each of these channels, we have to specify the connection string using the instance name (not a
service).
In this scenario, if one of the instances is not available the channel allocation fails and the session will
abort.
The backup session report is in the Appendix C under Session 5.
Storing the connection string in the Recovery Catalog
Security concerns may arise when storing the connection string in the backup specification (located in
the Cell Manager File system); the channel allocation with the connection string can be defined and
stored in the recovery catalog as a configuration parameter.
• Create a backup specification for your database. Once saved, edit it and remove the channel
allocation parameters; they will be allocated by RMAN using the Recovery Catalog settings.
run {
backup incremental level <incr_level>
format 'RAC_POOL_sbt_rcvcat<RAC_%s:%t:%p>.dbf'
tablespace ''POOL'';
}

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