Question

如何正确删除oracle归档文件解决ora-00257问题

Answer 1

是你的归档日志满了
首先查看相关的信息，确认这一状况
select * from v$recovery_file_dest;
select sum(percent_space_used)*3/100 from v$flash_recovery_area_usage;
select * from v$flash_recovery_area_usage;
select * from v$version;

之后确认空间满了，之后再rman备份中删除
rman target sys/pass@prjdb
crosscheck archivelog all;
delete archivelog until time 'sysdate'; --删除所有日志
delete expired archivelog all;--删除过期日志