---

printScript

Syntax

Purpose

To print a stored script to standard output or the RMAN message log. Specify the log filename with the log argument at the command line. If you do not specify this argument, Recovery Manager writes message output to standard output.

Note: You can also display the individual lines of your stored scripts by querying the RC_STORED_SCRIPT_LINE recovery catalog view.

Requirements

• Use this command only at the RMAN prompt.

• You must be using a recovery catalog.

Keywords and Parameters

script_name

prints a stored script with the specified name to standard output or a message log. To obtain a listing of all stored scripts, use SQL*Plus connect to the recovery catalog as the catalog owner and issue the following query: select * from rc_stored_script; Note: To run the script, use execute script within the braces of the run command. See Also: To learn about RC_STORED_SCRIPT, see "RC_STORED_SCRIPT".

Examples

Printing a Script to the Message Log

This example connects to the target database PROD1 and the recovery catalog database RCAT, and directs the RMAN log output to a message log file. It then creates the backup_db script and prints it to rman_log. Finally, it executes the script:

rman target sys/change_on_install@prod1 catalog rman/rman@rcat log rman_log
create script backup_db {
       allocate channel d1 type disk;
       backup database;
}
print script backup_db;

run{ execute script backup_db;};

Printing a Script to the Screen

This example prints a stored script to the screen:

print script tbs1_b;

RMAN-03027: printing stored script: tbs1_b
{
allocate channel ch1 type disk;
backup tablespace tbs1;
}

Related Topics

"cmdLine"

"createScript"

"deleteScript"

"run"

---