RMAN Commands , 36 of 59

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

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 SQLPlus 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"

'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;
}