Oracle Flash-back Zone full solution

Flash back area full:
OS:RM-RF [Archivelog autobackup backupset controlfile Flashback Onlinelog]
Eg:
Archivelog autobackup backupset controlfile Flashback Onlinelog
[Email protected] prod]$ CD autobackup/
[[email protected] autobackup]$ ls
2014_10_13 2014_10_15 2014_10_16
[Email protected] autobackup]$ RM-RF 2014_10_13
[Email protected] autobackup]$ RM-RF 2014_10_15

RMAN:

Rman> crosscheck Backup;
rman> Delete expired backup;

Rman> crosscheck Archivelog All;
rman> Delete expired Archivelog all;

Sqlplus

[email protected]>show parameter db_re

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
Db_recovery_file_dest String/u01/app/oracle/fast_recovery_
Area
Db_recovery_file_dest_size Big Integer 4G
Db_recycle_cache_size Big Integer 0
[email protected]>desc V$recovery_area_usage;
Name Null? Type
----------------------------------------- -------- ----------------------------
File_type VARCHAR2 (20)
percent_space_used number
Percent_space_reclaimable number
Number_of_files number

[email protected]>select sum (percent_space_used) from V$recovery_area_usage;

SUM (percent_space_used)
-----------------------
33.45

Oracle Flash-back Zone full solution