Flashback database.
I put my db (11gR2 personal edition) in flashback .
db_flashback_retention_target 1440 which mean 24hour
this select
select
oldest_flashback_scn,
oldest_flashback_time,
retention_target,
FLASHBACK_SIZE/1024/1024
,estimated_flashback_size/1024/1024
from v$flashback_database_log;
told me that i could flashback to 27 of febuary more than one day.
OLDEST_FLASHBACK_SCN OLDEST_FLASHBACK_TIME RETENTION_TARGET FLASHBACK_SIZE/1024/1024 ESTIMATED_FLASHBACK_SIZE/1024/1024
3223790 27-FEVR.-2011 08:43:56 1440 197,640625 45,1171875
It s more than the db_retention_target.
Is it because my FRA is not full?
SQL> select name, space_limit, space_used, space_reclaimable from v$recovery_file_dest;
NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE