RUN

Syntax

Text description of the illustration run.gif

backupCommands::=

Text description of the illustration backupco.gif

restoreCommands::=

Text description of the illustration restorec.gif

maintenanceCommands::=

Text description of the illustration maintena.gif

miscellaneousCommands::=

Text description of the illustration miscella.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 tbs_1 offline, restores it, then performs complete media recovery:

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

Executing an RMAN Script: Example

This example executes the stored script backupdb:

RUN { EXECUTE SCRIPT BACKUPDB; }