In the previous lesson, you learned about managing stored scripts within Recovery Manager. This lesson introduces you to the run command, which is used to execute stored scripts. In addition, the run command allows you to execute operating system commands and SQL commands. When the run command operates, two things happen. The commands are compiled into blocks or steps of PL/SQL code. Then, these steps are then stored in memory and executed. The compiled version of your script is not stored for later use. Take a look at some samples of the run command in the following series of images below:
Types of Recovery Manager Commands
RMAN uses two basic types of commands:
stand-alone commands and
With the exception of the change, crosscheck, and delete commands, stand-alone commands are self-contained. In contrast, job commands must appear within the brackets of a run command. After you connect to the target and optional recovery catalog, you will execute most of your RMAN commands within run. Following is a typical example of a run statement:
allocate channel c1 type 'sbt_tape';
Unlike job commands, stand-alone commands do not appear as sub-commands
within run. Following are some of the commands that can appear by themselves:
create catalog, drop catalog, upgrade catalog
create script, delete script, replace script
delete expired backupset
Some of these commands are not strictly stand-alone, however, because they must be preceded by an allocate channel for maintenance command.
Purpose of run command
To compile and execute job commands, which are one or more statements executed within the braces of run. The run command compiles the list of job commands into one or more job steps and then executes them immediately. RMAN compiles and executes each command before processing the next one.
Execute this command only at the RMAN prompt.
You must precede and follow the list of job commands with an opening and closing brace
Keywords and Parameters
Refer to individual entries for information about commands that you can run from the RMAN prompt.
It should be noted that you could use the run command to execute the same syntax that you might have in a stored script. Below is an example of using the run command to back up the USER_DATA tablespace.
allocate channel 1 type disk;
incremental level = 0
In the next lesson, you will learn what data dictionary views are available to you to interrogate the recovery catalog.