Configuring Oracle RMAN backups with HP Data Protector to use deduplication on the VLS
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
8