Skip Headers

Oracle® Database Recovery Manager Reference
10g Release 1 (10.1)

Part Number B10770-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 current chapter
Up
Go to next page
Next
View PDF

datafileSpec

Syntax

datafileSpec::=

Text description of datafileSpec.gif follows


Text description of datafileSpec



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:

BACKUP AS COPY
  DATAFILE '?/oradata/trgt/users01.dbf' 
  FORMAT '?/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:

BACKUP AS COPY
  DATAFILE 3 FORMAT '?/oradata/df3.cpy',
  DATAFILE 4 FORMAT '?/oradata/df4.cpy';