当报[ORA-00257: archiver error. Connect internal only, until freed. ] 错误时:
1、在linux下切换到Oracle用户下:
su - oracle
2、进入rman
>rman
>connect target sys/oracle (connect target /)
>crosscheck archivelog all;
>delete expired archivelog all;
当delete时报specification does not match any archive log in the recovery catalog;
根据“crosscheck archivelog all;” 输出显示归档日志存放的位置,定位到日志路径下,删除文件.
>rm -rf arch_*.dbf
然后在执行delete expired archivelog all;。显示删除文件的过程信息。