
78
|
Oracle DBA Pocket Guide
Using RMAN scripts
When you specify the backup or recovery operations to be
performed by RMAN, you will frequently need to include
several commands. If you make a mistake entering one of
these commands, RMAN will abort the entire job. Because of
this behavior, many DBAs use scripts containing a verified
set of RMAN commands.
NOTE
You may want to create operating system scripts contain-
ing all the commands needed to run an RMAN job, from
setting the environment variables to actually backing up
or restoring the database. You may also want to create
operating system scripts that pass variables to RMAN.
The syntax for these scripts is the standard syntax for
scripts for your operating system.
You can also create scripts to run within RMAN. The @
command calls an operating system script from within
RMAN. The @@ command calls another script from within
a called script (both scripts must be in the same directory).
You can store scripts in the recovery catalog with the follow-
ing command in RMAN:
RMAN> CREATE SCRIPT script_name {scriptbody}
To edit an existing script, use the same syntax, but begin
with the keywords REPLACE SCRIPT.
You can run a script stored in the catalog using the command:
RMAN> RUN {EXECUTE SCRIPT script_name;}
You can delete a script from the catalog as follows:
RMAN> DELETE SCRIPT script_name;
You can view a script stored in the catalog in two ways. You
can use