Skip Headers
Oracle® Database Backup and Recovery Reference
11g Release 1 (11.1)

B28273-03
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
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

datafileSpec

Purpose

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

Syntax

datafileSpec::=

The diagrams shows the syntax for datafileSpec
Description of the illustration datafilespec.gif

Semantics

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