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)';

浙公网安备 33010602011771号