HP Data Protector V6.0 White Paper

Configuring Oracle RMAN backups with HP Data Protector to use deduplication on the VLS

Table of contents

Abstract.............................................................................................................................................. 2

Introduction......................................................................................................................................... 2

Background ........................................................................................................................................ 2

Oracle 10g configuration ..................................................................................................................... 3

Creating a backup specification ........................................................................................................ 3

Modifying existing backup specifications............................................................................................ 6

Oracle 9i configuration ...................................................................................................................... 10

Configuration in HP Data Protector................................................................................................... 10

Open the RMAN script in the Data Protector GUI ........................................................................... 10

Modify the archive log and control file backup statements............................................................... 13

Configure the controlfile autobackup ............................................................................................ 14

Replace the database backup statement........................................................................................ 14

Get required information about data files.......................................................................................... 15

Create the Contents of the external script file ..................................................................................... 16

Create the script in rman and store the content in the catalog.............................................................. 17

Script Summary.............................................................................................................................. 18

Limitations for Oracle 9i.................................................................................................................. 18

Appendix ......................................................................................................................................... 19

How to create a Data Protector RMAN template to backup Oracle 10g.................................................... 19

Oracle 9i configuration without a recovery catalog............................................................................ 21

For more information.......................................................................................................................... 24

Abstract

The purpose of this document is to describe the necessary steps to modify Oracle Backup Specifications within Data Protector to support deduplication in the VLS.

Introduction

In order to perform deduplication of Oracle RMAN Database backups on the HP StorageWorks Virtual Library System (VLS), specific configuration steps are required. The VLS depends on a specific naming for Oracle objects being backed up. This is important to the VLS to be able to identify identical objects of different backup sessions to do deduplication on them. The document describes how to accomplish this by modifying HP Data Protector backup specifications to support Oracle.

Background section describes this specific naming convention for the Oracle objects.

The

Oracle 10g configuration section describes the required modifications that are necessary for

The Oracle 10g RMAN backups.

Oracle 9i configuration section describes special modifications that are necessary for Oracle 9i.

The

Background

To identify related Oracle objects the VLS uses a specific Oracle RMAN string format. This format can be seen in the middle column below. The left column shows the default HP Data Protector settings. The backup must include the controlfile backup, and therefore, two more configurations have to be used as else errors will occur during the backup session.

HP Data Protector default Necessary VLS configuration Comments

NA. CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F';

'oracle backup specification<DBNAME_%s:%t:%p>.dbf'

'oracle backup specification<DBNAME_%s:%t:%p:%f>.df'

'oracle backup specification<DBNAME_%s:%t:%p>.al'

'oracle backup specification<DBNAME_%s:%t:%p:%f>.cntrl'

data file backups

archive log backups

controlfile backups

Oracle 10g configuration

This section describes how to set up a new backup specification or modifying already existing backup specifications in order to support deduplication of Oracle 10g on a HP VLS system.

Creating a backup specification

This section explains the basic steps to create an Oracle backup specification from scratch.

Select the Backup context in the Data Protector GUI and create a new Oracle backup specification by right clicking “Oracle Server” and selecting “Add Backup….”

Figure 1:

It is recommended to use a special Oracle deduplication template when creating the backup specification. A lot of configuration steps are not needed then. This will minimize the effort if you have to create many backup specifications. See the

backup Oracle 10g

Select the Deduplication template and click OK.

sub-section on how to create this template.

How to create a Data Protector RMAN template to

Figure 2:

Select the Oracle instance you want to backup in the next screen and enter its credentials. Then select the databases you want to backup.

Figure 3:

Select the VLS device you want to write the backup to and click next until you can save the backup specification.

Figure 4:

It is not required to perform all of the configuration steps if you have used a preconfigured template. By using a template as explained in the

backup Oracle 10g

sub-section, you only need to adjust the control file format string as explained in

How to create a Data Protector RMAN template to

the next section. If you use a default Data Protector template, you have to adjust all settings as explained in the next section.

Modifying existing backup specifications

Select the Backup context in the Data Protector GUI and select the Oracle backup specification you want to configure for deduplication. Switch to Options tab:

Figure 5:

Click the Application Specific Options:

Figure 6:

Click Edit to open the RMAN Script for modification:

Figure 7:

A typical default RMAN Script is shown below:

run { allocate channel 'dev_0' type 'sbt_tape' parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL,OB2BARLIST=oracle backup specification)'; allocate channel 'dev_1' type 'sbt_tape' parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL,OB2BARLIST=oracle backup specification)'; allocate channel 'dev_2' type 'sbt_tape' parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL,OB2BARLIST=oracle backup specification)'; allocate channel 'dev_3' type 'sbt_tape' parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL,OB2BARLIST=oracle backup specification)'; backup incremental level <incr_level> format 'oracle backup specification<ORACL_%s:%t:%p>.dbf' database; sql 'alter system archive log current'; backup format 'oracle backup specification<ORACL_%s:%t:%p>.dbf' archivelog all; backup format 'oracle backup specification<ORACL_%s:%t:%p>.dbf' current controlfile; }

Four channels are allocated and three backup statements are configured (database, archivelog, and controlfile). In order to enable deduplication the format specifications for database, archivelog, and controlfile have to be modified. The modification is shown below (red):

… backup incremental level <incr_level> format 'oracle backup specification<ORACL_%s:%t:%p:%f>.df' database; sql 'alter system archive log current'; backup format 'oracle backup specification<ORACL_%s:%t:%p>.al' archivelog all; backup format 'oracle backup specification<ORACL_%s:%t:%p:%f>.cntrl' current controlfile; }

Changes:

Format for database - add “:%f” to the % parameter list

- Change ending .dbf Æ .df

Format for archivelog - Change ending .dbf Æ .al

Format for controlfile - add ”:%f” to the % parameter list

- Change ending .dbf Æ .cntrl

+ 16 hidden pages