EXECUTE SCRIPT

Syntax

executeScript::=

Description of the illustration executescript.gif

Purpose

To run a local or global RMAN script stored in the recovery catalog.

See Also:

"CREATE SCRIPT" and Oracle Database Backup and Recovery Advanced User's Guide for more details about stored scripts

Restrictions and Usage Notes

Use EXECUTE SCRIPT only within the braces of a RUN command.
RMAN must be connected to the catalog with the CATALOG command-line option or the CONNECT CATALOG command, and the catalog must be open.
For a local script, RMAN must be connected to the target database for which the local script is created.
When you run an EXECUTE SCRIPT command within a RUN block, RMAN places the contents of the script in the context of that RUN block. For this reason, you should not allocate a channel within the RUN block if you also allocate it in the script.

Keywords and Parameters

Syntax Element Description

GLOBAL Specifies the execution of a global stored script instead of a local one.

Syntax Element	Description
`GLOBAL`	Specifies the execution of a global stored script instead of a local one.
`'script_name'`	The name of the stored script to execute. If no local stored script defined for the current target database is found with the name specified, RMAN searches for a global script by the same name and executes it if one is found. See Also: "LIST" for more information about listing the scripts stored in the recovery catalog, and "CREATE SCRIPT" for information about creating scripts

'script_name'

The name of the stored script to execute.

If no local stored script defined for the current target database is found with the name specified, RMAN searches for a global script by the same name and executes it if one is found.

See Also: "LIST" for more information about listing the scripts stored in the recovery catalog, and "CREATE SCRIPT" for information about creating scripts

Example

Executing a Script: Example This example runs a stored script called backup_whole_10:

RUN { EXECUTE script backup_whole_10; }