ORA-38729

SQL> flashback database to scn 538844;

flashback database to scn 538844

*

ERROR at line 1:

ORA-38729: Not enough flashback database log data to do FLASHBACK.

I am getting above error when trying to flashback database, above error message occur when FLASHBACK LOG is aged out in FLASH_RECOVERY_AREA.

Oracle automatically removed old flashback logs to make free space in FRA for others files.

Set below two parameter properly so flashback logs will not aged out.

1. db_recovery_file_dest_size

Size for the FLASHBACK RECOVERY AREA

2. db_flashback_retention_target

how far can we bring the database back in time ? value set in MINUTES, default value is 1440 means 24 hrs.

For more info