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

ManualsBrandsHP ManualsSoftwareHP Data Protector V6.11 Software

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

Summary of content (24 pages)

PAGE 1
Configuring Oracle RMAN backups with HP Data Protector to use deduplication on the VLS Table of contents Abstract.............................................................................................................................................. 2 Introduction......................................................................................................................................... 2 Background ..........................................................................................
PAGE 2
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.
PAGE 3
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….
PAGE 4
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.
PAGE 5
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 How to create a Data Protector RMAN template to backup Oracle 10g sub-section, you only need to adjust the control file format string as explained in the next section.
PAGE 6
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.
PAGE 7
Click the Application Specific Options: Figure 6: Click Edit to open the RMAN Script for modification: Figure 7: 7
PAGE 8
A typical default RMAN Script is shown below: run { allocate channel 'dev_0' type 'sbt_tape' parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL,OB2BARLIST=oracle specification)'; allocate channel 'dev_1' type 'sbt_tape' parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL,OB2BARLIST=oracle specification)'; allocate channel 'dev_2' type 'sbt_tape' parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL,OB2BARLIST=oracle specification)'; allocate channel 'dev_3' type 'sbt_tape' parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL
PAGE 9
It is important that the % parameters are configured in exactly this sequence using exactly these separators: .EXTENSION • DB_NAME: ORACL in the example above. • %f is not available for archivelog. • EXTENSION: .df (for data files), .al (for archive logs) or .cntrl (for the controlfile) The backup must include the controlfile backup.
PAGE 10
Oracle 9i configuration The %f format parameter was introduced in Oracle 10g. It is not available in Oracle 9i. This parameter is required though to support deduplication as explained in the previous section. Therefore, it has to be hard coded. The following sub-sections explain how to find out the right values to replace the %f. Configuration in HP Data Protector The following examples show how to do the required modifications using an existing backup specification created by a blank backup template.
PAGE 11
Switch to the “Catalog” tab and check that “Use recovery catalog” is correctly configured similar to the example below. Figure 9: It is recommended to use a recovery catalog for this configuration. In case no recovery catalog is available at all, please refer to the Oracle 9i configuration without a recovery catalog sub-section.
PAGE 12
Click the Application Specific Options: Figure 11: Click Edit to open the RMAN Script for modification: Figure 12: 12
PAGE 13
A typical default RMAN Script is shown below: run { allocate channel 'dev_0' type 'sbt_tape' parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL,OB2BARLIST=oracle specification)'; allocate channel 'dev_1' type 'sbt_tape' parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL,OB2BARLIST=oracle specification)'; allocate channel 'dev_2' type 'sbt_tape' parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL,OB2BARLIST=oracle specification)'; allocate channel 'dev_3' type 'sbt_tape' parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL
PAGE 14
It is important that the % parameters are configured in exactly this sequence: For Archivelog .al For Controlfile .cntrl DBNAME is ORACL in the example above and should match your database name. Configure the controlfile autobackup The backup must include the controlfile backup.
PAGE 15
In the example above, the script is named backup_datafiles, however, you may specify any other script name.
PAGE 16
Create the Contents of the external script file All data files should be distributed evenly (load-balanced) across the available channels. In the preceding example, the 10 data files need to be distributed across a maximum of four channels. All later examples assume that the 10 data files are distributed across channel 0, 1, 2, and 3 which are named by default “dev_0”, “dev_1”, “dev_2” and “dev_3” (see the allocate channel entries in the rman script in the Data Protector GUI for reference).
PAGE 17
It is important that the % parameters are configured in exactly this sequence: .df DBNAME is ORACL in the example above and X is the last data file id—so 1, 10, 6 or 7 in the given example. For incremental level you may choose any valid rman incremental level, whereas incremental level 0 is a full backup. Now save the file and close the text editor.
PAGE 18
Script Summary Now you should have one rman script in the Data Protector GUI and one external script saved in the recovery catalog similar to the example below: Rman Script (Changes from default are marked red) run { CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F'; 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
PAGE 19
• The external script needs to be setup and maintained in the recovery catalog. If no recovery catalog is available, then a script file on the database server needs to be used (refer to the Oracle 9i configuration without a recovery catalog sub-section in the Appendix) • In the Source tab of the backup specification in the Data Protector GUI, the data file backup is not shown although the data files will be included in the backup.
PAGE 20
Select your newly copied template and select the Options tab. Adjust the description and click the Application Specific Options: Figure 15: Select “Archive logs” and “Database” in the “What to backup” section.
PAGE 21
Figure 16: When you use this template during Oracle backup specification, you only need to adjust the controlfile backup in the RMAN script. Oracle 9i configuration without a recovery catalog If no recovery catalog is available for the target database, it is not possible to store the script in the database. The only possibility is to use an external script file and execute this external script file by rman.
PAGE 22
In the previous example, the script is located in the /home/oracle directory and is named ‘rman_script’, however, you may specify any path and any file name as long as the file is readable by the oracle user. To get the required data for the data file distribution, please see the Get required information about data files sub-section.
PAGE 23
External script (here /home/oracle/rman_script): backup incremental level 0 (datafile 9,3,1 channel dev_0 filesperset 3 format 'oracle backup specification.df') (datafile 2,4,10 channel dev_1 filesperset 3 format 'oracle backup specification.df') (datafile 5,6 channel dev_2 filesperset 2 format 'oracle backup specification.df') (datafile 8,7 channel dev_3 filesperset 2 format 'oracle backup specification.
PAGE 24
For more information Information on HP Data Protector software www.hp.com/go/dataprotector Information on HP StorageWorks Virtual Library System (VLS) www.hp.com/go/vls Information on Deduplication support www.hp.com/go/ebs Technology for better business outcomes © Copyright 2008 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice.