|Oracle® Database Recovery Manager Reference
10g Release 1 (10.1)
Part Number B10770-02
A subclause that specifies one or more patterns to be used in generating new database file names based on old ones. Used with
DUPLICATE as one way of generating output file names.
The rules for these patterns and how they affect file naming are the same as those for the initialization parameter
DB_FILE_NAME_CONVERT. In parentheses, provide an even number of string patterns.
When a new filename is generated based on an old one, the original filename is compared to the first member of each pair of string patterns. The first time a pattern is found which is a substring of the original filename, the new filename is generated by substituting the second member of the pair for the substring that matched.
string_pattern to a value such as:
string1is a pattern matching the orignal filename
string2is the pattern replacing
string1in the generated filename
string3is a pattern matching the orignal filename
string4is the pattern replacing
string3in the generated filename
You can use as many pairs of primary and standby replacement strings as required.
For example, when making image copy backups of tablespaces
users (with datafiles in directory
tools (with datafiles in
/disk1/dbs/tools/), to direct the converted datafiles to
/newdisk/tools respectively, use the
DB_FILE_NAME_CONVERT pattern shown here:
For each datafile to be converted where '
disk1/dbs' is a substring of the filename, the new filename is created by replacing '
disk1/dbs' with '
newdisk'. For example, the converted datafile corresponding to
/disk1/dbs/users/users01.dbf is stored in
/newdisk/users/users01.dbf, the converted datafile corresponding to
/disk1/dbs/tools/tools01.dbf is stored in
/newdisk/tools/tools.dbf, and so on.
Be aware of the following details:
would direct the image copies to
would have the same effect as the previous example, because the pattern '
dbs' matches the filename and there is no reason to compare it to the second pattern '
Specifies the pattern, consisting of the pairs of strings used to convert the filenames..
This example shows the use of
BACKUP AS COPY to create image copies of the
tools tablespaces from the above discussion, directing