---

datafileSpec

Syntax

Purpose

A sub-clause that specifies a datafile by filename or absolute file number.

Keywords and Parameters

'datafile'	specifies the datafile 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 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

This example copies datafile /oracle/dbs/tbs_12 to disk, specifying it by filename:

run {
     allocate channel ch1 type disk;
     copy datafile '/oracle/dbs/tbs_12.f'
       to '/oracle/copy/tbs_1.copy';
}

Specifying a Datafile by Absolute File Number

This example copies datafile /oracle/dbs/tbs_31.f to disk, specifying it by file number:

RMAN> report schema;

RMAN-03022: compiling command: report
Report of database schema
File K-bytes    Tablespace           RB segs Name
---- ---------- -------------------- ------- -------------------
1         47104 SYSTEM               YES     /vobs/oracle/dbs/tbs_01.f
2           978 SYSTEM               YES     /vobs/oracle/dbs/tbs_02.f
3           978 TBS_1                NO      /vobs/oracle/dbs/tbs_11.f
4           978 TBS_1                NO      /vobs/oracle/dbs/tbs_12.f
5           978 TBS_2                NO      /vobs/oracle/dbs/tbs_21.f
6           978 TBS_2                NO      /vobs/oracle/dbs/tbs_22.df
7           500 TBS_1                NO      /vobs/oracle/dbs/tbs_13.f
8           500 TBS_2                NO      /vobs/oracle/dbs/tbs_23.f
9           500 TBS_2                NO      /vobs/oracle/dbs/tbs_24.f
10          500 TBS_3                NO      /vobs/oracle/dbs/tbs_31.f

run {
     allocate channel ch1 type disk;
     copy datafile 10
     to '/oracle/copy/tbs_31.copy';
}

---