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

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).

Create a new text file on the target database server in a location which is readable by the oracle user

(The example assumes that the text file is created as ‘/home/oracle/rman_script’). In the text file enter

now a backup statement with a separate paragraph per channel enclosed by opening and closing

brackets ‘{‘ and ‘}’.

{

backup incremental level 0

(datafile 9,3,1 channel dev_0 filesperset 3 format 'oracle backup

specification<ORACL_%s:%t:%p:1>.df')

(datafile 2,4,10 channel dev_1 filesperset 3 format 'oracle backup

specification<ORACL_%s:%t:%p:10>.df')

(datafile 5,6 channel dev_2 filesperset 2 format 'oracle backup

specification<ORACL_%s:%t:%p:6>.df')

(datafile 8,7 channel dev_3 filesperset 2 format 'oracle backup

specification<ORACL_%s:%t:%p:7>.df');

}

In the given example, the data files 1, 3, and 9 are assigned to channel dev_0, the data files 2, 4

and 10 are assigned to channel dev_1, the data files 5 and 6 are assigned to channel dev_2 and the

data files 7 and 8 are assigned to channel dev_3. The sequence of the data file IDs does not need to

be ordered, e.g. for channel dev_0 the data file sequence 9,3,1 is used.

You also have to specify the number of data files per channel by specifying the parameter filesperset

followed by the number, e.g. for channel dev_1 where 3 data files are backed up the parameter

filesperset needs to be set to 3, whereas for channel dev_2 the parameter needs to be set to 2 as in

the given example only 2 data files are configured for this channel.

For the format string, you may use the original format string you have copied from the Data Protector

GUI with some modifications.

Changes:

• For each format string change the ending from .dbf to .df

• For each format string add “:X” to the % parameters where X is the last data file ID in the datafile

statement. For dev_0 channel, this would be 1; for dev_1 channel, this would be 10; for dev_2

channel, this would be 6; and for dev_3 channel, this would be 7.

{