PRINT SCRIPT

Syntax

Text description of the illustration printScript.gif

Purpose

To print a stored script to standard output or the RMAN message log. To print to a 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 the stored scripts by querying the RC_STORED_SCRIPT_LINE recovery catalog view.

Restrictions and Usage Notes

• Use this command only at the RMAN prompt.
• You must be connected to the target database that you connected to when you created or replaced the script.
• You must be connected to the recovery catalog, and the recovery catalog database must be open.

Keywords and Parameters

Syntax Element	Description
'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: SQL> SELECT * FROM RC_STORED_SCRIPT; Note: To run the script, use EXECUTE SCRIPT within the braces of the RUN command. See Also: "RC_STORED_SCRIPT"

Examples

Printing a Script to the Message Log: Example

The following shell script creates the backup_db recovery catalog script and prints it to rman_log. Finally, it executes the script:

#!/usr/bin/tcsh
rman TARGET / CATALOG rman/rman@rcatdb LOG = rman_log <<EOF
REPLACE SCRIPT backup_db 
{
  ALLOCATE CHANNEL c1 DEVICE TYPE sbt;
  BACKUP DATABASE;
}
PRINT SCRIPT backup_db;
RUN
{ 
  EXECUTE SCRIPT backup_db;
}
EOF

Printing a Script to the Screen: Example

This example prints a stored script to standard output (includes sample output):

PRINT SCRIPT backup_db;

printing stored script: backup_db
{
ALLOCATE CHANNEL c1 DEVICE TYPE sbt
BACKUP DATABASE;
}