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.

To create the external script file, please see the Create the Contents of the external script file sub-section with one small modification:

Do not include the opening and closing brackets ‘{‘ and ‘}’ in the script file, but only insert the backup statement:

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');

After saving the text file the configuration is finished. Now you should have one rman script in the Data Protector GUI and one external script file 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=(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)';

@/home/oracle/rman_script;

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>.dbf' recovery area;

backup

format 'oracle backup specification<ORACL_%s:%t:%p:1>.cntrl' current controlfile;

}

22