RMAN Commands , 28 of 59

EXECUTE SCRIPT

Syntax

Text description of the illustration executeScript.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.

Restrictions and Usage Notes

Execute this command only within the braces of a RUN command.
You must be connected to the target database that you connected to when you created or replaced the script.
RMAN must be connected to the catalog with the CATALOG command-line option or the CONNECT CATALOG command, and the catalog must be open.

Keywords and Parameters

Syntax Element Description

Syntax Element	Description
`'script_name'`	Runs the specified stored script. To obtain a listing of all stored scripts, use SQLPlus 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

'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 creates and then runs a stored script:

REPLACE SCRIPT b_whole_10 
{
  BACKUP DATABASE PLUS ARCHIVELOG;
}

RUN { EXECUTE script b_whole_10; }