Run the following script to get the information about the flashback recovery in HTML format in Oracle

Copy the following script in notepad and run it. It will create a html file.

SET MARKUP HTML ON spool on
set TERMOUT off
spool C:\flashback_info.html
set linesize 132 serveroutput on pagesize 1000;
alter session set nls_date_format='mm/dd/yy hh24:mi:ss';
col name for a30
show parameter recovery;
show parameter retention;
show parameter keep;
select * from v$FLASHBACK_DATABASE_LOGFILE ;
select * from V$FLASHBACK_DATABASE_STAT ;
select * from V$FLASHBACK_DATABASE_LOG;
select * from x$krfblog;
select FILE_TYPE , PERCENT_SPACE_USED, PERCENT_SPACE_USED * p.value / 100 /
1024 / 1024 "Mb used",PERCENT_SPACE_RECLAIMABLE, NUMBER_OF_FILES,
PERCENT_SPACE_RECLAIMABLE * p.value / 100 / 1024 / 1024 "Mb reclaimable" from
v$flash_recovery_area_usage f,
v$parameter p where p.name='db_recovery_file_dest_size';
col time format a30
col name format a20
select SCN, GUARANTEE_FLASHBACK_DATABASE, STORAGE_SIZE, TIME, NAME
from v$restore_point;
Select file_type, percent_space_used as used,percent_space_reclaimable as reclaimable,
number_of_files as "number" from v$recovery_area_usage;
select name, space_limit as Total_size ,space_used as Used,
SPACE_RECLAIMABLE as reclaimable ,NUMBER_OF_FILES as "number"
from V$RECOVERY_FILE_DEST;
select * from v$flash_recovery_area_usage;
set markup html off spool off
exit;

HTML Output: