datafileSpec::=
A subclause that specifies a datafile by filename or absolute file number.
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 stringsSyntax 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. |
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';