数据库闪回恢复区满了解决

1、删除归档日志

$rman target /

RMAN> list archivelog all;

RMAN>crosscheck archivelog all;

RMAN>change archivelog until logseq=130 thread=1 delete;

或者 RMAN>delete expired archivelog all;

2、取消闪回恢复区

alter system set db_recovery_file_dest='';

 

 

3、更改归档日志路径

show parameter db_recover;

archive log list;

alter system set log_archive_dest_1='location=+DATA1' sid='*' scope=both;