WIXLIB

Dell EMC PowerProtect Oracle RMANAgentVersion 19.1Administration Guide302-005-535REV 01July 2019

Copyright 2012-2019 Dell Inc. or its subsidiaries. All rights reserved.Dell believes the information in this publication is accurate as of its publication date. The information is subject to change without notice.THE INFORMATION IN THIS PUBLICATION IS PROVIDED “AS-IS.” DELL MAKES NO REPRESENTATIONS OR WARRANTIES OF ANY KINDWITH RESPECT TO THE INFORMATION IN THIS PUBLICATION, AND SPECIFICALLY DISCLAIMS IMPLIED WARRANTIES OFMERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. USE, COPYING, AND DISTRIBUTION OF ANY DELL SOFTWARE DESCRIBEDIN THIS PUBLICATION REQUIRES AN APPLICABLE SOFTWARE LICENSE.Dell Technologies, Dell, EMC, Dell EMC and other trademarks are trademarks of Dell Inc. or its subsidiaries. Other trademarks may be the propertyof their respective owners. Published in the USA.Dell EMCHopkinton, Massachusetts 01748-91031-508-435-1000 In North America 1-866-464-7381www.DellEMC.com2Dell EMC PowerProtect Oracle RMAN Agent Administration Guide

CONTENTSFigures7Tables9Preface11Chapter 1Introducing the Oracle RMAN Agent15Overview of Oracle RMAN agent. 16Supported configurations. 17Chapter 2DD Boost Features19Distributed segment processing. 20Advanced load balancing and link failover. 22Configuration restrictions. 24DD Boost-over-Fibre Channel transport. 24DD Boost-over-Fibre Channel path management. 26Initial path selection.28Client path failover. 28Dynamic re-balancing. 28Queue-depth constraints. 29Encrypted managed file replication.29DD Boost and high availability.30DD Boost, HA, and failover. 30Partial HA configurations .30Low-bandwidth optimization. 31Client access validation. 31In-flight encryption.32Marker support .32Chapter 3Configuring the Data Domain System for Stand-alone OracleRMAN Agent Deployments33Oracle RMAN agent and DD OS upgrades. 34Firewalls and ports.34Enabling DD Boost on a Data Domain system. 34Enabling Oracle optimized deduplication. 35Configuring the DD Boost server. 36Creating storage units. 36Configuring distributed segment processing.36Configuring advanced load balancing and link failover.37Enabling low-bandwidth optimization . 38Enabling encrypted file replication. 39Configuring client access validation.39Configuring DD Boost-over-FC service. 41Sizing DD Boost-over-FC device-set. 42Sizing calculation. 43Dell EMC PowerProtect Oracle RMAN Agent Administration Guide3

ContentsConfiguring the SCSI device driver for AIX clients.45Configuring the SCSI generic device driver for Solaris clients. 46Chapter 4Configuring the Oracle RMAN Agent for Stand-alone Deployment49Installing and configuring the Oracle RMAN agent on AIX, Linux, and Solarissystems. 50Installing the Oracle RMAN agent on database servers. 50Installing the Oracle RMAN agent on Linux and UNIX. 51Uninstalling the Oracle RMAN agent on database servers. 55Uninstalling the Oracle RMAN agent on Linux and UNIX. 56Configuring the software on Linux and UNIX systems. 57Installing and configuring the Oracle RMAN agent on Windows systems.57Installing the Oracle RMAN agent on database servers.57Installing the Oracle RMAN agent on Windows systems.58Uninstalling the Oracle RMAN agent on Windows systems. 61Configuring the software on Windows systems. 62Registering each Data Domain system.62Registering a standard Data Domain system.63Registering a Data Domain system with DD Boost over FibreChannel. 65Registering a Data Domain system for shared lockbox access. 67Migrating an Oracle configuration from the database application agent. 70Updating the RMAN scripts for Oracle RMAN agent operations.70Using the correct RMAN script for restore, crosscheck, and deleteoperations.73Updating the data movement policy for cloud tier operations. 74Performing backups of a clustered environment to Data Domain.75Data Domain replication.75Performing managed file replication (MFR). 76Restoring from MTree replicated backups. 79Specifying subdirectories for Oracle RMAN agent backups. 81Performing backups and restores of Oracle CDBs and PDBs.83Performing DD Boost compressed restores.84Display and deletion of backups.84Using the ddutil command to display and delete backups. 85Using the ddutil command to display backup information. 89Using the ddutil command to delete backups. 91Using the ddutil command to prune backups based on age.92Configuring the use of Data Domain Cloud Tier for data movement to thecloud. 93Setting up the data movement to the cloud.93Performing the data recall from the cloud. 94RMAN crosscheck and deletion of backup data in the cloud.95Usage limits on Data Domain resources. 95Oracle RMAN agent operations with Data Domain usage limits oncapacity.96Oracle RMAN agent operations with Data Domain usage limits onstreams. 96Configuring usage limits on Data Domain resources.97Estimating the Data Domain resource usage on Oracle systems. 98Chapter 5Data Domain System Administration101Restricting DD Boost access to specific database servers. 1024Dell EMC PowerProtect Oracle RMAN Agent Administration Guide

ContentsFile replication version compatibility.103Modifying an interface group. 103Removing the advanced load balancing and link failoverconfiguration.104Chapter 6Troubleshooting105Troubleshooting overview. 106Investigating problems. 106Oracle limitations. 106Reporting problems.106Data Domain system settings for file replication.107Lockbox troubleshooting information. 107Failure to load the media management library. 108Chapter 7Using DD Boost Commands111DD Boost command summary. 112The ddboost command options. 112access.112clients. 113destroy. 113disable.113enable. 114fc. 114file-replication.114ifgroup. 118option.120reset. 121set user-name. 121show.122status. 123storage-unit. 123Appendix AInstallation and Configuration Checklist125Configure the Data Domain system. 126Download and install the Oracle RMAN agent. 126Configure RMAN for the environment.126Test the installation by using sbttest (optional) .127Backup examples.127Appendix BPerforming a Backup with Oracle Enterprise Manager129Example screens. 130Appendix CInstalling and Configuring the Oracle RMAN Agent133Installation and configuration examples.134Dell EMC PowerProtect Oracle RMAN Agent Administration Guide5

Contents6Dell EMC PowerProtect Oracle RMAN Agent Administration Guide

FIGURES123456789101112131415Oracle RMAN agent configuration.17High-level data flow with distributed segment processing disabled. 21High-level data flow with distributed segment processing enabled. 22Example of advanced load balancing and link failover configuration.23DD Boost-over-IP transport.24SCSI commands between media server and Data Domain system. 25Fibre Channel communication path.26DD Boost-over-FC path management scenario.27Login window. 130Database instance page. 130Processing page.130Schedule Customized Backup: Options page. 131Schedule Customized Backup: Schedule page. 131Schedule Customized Backup: Review page. 131Execution page.132Dell EMC PowerProtect Oracle RMAN Agent Administration Guide7

Figures8Dell EMC PowerProtect Oracle RMAN Agent Administration Guide

TABLES123456789101112Revision history. 11Style conventions.12Environment variables for installation or upgrade of Oracle RMAN agent.50Software package names on UNIX and Linux.52Product software components on Linux or UNIX.54Environment variables for uninstallation of Oracle RMAN agent.55Product software components on Windows. 60The ddutil command options for backup display and deletion. 86Summary of DD Boost commands.112Inbound and outbound file transfer. 116Inbound and outbound data transfer. 117Output definitions for DD Boost histogram. 122Dell EMC PowerProtect Oracle RMAN Agent Administration Guide9

Tables10Dell EMC PowerProtect Oracle RMAN Agent Administration Guide

PrefaceAs part of an effort to improve product lines, periodic revisions of software andhardware are released. Therefore, all versions of the software or hardware currently inuse might not support some functions that are described in this document. Theproduct release notes provide the most up-to-date information on product features.If a product does not function correctly or does not function as described in thisdocument, contact a technical support professional.Note: This document was accurate at publication time. To ensure that you areusing the latest version of this document, go to the Support website https://www.dell.com/support.PurposeThis document describes how to install, configure, and use the PowerProtect OracleRMAN agent version 19.1 software.In earlier versions of the product, the Oracle RMAN agent was known as Data DomainBoost (DD Boost) for Oracle Recovery Manager (RMAN) or the RMAN plug-in. Inversion 4.0, the product name changed to Oracle RMAN agent.Note: The Oracle RMAN agent uses Application Direct workflows, known inprevious releases as DD Boost workflows.AudienceThis guide is for system administrators who are familiar with Oracle backupapplications and general backup administration.Revision historyThe following table presents the revision history of this document.Table 1 Revision historyRevisionDateDescription01July 25, 2019Initial release of this document for Oracle RMANagent 19.1.Related documentationThe following publications provide additional information:lPowerProtect Oracle RMAN Agent Release NoteslDDBEA section of the eLab Navigator at otectionlData Domain Operating System documentationlData Domain system installation and setup guide for each supported platform, forexample DD890, DD670, and so onlPowerProtect Data Manager Administration and User GuidelPowerProtect Data Manager Deployment GuidelPowerProtect Data Manager Security Configuration GuideDell EMC PowerProtect Oracle RMAN Agent Administration Guide11

PrefacelPowerProtect X400 Administration and User GuidelPowerProtect X400 Deployment GuidelPowerProtect X400 Security Configuration GuideRMAN DocumentationOracle 18c: From the Oracle Database Documentation library at database/18/, select Administration andselect a guide under Backup and Recovery:lDatabase Backup and Recovery ReferencelDatabase Backup and Recovery User’s GuideOracle 12c Release 2: From the Oracle Database Documentation library at database/12.2/index.html, selectAdministration and select a guide under Backup and Recovery:lDatabase Backup and Recovery ReferencelDatabase Backup and Recovery User’s GuideOracle 12c Release 1: From the Oracle Database Documentation library at http://docs.oracle.com/database/121/index.htm, select Database Administration and select aguide under Backup and Recovery:lBackup and Recovery User’s GuidelBackup and Recovery ReferenceOracle 11g Release 2: From the Oracle Database Documentation library atwww.oracle.com/pls/db112/homepage, select Database Administration and select aguide under Backup and Recovery:lBackup and Recovery User’s GuidelBackup and Recovery ReferenceOracle 10g Release 2: From the Oracle Database Documentation library atwww.oracle.com/pls/db102/homepage, select Administration and select a guideunder Backup and Recovery:lBackup and Recovery ReferencelBackup and Recovery Advanced User’s GuideSpecial notice conventions that are used in this documentThe following conventions are used for special notices:NOTICE Identifies content that warns of potential business or data loss.Note: Contains information that is incidental, but not essential, to the topic.Typographical conventionsThe following type style conventions are used in this document:Table 2 Style conventions12BoldUsed for interface elements that a user specifically selects or clicks,for example, names of buttons, fields, tab names, and menu paths.Also used for the name of a dialog box, page, pane, screen area withtitle, table label, and window.ItalicUsed for full titles of publications that are referenced in text.Dell EMC PowerProtect Oracle RMAN Agent Administration Guide