Backing Up Using the Agent for Oracle › Agent Backups › RMAN Command Line Scripts

RMAN Command Line Scripts

You can write and execute your own RMAN scripts. The following is an example of an RMAN script allocating a single channel to back up a particular data file on a single tape device:

run {
allocate channel dev1 type 'sbt_tape';
backup (datafile '/oracle/oradata/demo/users01.dbf' format '_%u_%p_%c');
release channel dev1;
}

Note: To use the Agent for Oracle as a back-end, you must:

• Use sbt_tape as the channel type (for Oracle 9i).
• You can use the _%u_%p_%c format to ensure that the object that is backed up has a unique name.

The following is an example of an RMAN script that uses multistreaming in a backup. It allocates two channels to back up the data to two different tape devices in parallel:

run {
allocate channel dev1 type 'sbt_tape';
allocate channel dev2 type 'sbt_tape';
backup filesperset 1 format '_%u_%p_%c' (datafile '/oracle/oradata/demo/users01.dbf,  '/oracle/oradata/demo/tools01.dbf');
release channel dev1;
release channel dev2;
}

For more information about using RMAN and RMAN scripts, see Oracle documentation.