ERROR: ORA-00257: archiver error. Connect internal only, until freed.

最新推荐文章于 2023-09-15 15:32:37 发布

原创最新推荐文章于 2023-09-15 15:32:37 发布 · 429 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

知识点测试

本文介绍了Oracle数据库中归档日志模式下自动归档停止的问题及解决方法，包括通过删除旧归档日志和调整闪回日志文件最大大小来解决归档空间不足导致的错误。

show parameter recovery

SQL> show parameter recovery ;

发现 db_recovery_file_dest_size 值太小了，当归档超过这个值之后就会报错

ERROR: ORA-00257: archiver error. Connect internal only, until freed.

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 4723
Next log sequence to archive 4728

Current log sequence 4728

原因：

The database is running in archive log mode with automatic archiving turned on. When the archive log destination diskspace becomes full the automatic archiving will stop. This is expected to happen. At this point a message should appear on the screen: ORACLE Instance v816 - Can not allocate log, archival required When all of the online redo logs are filled up, the database will be in a hang state. After freeing up diskspace the online redo logs are still not archiving. In most cases this is the CORRECT behaviour.

解决方法如下

方法一：

1. 直接删除物理数据 rm

2. 通过 rman 删除:

rman target

执行如下命令：

(1) crosscheck backup;

(2) delete obsolete;

(3) delete expired backup;

(4) crosscheck archivelog all;

(5) delete expired archivelog all;

(6) host;