清理FRA（FlashRecoveryArea）空间”

1. 查看当前FRA使用情况： SELECT * FROM V$RECOVERY_FILE_DEST;

2. 删除旧的备份和归档文件： DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7'; BACKUP RECOVERY AREA;

3. 设定FRA自动清理： CONFIGURE RETENTION POLICY TO REDUNDANCY 1; CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY; CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/oradata/orcl/control01.ctl';

4. 手动清理FRA： SQL>ALTER SYSTEM CHECKPOINT; RMAN>DELETE BACKUPSET; RMAN>CROSSCHECK BACKUP; RMAN>CROSSCHECK ARCHIVELOG ALL; RMAN>DELETE NOPROMPT OBSOLETE RECOVERY WINDOW OF 7 DAYS;

注意：以上操作需要谨慎，防止误删数据。建议先备份数据再进行清理。