HP OpenView Storage B6960-96008 Chapter, Parallel, Channels in, Tablespaces, Backing Up a, Single Channel, Backing Up All, Backing Up Three, Archived Logs and, Examples of the RMAN Scripts

Integrating Oracle and Data Protector

Backing Up an Oracle Database

Examples of the RMAN Scripts

Some examples of RMAN scripts that must be executed from the RMAN> prompt are listed below:

Backing Up a To back up the Oracle instance ORACL, using a backup specification

Single Channel named ora1, enter the following command sequence:

run {

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

backup

incremental level 0

format 'oracl1<ORACL_%s:%t>.dbf' database;

}

Backing Up Three The RMAN backup script for backing up the database by using three

Channels inparallel channels for the same backup specification would look like this:

Parallel

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

incremental level 0

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

}

Backing Up All If you want to back up the Archived Redo Logs and the tablespace Archived Logs and SYSTEM and RONA of the previous database using three parallel

Tablespaceschannels and a backup specification named ora1, the RMAN 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)';

66 Chapter 1