LOG_ARCHIVE_FORMAT %r%s%t

最新推荐文章于 2021-04-07 05:02:36 发布

duqiangatom

最新推荐文章于 2021-04-07 05:02:36 发布

阅读量640

点赞数

CC 4.0 BY-SA版权

分类专栏： ORA-备份恢复

本文链接：https://blog.youkuaiyun.com/duqiangatom/article/details/8309162

ORA-备份恢复专栏收录该内容

8 篇文章

订阅专栏

本文详细介绍了在ARCHIVELOG模式下使用LOG_ARCHIVE_FORMAT参数配置重做日志归档文件的默认名称格式，包括如何使用变量如log_sequence_number、thread_number、activationID等来生成唯一且有意义的文件名。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

LOG_ARCHIVE_FORMAT is applicable only if you are using the redo log in ARCHIVELOG mode. Use a text string and variables to specify the default filename format when archiving redo log files. The string generated from this format is appended to the string specified in the LOG_ARCHIVE_DEST parameter.

The following variables can be used in the format:
%s log sequence number
%S log sequence number, zero filled
%tthread number
%Tthread number, zero filled
%a activation ID
%d database ID
%r resetlogs ID that ensures unique names are constructed for the archived log files across multiple incarnations of the database

At least %r%s%t is needed