HP OpenView Storage Data Protector B6960-96008 用户手册
Integrating Oracle and Data Protector
Backing Up an Oracle Database
Chapter 1
66
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
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)';
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
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:
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)';
parms'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL,OB2BARLIST=ora1)';
allocate channel 'dev_1' type 'sbt_tape'
parms'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL,OB2BARLIST=ora1)';
parms'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL,OB2BARLIST=ora1)';
allocate channel 'dev_2' type 'sbt_tape'
parms'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL,OB2BARLIST=ora1)';
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
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
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)';
parms'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL,OB2BARLIST=ora1)';
allocate channel 'dev_1' type 'sbt_tape'
parms'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL,OB2BARLIST=ora1)';
parms'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ORACL,OB2BARLIST=ora1)';