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 , 22 of 59


datafileSpec

Syntax

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


Purpose

A subclause that specifies a datafile by filename or absolute file number.

Restrictions and Usage Notes

Keywords and Parameters

Syntax Element Description

'filename'

Specifies the datafile by using either the full path or a relative filename. If you specify a relative filename, the filename is qualified in a port-specific manner by the target database.

integer

Specifies the datafile by using its absolute file number. Obtain the file number from the V$DATAFILE, V$DATAFILE_COPY, or V$DATAFILE_HEADER views or REPORT SCHEMA command output.

Examples

Specifying a Datafile by Filename: Example

This example copies datafile ?/oradata/trgt/users01.dbf to disk, specifying it by filename:

COPY DATAFILE '?/oradata/trgt/users01.dbf' TO '?/oradata/users01.cpy';
Specifying a Datafile by Absolute File Number: Example

This example copies datafiles 3 and 4 to disk, specifying them by file number:

COPY DATAFILE 3 TO '?/oradata/df3.cpy',
     DATAFILE 4 TO '?/oradata/df4.cpy';

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