4.数据库闪回区状态检查与清理

select sum(percent_space_used) from v$flash_recovery_area_usage;

select file_type,percent_space_used as used,percent_space_reclaimable as reclaimable,
number_of_files as "number" from v$flash_recovery_area_usage;

紧急情况下需要按照下面命令执行
su - oracle
rman target /
delete force noprompt archivelog like '+FRA/DB_NAME/%' completed before 'sysdate-(30/24/60)';

posted @ 2025-09-19 11:16  ocmji  阅读(9)  评论(0)    收藏  举报