RUN

Syntax

Text description of the illustration run.gif

backupCommands::=

Text description of the illustration backupCommands.gif

restoreCommands::=

Text description of the illustration restoreCommands.gif

maintenanceCommands::=

Text description of the illustration maintenanceCommands.gif

miscellaneousCommands::=

Text description of the illustration miscellaneousCommands.gif

Purpose

To compile and execute job commands, which are one or more statements executed within the braces of RUN. The RUN command compiles the list of job commands into one or more job steps and then executes them immediately.

Restrictions and Usage Notes

• Execute this command only at the RMAN prompt.
• You must precede and follow the list of job commands with an opening and closing brace.

Keywords and Parameters

Refer to individual entries for information about commands that you can run from the RMAN prompt.

Examples

Making a Backup: Example

This example backs up a database by using a single manually allocated channel to perform the backup:

RUN
{
  ALLOCATE CHANNEL c1 TYPE sbt;
  BACKUP DATABASE;
}

Restoring and Recovering a Tablespace: Example

This example takes tablespace tools offline, restores it, then performs complete media recovery:

RUN
{  
  SQL "ALTER TABLESPACE tools OFFLINE IMMEDIATE"; 
  RESTORE TABLESPACE tools; 
  RECOVER TABLESPACE tools;  
  SQL "ALTER TABLESPACE tools ONLINE"; 
} 

Executing an RMAN Script: Example

This example executes the stored script backup_db:

RUN { EXECUTE SCRIPT backup_db; }