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