aiaiDBA

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

13718043309

010-86462881

ORA-19801: initialization parameter DB_RECOVERY_FILE_DEST is not set

ORA-19801: initialization parameter DB_RECOVERY_FILE_DEST is not set
Cause: An attempt was made to create a file in DB_RECOVERY_FILE_DEST when DB_RECOVERY_FILE_DEST was not set. There are number of possible causes of this error, including: 1) A LOG_ARCHIVE_DEST_n parameter was specified using a LOCATION attribute whose value was DB_RECOVERY_FILE_DEST and an archived log file creation was attempted. 2) STANDBY_ARCHIVE_DEST parameter was specified using a LOCATION attribute whose value was DB_RECOVERY_FILE_DEST and an archived log file creation was attempted.
Action: Specify a valid destination for DB_RECOVERY_FILE_DEST in initialization parameter file or with the ALTER SYSTEM SET command.

请先 登录 后评论

1 个回答

小智
ORA-19801:初始化参数DB_RECOVERY_FILE_DEST未设置,
.原因:尝试在未设置DB_RECOVERY_FILE_DEST的情况下在DB_RECOVERY_FILE_DEST中创建文件。此错误的可能原因有多种,包括:1)使用值为DB_RECOVERY_FILE_DEST的LOCATION属性指定了LOG_ARCHIVE_DEST_n参数,并尝试创建归档日志文件。2)使用值为DB_RECOVERY_FILE_DEST的LOCATION属性指定了STANDBY_ARCHIVE_DEST参数,并尝试创建归档日志文件。,
.操作:在初始化参数文件中或使用ALTER SYSTEM SET命令为DB_RECOVERY_FILE_DEST指定有效的目标。,
.
请先 登录 后评论