详细看这片文章:
大概步骤为下:
1,查看闪回区已被用的空间:
- SQL> SELECT substr(name, 1, 30) name, space_limit AS quota,
- space_used AS used,
- space_reclaimable AS reclaimable,
- number_of_files AS files
- FROM v$recovery_file_dest ;
2,手工删除无用的文件
3,然后打开RMAN
--连接到目标库
RMAN> connect target /
--交叉检查日志
RMAN> crosscheck archivelog all;
--删除过期日志
RMAN> delete expired archivelog all;
阅读(2088) | 评论(0) | 转发(0) |