Skip to Main Content
Oracle DBA Pocket Guide
book

Oracle DBA Pocket Guide

by David C. Kreines
August 2005
Intermediate to advanced content levelIntermediate to advanced
154 pages
4h 48m
English
O'Reilly Media, Inc.
Content preview from Oracle DBA Pocket Guide
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
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein
Oracle RMAN Pocket Reference

Oracle RMAN Pocket Reference

Darl Kuhn, Scott Schulze

Publisher Resources

ISBN: 9780596528843