aiaiDBA

加微信获取免费职业规划+学习资料，了解年薪50万的DBA是如何练成的

13718043309

010-86462881

ORA-16018: cannot use string with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST

ORA-16018: cannot use string with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST
Cause: One of the following events caused an incompatibility: 1) Parameter LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST was in use when a LOG_ARCHIVE_DEST_n (n = 1...31) parameter was encountered while fetching initialization parameters. 2) An ALTER SYSTEM ARCHIVE LOG START TO command was in effect when a LOG_ARCHIVE_DEST_n parameter was encountered while fetching initialization parameters. 3) A LOG_ARCHIVE_DEST_n parameter was in use when an ALTER SYSTEM command was used to define a value for either the LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST parameter. 4) Parameter DB_RECOVERY_FILE_DEST was in use when an attempt was made to use an ALTER SYSTEM or ALTER SESSION command to define a value for LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST.
Action: Eliminate any incompatible parameter definitions.

请先 登录 后评论
默认排序 时间排序

1 个回答

小智
ORA-16018：不能使用带LOG_ARCHIVE_DEST_n或DB_RECOVERY_FILE_DEST的字符串,
.原因：以下事件之一导致不兼容性：1）当获取初始化参数时遇到LOG_ARCHIVE_DEST_n（n = 1 ... 31）参数时，正在使用参数LOG_ARCHIVE_DEST或LOG_ARCHIVE_DUPLEX_DEST。2）当获取初始化参数时遇到LOG_ARCHIVE_DEST_n参数时，ALTER SYSTEM ARCHIVE LOG START TO命令生效。3）当使用ALTER SYSTEM命令定义LOG_ARCHIVE_DEST或LOG_ARCHIVE_DUPLEX_DEST参数的值时，使用LOG_ARCHIVE_DEST_n参数。4）尝试使用ALTER SYSTEM或ALTER SESSION命令定义LOG_ARCHIVE_DEST或LOG_ARCHIVE_DUPLEX_DEST的值时，正在使用参数DB_RECOVERY_FILE_DEST。,
.操作：消除任何不兼容的参数定义。,
.
请先 登录 后评论
  • 1 关注
  • 0 收藏，646 浏览
  • 慧慧 提出于 2018-08-30 16:43

相似问题