ORA-19905: log_archive_format must contain %s, %t and %r

ORA-19905: log_archive_format must contain %s, %t and %r
Cause: log_archive_format is missing a mandatory format element. Starting with Oracle 10i, archived log file names must contain each of the elements %s(sequence), %t(thread), and %r(RESETLOGS ID) to ensure that all archived log file names are unique.
Action: Add the missing format elements to log_archive_format.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:44

ORA-19905：log_archive_format必须包含％s，％t和％r,
.原因： log_archive_format缺少必需的格式元素。与Oracle 10i的开始，归档日志文件名必须包含每个元素％S（序列），％T（线程），并％R（RESETLOGS ID），以确保所有归档日志文件名称是唯一的。,
.操作：将缺少的格式元素添加到log_archive_format。,
.

aiaiDBA

13718043309

010-86462881

ORA-19905: log_archive_format must contain %s, %t and %r

1 个回答

相似问题