2.1 @ (at sign)
Purpose
Use the @ command to execute a series of RMAN commands stored in an operating system file with the specified path name.
Note:
The file must contain complete RMAN commands. Partial commands generate syntax errors.
Prerequisites
The command file must contain complete RMAN commands.
If you use the @ command within a RUN command, then the @ command must be on its own line (see Example 2-2).
Usage Notes
RMAN processes the file as though its contents were entered instead of the @ command. As shown in Example 2-3, you can specify substitution variables in a command file and then pass values to the command file during execution.
See Also:
RMAN to learn more about using substitution variables in RMAN
Semantics
| Syntax Element | Description |
|---|---|
|
|
Specifies the name of a command file, for example, Any file extension (or no file extension) is valid. Do not use quotes around the string or leave whitespace between the |
Examples
Example 2-1 Running a Command File from the Operating System Command Line
This example creates an RMAN command file and then executes it from the operating system command line.
% echo "BACKUP DATABASE;" > backup_db.rman % rman TARGET / @backup_db.rman
Example 2-2 Running a Command File Within RMAN
This example shows how you can execute a command file from the RMAN prompt and from within a RUN command. User-entered text appears in bold.
RMAN> @backup_db.rman RMAN> RUN { 2> @backup_db.rman 3> backup database; 4> **end-of-file** 5> }
Example 2-3 Specifying Substitution Variables
Suppose that you use a text editor to create command file whole_db.rman with the following contents:
# name: whole_db.rman BACKUP TAG &1 COPIES &2 DATABASE; EXIT;
The following example starts RMAN from the operating system prompt and connects to the target database. The example then runs the @ command, passing variables to the command file to create two database backups with tag Q106:
% rman TARGET / RMAN> @/tmp/whole_db.rman Q106 2