Filter
Top Products
Integrating Oracle and Data Protector
Backing Up an Oracle Database
Chapter 166
Examples of the RMAN Scripts
Some examples of RMAN scripts that must be executed from the RMAN>
prompt are listed below:
Backing Up a
Single Channel
To back up the Oracle instance ORACL, using a backup specification
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
Channels in
Parallel
The RMAN backup script for backing up the database by using three
parallel channels for the same backup specification would 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'
parms'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL,OB2BARLIST=ora1)';
backup
incremental level 0
format 'ora1<ORACL_%s:%t>.dbf' database;
}
Backing Up All
Archived Logs and
Tablespaces
If you want to back up the Archived Redo Logs and the tablespace
SYSTEM and RONA of the previous database using three parallel
channels 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)';