Database Backup and Recovery (MOSC)

MOSC Banner

Flashback database.

edited May 18, 2011 1:35AM in Database Backup and Recovery (MOSC) 4 commentsAnswered
 Hello,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center