Creating and Editing RMAN Scripts

Sample RMAN scripts, named backup-template.rcv and restore-template.rcv, are installed by the installation process. For UNIX nodes, they are located in the misc directory of the product directory. For Windows nodes, they are located in the root of the product directory. Once you have edited a few variables in these scripts, you can use them to perform backups and restores. The scripts are commented to help you with this process.

The following is included to help you edit and write your own RMAN scripts to work with DPX. For specific instructions on how to write RMAN scripts in general, see the Oracle Recovery Manager User’s Guide.

Note. You will need to provide RMAN the pathname of the edited scripts, which can be stored in a location of your choosing.

For DPX to work with Oracle, the RMAN scripts must follow Oracle’s specification for working with an MML. Oracle’s specifications are:

• The data being backed up must be sent to a Media Management Layer (MML) for output. This is done by stating the following:

  allocate channel d1 type=’sbt_tape’;

  This is necessary in both a backup and a restore script.

• The files being backed up must follow a naming convention like the following.

  format ‘df_%s_%t_%p’;

In the example above, Oracle will generate unique names for the files being backed up by substituting values for %s, %t, and %p. The order of these values does not matter, but all three (%s, %t, and %p) must appear. If they do not, although you will not receive any errors when you back up, you will not be able to restore.

This is necessary in a backup script.