Skip Headers
Oracle® Database Backup and Recovery Reference
10g Release 2 (10.2)

Part Number B14194-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

HOST

Syntax

host::=

Description of host.gif follows
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

Syntax Element Description
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 system01.dbf, then executes the UNIX ls command to display all backed up datafiles:

SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
BACKUP DATAFILE '?/oradata/trgt/system01.dbf'
  FORMAT '/tmp/system01.dbf';
HOST 'ls -l /tmp/*dbf';
ALTER DATABASE OPEN;

Hosting to the Operating System Within a Backup: 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:

RMAN> BACKUP DATAFILE 3 FORMAT '?/oradata/df3.cpy';
RMAN> HOST;
  % ls $ORACLE_HOME/oradata/df3.cpy
  /net/oracle/oradata/df3.cpy
  % exit
RMAN> LIST COPY;