关于ORA-00257: archiver error. Connect internal only, until freed 错误的处理方法 - 重庆思庄Oracle、Redhat认证学习论坛

315565f30f5ac68799.png (50.39 KB, 下载次数: 124)

2020-8-10 15:22 上传

现在来清理一下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

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