ITPub博客

首页 > 数据库 > Oracle > 登录 Oracle 数据库报错,ORA-00257: archiver error

登录 Oracle 数据库报错,ORA-00257: archiver error

原创 Oracle 作者:feelpurple 时间:2015-12-12 17:11:35 0 删除 编辑
登录一台测试数据库报错

[oracle@PTFDB1 ~]$ sqlplus tran/PreTran13588


SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 11 18:24:43 2015


Copyright (c) 1982, 2011, Oracle.  All rights reserved.


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

报错的原因是归档满了,无法进行归档。

查询ASM盘的使用情况,可以看到存放归档日志的 FRA 盘已经使用了 100%。

[oracle@PTFDB1 ~]$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 11 18:21:22 2015


Copyright (c) 1982, 2011, Oracle.  All rights reserved.




Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing options

18:21:29 sys@PTFDB> SELECT NAME,TYPE,TOTAL_MB,FREE_MB,(TOTAL_MB-FREE_MB) USED_MB,100*round((TOTAL_MB-FREE_MB)/TOTAL_MB,4)||'%' "Used %" FROM V$ASM_DISKGROUP;

NAME       TYPE TOTAL_MB    FREE_MB    USED_MB Used %
------------------------------ ------ ---------- ---------- ---------- -----------------------------------------
DATA       EXTERN  614399     201069 413330 67.27%
FRA       EXTERN  204797      44827 159970 100.00%
OCR       NORMAL    3057       2131   926 30.29%
REDO1       EXTERN    5114       4776   338 6.61%
REDO2       EXTERN    5114       4776   338 6.61%

解决方法是删除过期的归档文件,释放空间。

[oracle@PTFDB2 ~]$ rman target /


Recovery Manager: Release 11.2.0.3.0 - Production on Sat Dec 12 15:46:43 2015


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


connected to target database: PTFDB (DBID=4173298199)


RMAN> delete noprompt archivelog until time 'sysdate-7';



来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/26506993/viewspace-1871026/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2014-08-01

  • 博文量
    404
  • 访问量
    1673960