Skip Headers

Oracle9i Recovery Manager Reference
Release 2 (9.2)

Part Number A96565-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

RMAN Commands , 53 of 59


SPOOL

Syntax

Text description of spool.gif follows
Text description of the illustration spool.gif


Purpose

To write RMAN output to a log file.

If the file does not already exist, then RMAN creates it. If the file does exist, then RMAN overwrites the file, unless APPEND is specified, in which case RMAN appends its output to the end of the file. The SPOOL command does not terminate if the specified file cannot be opened for writing. Instead, RMAN turns SPOOL to OFF.

See Also:

"cmdLine" for a description of LOG files

Restrictions and Usage Notes

Execute the SQL command at the RMAN prompt.

Keywords and Parameters

Syntax Element Description

OFF

Turns off spooling.

TO filename

Specifies the name of the log file to which RMAN directs its output. RMAN 
creates the file if it does not exist, or overwrites the file if it does exist.

APPEND

Specifies that RMAN should append its output to the end of the existing log 
file.

Examples

Spooling RMAN Output to a File: Example

This example directs RMAN output to standard output for the backup of datafile 1, then directs output to a log file for the backup of datafile 2, then directs output to a different log file for the whole database backup:

BACKUP DATAFILE 1;
SPOOL LOG TO '/tmp/df2log.f';
BACKUP DATAFILE 2;
SPOOL LOG OFF;
SPOOL LOG TO '/tmp/dblog.f';
BACKUP DATABASE;
SPOOL LOG OFF;

Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback