ORA-16038,ORA-19809,ORA-00312

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

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

0 ·

CC 4.0 BY-SA版权

文章标签：

#documentation #delete #database #archive #file #disk

Oracle 恢复测试专栏收录该内容

5 篇文章

订阅专栏

本文介绍了解决Oracle数据库中归档日志无法归档及恢复文件数量限制超出的问题。通过调整参数、清理过期归档日志等步骤，确保数据库能够正常运作。

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

SQL> alter database open; alter database open * 第 1 行出现错误: ORA-16038: 日志 1 序列号 74 无法归档 ORA-19809: 超出了恢复文件数的限制 ORA-00312: 联机日志 1 线程 1: 'C:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO01.LOG'

解决办法;

$rman RMAN>connect target / RMAN> crosscheck archivelog all; RMAN> delete expired archivelog all;

RMAN>exit

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