登录一台测试数据库报错
[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/
,如需转载,请注明出处,否则将追究法律责任。