DB_FILE_NAME_CONVERT

Syntax DB_FILE_NAME_CONVERT = 'string1' , 'string2' ,
'string3' , 'string4' , ...
Where:
■ string1 is the pattern of the primary database filename
■ string2 is the pattern of the standby database filename
■ string3 is the pattern of the primary database filename
■ string4 is the pattern of the standby database filename
You can use as many pairs of primary and standby replacement strings
as required. You can use single or double quotation marks.
The following are example settings that are acceptable:
LOG_FILE_NAME_CONVERT = '/dbs/t1/','/dbs/t1/s_
','dbs/t2/ ','dbs/t2/s_'
Default value There is no default value.
Modifiable ALTER SESSION
Basic No

DB_FILE_NAME_CONVERT is useful for creating a duplicate database for recovery
purposes. It converts the filename of a new datafile on the primary database to a
filename on the standby database. If you add a datafile to the primary database, you
must add a corresponding file to the standby database. When the standby database is
updated, this parameter converts the datafile name on the primary database to the
datafile name on the standby database. The file on the standby database must exist
and be writable, or the recovery process will halt with an error.

If you specify an odd number of strings (the last string has no corresponding
replacement string), an error is signalled during startup. If the filename being
converted matches more than one pattern in the pattern/replace string list, the first
matched pattern takes effect. There is no limit on the number of pairs that you can
specify in this parameter (other than the hard limit of the maximum length of
multivalue parameters).

Set the value of this parameter to two strings. The first string is the pattern found in
the datafile names on the primary database. The second string is the pattern found in
the datafile names on the standby database.

You can also use DB_FILE_NAME_CONVERT to rename the datafiles in the clone
control file when setting up a clone database during tablespace point-in-time recovery.

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-1002233/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-1002233/