datafileSpec

Purpose

Use the datafileSpec subclause to specify a datafile by filename or absolute file number.

Syntax

datafileSpec::=

Description of the illustration datafilespec.gif

Semantics

Syntax Element Description

Syntax Element	Description
`'filename'`	Specifies the datafile by using either the full path or a relative filename. If you specify a relative filename, then the filename is qualified in a port-specific manner by the target database. Note that you can use `?` to represent the Oracle home and `@` for the Oracle SID (see Example 3-14). Double and single quotes are both legal (although only single quotes are shown in the diagram). See Also: "Quotes in RMAN Syntax" to learn about the difference between single and double quotes, as well as the behavior of environment variables in RMAN quoted strings
`integer`	Specifies the datafile by using its absolute file number (see Example 3-13). Obtain the file number from the `V$DATAFILE`, `V$DATAFILE_COPY`, or `V$DATAFILE_HEADER` views or `REPORT` `SCHEMA` command output.

'filename'

Specifies the datafile by using either the full path or a relative filename. If you specify a relative filename, then the filename is qualified in a port-specific manner by the target database. Note that you can use ? to represent the Oracle home and @ for the Oracle SID (see Example 3-14).

Double and single quotes are both legal (although only single quotes are shown in the diagram).

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

integer Specifies the datafile by using its absolute file number (see Example 3-13). Obtain the file number from the V$DATAFILE, V$DATAFILE_COPY, or V$DATAFILE_HEADER views or REPORT SCHEMA command output.

Examples

Example 3-13 Specifying a Datafile by Filename

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

BACKUP AS COPY
  DATAFILE '/disk1/oradata/prod/users01.dbf' 
  FORMAT '/disk2/users01.cpy';

Example 3-14 Specifying a Datafile by Absolute File Number

This example copies datafiles 1 and 2 to disk, specifying them by file number:

BACKUP AS COPY
  DATAFILE 1 FORMAT '/disk2/df1.cpy'
  DATAFILE 2 FORMAT '/disk2/df1.cpy';