Oracle 参数 LOG_FILE_NAME_CONVERT 官方解释，作用，如何配置最优化建议

本站中文解释

_

LOG_FILE_NAME_CONVERT_参数用于控制数据库记录日志文件的存储位置和文件名，以便灵活地满足管理用户需要。该参数可以指定系统参数和其他参数之间的映射关系。格式为‘old-name＝new-name’，其中old-name是原来的文件名，new-name是改变后的文件名，使用“$”可以引用系统参数，也可以使用正则表达式。

正确设置方法：

1、确定日志文件存放位置。

2、确定日志文件名格式，可以使用系统参数$ORACLE_SID、$LOG_ARCHIVE_DEST(归档目的地)、$ORACLE_UNQ_NAME。

3、根据需要确定参数LOG_FILE_NAME_CONVERT的值，如‘PRO_Disaster/logfiles/$ORACLE_SID/$LOG_ARCHIVE_DEST/$ORACLE_UNQ_NAME/$ORACLE_SID.xxx’。

4、正确配置完成后，新的日志文件会存放在new-name中指定的位置。

官方英文解释

LOG_FILE_NAME_CONVERT converts the filename of a new log file on the primary database to the filename of a log file on the standby database.

If you add a log file to the primary database, you must add a corresponding file to the standby database.

Set the value of this parameter to one or more pairs of strings. The first string is the pattern found in the log file names on the primary database. The second string is the pattern found in the log file names on the standby database.

When the standby database is updated, this parameter converts the log file name on the primary database to the log file name on the standby database. The file must exist on the standby database and must 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).

You should also use LOG_FILE_NAME_CONVERT to rename the logfiles in the clone control file when setting up the clone database during tablespace point-in-time recovery.

Note:

The LOG_FILE_NAME_CONVERT parameter applies only to online logs (not to archived logs).

See Also:

Oracle Data Guard Concepts
and Administration