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).
Modify the archive log and control file backup statements
In order to enable deduplication, the format specifications for 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>.dbf' 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:1>.cntrl' current controlfile;
}
Changes:
Format for archivelog | • Change ending .dbf Æ .al | |
|
|
|
Format for controlfile | • | Add ”:1” to the % parameter list |
| • | - Change ending .dbf Æ .cntrl |
|
|
|
13