ORA-00257: archiver error
归档满问题:
报错:
SQL> conn admin/admin
ERROR:
ORA-00257: archiver error. Connect internal only, until freed.
Warning: You are no longer connected to ORACLE.
检查空间:
SQL> select name, total_mb, free_mb from v$asm_diskgroup;
NAME TOTAL_MB FREE_MB
------------------------------ ---------- ----------
ARCH 327680 176
DATA 737280 10941
OCRBAK 30720 29794
SQL> select name,total_mb,free_mb from v$asm_disk;
如果用到recover_area_usage,那么检查select * from V$FLASH_RECOVERY_AREA_USAGE;
处理方法:
asmcmd
cd +ARCH/jxdb/archivelog/
rm -rf 2014_10_*
rman target /
crosscheck archivelog all;
delete noprompt expired archivelog all;
或者:(本次使用下面方法)
delete noprompt force archivelog all completed before 'sysdate-7';
强制删除全部的话:
delete noprompt force archivelog all;