EXECUTE SCRIPT

Syntax

Text description of the illustration executes.gif

Purpose

To run an RMAN script stored in the recovery catalog. Use the CREATE SCRIPT command to generated stored scripts.

When you run an EXECUTE SCRIPT command within a RUN command, RMAN places the contents of the script between the braces of RUN. For this reason, you should not allocate a channel at the RUN command level if you already allocated it in the script.

See Also: Oracle9i Recovery Manager User's Guide, and "CREATE SCRIPT"

Restrictions and Usage Notes

Execute this command only within the braces of a RUN command.

Keywords and Parameters

'script_name'

Runs the specified stored script. To obtain a listing of all stored scripts, use SQL*Plus to connect to the recovery catalog database as the catalog owner and run the following query: SQL> SELECT * FROM RC_STORED_SCRIPT; See Also: "RC_STORED_SCRIPT" for more information about RC_STORED_SCRIPT, and "CREATE SCRIPT" for information about creating scripts

Example

Executing a Script: Example

This example runs a stored script:

RUN { EXECUTE script b_whole_10; }