Oracle操作(连接出现 ORA-00257 archiver error. connect internal only, until freed.)

出现这样的提示,说明归档日志已满。需要删除部分归档日志;

登陆数据库服务器,登陆rman

执行

$ rman


Recovery Manager: Release 11.2.0.3.0 - Production on Thu Sep 25 11:30:51 2014


Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


RMAN> 

执行

RMAN> connect target sys/oracle2013


connected to target database: WWPSMLN (DBID=1970480238)

(connect target为链接目标)

执行

RMAN> crosscheck archivelog all;

查看日志

---备份日志(有需要的话)

RMAN> backup archivelog all;

按情况删除日志:

---删除过期的归档日志

RMAN> delete expired archivelog all;

--按指定日期删除(以系统时间向前推几天的概念,保留3天的日志)

RMAN> delete archivelog all completed before 'SYSDATE-3';

由王文杰、高伟波提供典型经验