HOST

Syntax

Text description of the illustration host.gif

Purpose

To invoke an operating system command-line sub-shell from within RMAN.

Restrictions and Usage Notes

Execute this command at the RMAN prompt or within the braces of a RUN command.

Keywords and Parameters

HOST	Enables you to execute an operating system command. Use this parameter: With a 'command', in which case RMAN runs the command in the specified string and then continues. Without a 'command', in which case RMAN displays a command prompt and resumes after you exit the subshell.

Examples

Executing an Operating System Copy Within RMAN: Example

This example shuts down the database, makes a backup of datafile tbs_01.f by using a media manager, then makes an image copy of the same file on disk by using a UNIX command. The database needs to be shut down cleanly to prevent fractured blocks:

SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
BACKUP DATAFILE '$ORACLE_HOME/dbs/tbs_01.f';
HOST 'cp $ORACLE_HOME/dbs/tbs_01.f $ORACLE_HOME/dbs/copy/tbs_01.f';
ALTER DATABASE OPEN;

Hosting to the Operating System Within a Copy Job: Example

This example makes an image copy of datafile 3, hosts out to the UNIX prompt to check that the copy is in the directory (the UNIX session output is indented and displayed in bold), then resumes the RMAN session:

COPY DATAFILE 3 TO 'df.3';
HOST;
  % ls df.3
  df.3
  % exit
LIST COPY;