_____________________________________________________________________________________

USING FLASHBACK DATABASE AND RESTORE POINTS
https://docs.oracle.com/cd/E11882_01/backup.112/e10642/flashdb.htm#BRADV71000
_____________________________________________________________________________________

set pages 1000
set lines 200

show parameter db_flashback_retention_target   -- Minutes

show parameter db_recovery_file_dest
show parameter db_recovery_file_dest_size

select flashback_on from v$database;

alter system set db_recovery_file_dest = '/XXXPATHXXX/';
alter system set db_recovery_file_dest_size = XXXSIZEXXXG;

alter database flashback on|off;   -- Database must be MOUNTED (not OPEN) and ARCHIVE LOG must be enabled!

create restore point XXXNAMEXXX;
create restore point XXXNAMEXXX guarantee flashback database;

drop restore point XXXNAMEXXX;

flashback database to restore point XXXNAMEXXX;
_____________________________________________________________________________________

GENERAL INFO
============
select name, flashback_on from v$database;

V$FLASH_RECOVERY_AREA_USAGE
===========================
select * from v$flash_recovery_area_usage;
select * from v$flash_recovery_area_usage where file_type in ('FLASHBACK LOG','ARCHIVED LOG');
select space_used/(1024*1024*1024) "USED GB", space_limit/(1024*1024*1024) "LIMIT GB" from v$recovery_file_dest;

select
   round(space_used/(1024*1024*1024))    "USED GB",
   space_limit/(1024*1024*1024)          "TOTAL",
   round(space_used/(space_limit/100))   "PCT"
from v$recovery_file_dest;


V$RESTORE_POINT
===============
col name for a20
col SCN  for a20
col TIME for a19
col database_incarnation# for a4
select
  name,
  to_char(scn) "SCN",
  to_char(time,'YYYY-MM-DD_HH24:MI:SS')"TIME",
  database_incarnation# "INC#",
  guarantee_flashback_database,
  round(storage_size/1024/1024/1024) "GB"
  from v$restore_point
 order by 3 desc;


V$FLASHBACK_DATABASE_LOG
========================
select 
  round(retention_target/60)                     "CURR_RETENTION(HRS)",
  round(flashback_size/1024/1024/1024)           "CURR_SIZE(GB)",
  round(estimated_flashback_size/1024/1024/1024) "EST_SIZE(GB)"
from v$flashback_database_log;


GENERATE...
===========
select 'drop restore point '   || name || ';' "DROP_RESTORE_POINT" from v$restore_point;
select 'create restore point ' || name || ' guarantee flashback database;' "CREATE_RESTORE_POINT" from v$restore_point;
_____________________________________________________________________________________

EXTERNAL LINKS
==============
Enable Flash Recovery Area In 11g
https://orasteps.wordpress.com/2013/03/05/enable-flash-recovery-area-in-11g/
_____________________________________________________________________________________