datafileSpec

Syntax

datafileSpec::=

Purpose

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

Restrictions and Usage Notes

You can specify the relative or absolute path name.
Double and single quotes are both legal (although only single quotes are shown in the diagram). Double quotes are recommended in the SQL command.
Use ? to represent the Oracle home and @ for the Oracle SID.

See Also:
"Placeholders" to learn about the difference between single and double quotes, as well as the behavior of environment variables in RMAN quoted strings

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';