关于ORA-00257: archiver error. Connect internal only, until freed 错误的处理方法

jiawang

plsql连接数据库报[Content]
ORA-00257: archiver error. Connect internal only, until freed.


产生原因：出现ORA-00257错误（空间不足错误），绝大部分说这是由于归档日志太多，占用了全部的硬盘剩余空间导致的，通过简单删除日志或加大存储空间就能够解决。


问题分析：



现在来清理一下archivelog归档日志
[oracle@rac02 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Aug 10 15:24:53 2020
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u02/arch
Oldest online log sequence     1454
Next log sequence to archive   1459
Current log sequence           1459
SQL>

[oracle@rac02 ~]$ cd  /u02/arch
[oracle@rac02 arch]$ ll


删除归档日志，释放磁盘空间