Oracle 参数 DB_FILE_NAME_CONVERT 官方解释，作用，如何配置最优化建议
本站中文解释
DB_FILE_NAME_CONVERT 参数可以指定实例恢复时对象文件路径名的转换，一般做跨平台迁移使用，比如从UNIX迁移到Windows。可以设置两个不同格式的文件路径前后对照表，注意使用字符串’/’而不是转义符’//’来表示源路径分隔符，而使用转义符’//’来表示目标路径分隔符。
正确的设置方法为：
DB_FILE_NAME_CONVERT = (‘源文件路径1′,’源文件路径2′,’目标文件路径1′,’目标文件路径2’)
其中，源文件路径使用’/’作为分隔符，目标文件路径使用’//’作为分隔符。
官方英文解释
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.
| Property | Description |
|---|---|
|
Parameter type |
String |
|
Syntax |
Where:
You can enclose each string in single or double quotation marks. You can specify as many pairs of primary and standby replacement strings as required. However, starting with Oracle Database 12c Release 2 (12.2), Oracle recommends that you limit the number of pairs to 99. Example:
|
|
Default value |
There is no default value. |
|
Modifiable |
|
|
Modifiable in a PDB |
No |
|
Basic |
No |
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.
Set the value of this parameter to one or more pairs of strings. The first string in a pair is the pattern found in the datafile names on the primary database. The second string in a pair is the pattern found in the datafile names on the standby database.
If you specify an odd number of strings (the last string has no corresponding replacement string), an error is returned 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). However, starting with Oracle Database 12c Release 2 (12.2), Oracle recommends that you limit the number of pairs to 99.
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.
See Also:
-
Oracle Database Backup and
Recovery User’s Guide for more information about database backup and recovery -
Oracle Data Guard Concepts
and Administration for more information about Oracle Data Guard
