|Oracle9i Recovery Manager Reference
Release 2 (9.2)
Part Number A96565-01
RMAN Commands , 54 of 59
To execute a SQL statement or a PL/SQL stored procedure from within Recovery Manager.
SQLcommand at the RMAN prompt or within the braces of a
SQLkeyword must be enclosed in double quotes. For example, use the following syntax:
If you attempt to use single quotes for the string following the SQL keyword or use only one set of single quotes for the filename, then the command fails.
For valid SQL syntax, see the Oracle9i SQL Reference
Specifies a SQL statement for execution. For example, issue the following at the RMAN prompt to archive the online redo logs:
This example backs up a tablespace and then archives all unarchived online logs:
This example specifies a filename by using duplicate single quotes within the context of a double-quoted string:
This example issues a PL/SQL stored procedure called