ORA-16038和ora-19809错误

最新推荐文章于 2023-11-02 19:32:01 发布

原创最新推荐文章于 2023-11-02 19:32:01 发布 · 991 阅读

0 ·

CC 4.0 BY-SA版权

Oracle 错误解决专栏收录该内容

45 篇文章

订阅专栏

本文介绍了如何解决遇到的ORA-16038和ORA-19809错误。通过调整DB_RECOVERY_FILE_DEST_SIZE参数大小或者清除不必要的归档日志文件来释放恢复目录的空间。提供了详细的步骤说明。

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

今天遇到ORA-16038 ora-19809错误，查了资料解决了：

结果是发现DB_RECOVERY_FILE_DEST_SIZE太小了，恢复目录空间不够了所至

There are a couple of possible options.
1) Increase the parameter db_recovery_file_dest_size
2) Stop using the db_recovery_file_dest by unsetting the parameter. (This assumes you never really wanted to use this option)
3) Remove the Entries from the rman repository/Controlfile

The removal is desribed in the RMAN documentation but this is a quick and dirty way if you don't have an rman repository - but could endanger your ability to recover - so be careful.

a) delete unwanted archive log files from disk (rm, del commands)
b) connect to rman ( RMAN> connect target / )
c) RMAN> crosscheck archivelog all;
- marks the controlfile that the archives have been deleted
d) RMAN> delete expired archivelog all;
- deletes the log entries identified above.