Integrating Oracle and Data Protector

Backing Up an Oracle Database

allocate channel 'dev_2' type 'sbt_tape' parms'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL,OB2BARLIST=ora1)';

backup

 

incremental level 0

 

format 'ora1<ORACL_%s:%t>.dbf'

 

tablespace SYSTEM, RONA

 

sql 'alter system archive log current'

 

format 'ora1<ORACL_%s:%f:%p>.dbf'

 

archivelog all;

 

}

Backing Up

To back up all Archived Redo Logs from sequence #5 to sequence #105

Particular

and delete the Archived Redo Logs after backup of the instance named

Archived Logs

ora1 is complete, run the following script:

 

run {

 

allocate channel 'dev_0' type 'sbt_tape'

 

parms'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL,OB2BARLIST=ora1)';

 

allocate channel 'dev_1' type 'sbt_tape'

 

parms'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL,OB2BARLIST=ora1)';

 

allocate channel 'dev_2' type 'sbt_tape'

 

parms'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL,OB2BARLIST=ora1)';

 

backup

 

(archivelog sequence between 5 and 105 delete input

 

format 'ora1<ORACL_%s:%t:%p>.dbf');

 

}

 

If the backup fails, the logs are not deleted.

Backing Up the

If you want to back up the Oracle 10g Flash Recovery Area using three

Flash Recovery

parallel channels and a backup specification named ora1, the RMAN

Area

script should look like this:

 

run {

 

allocate channel 'dev_0' type 'sbt_tape'

 

parms'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL,OB2BARLIST=ora1)';

 

allocate channel 'dev_1' type 'sbt_tape'

 

parms'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL,OB2BARLIST=ora1)';

 

allocate channel 'dev_2' type 'sbt_tape'

Chapter 1

67