You are working on an Oracle Database 19c database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? (Choose two.)

Question

Options

• AFlashback logs are not archived.
• BFlashback logs are maintained in redo log files.
• CFlashback logs are maintained in the Flash Recovery Area.
• DFlashback logs are used to maintain Flashback Database related errors.
• EFlashback logs need to be cleared manually after you disable Flashback Database.

• A
  93% (56)
• B
  2% (1)
• D
  3% (2)
• E
  2% (1)

Explanation

Flashback logs are written directly to the Flash Recovery Area (FRA) - a dedicated disk location managed by Oracle - making C correct, and unlike redo logs or archive logs, they are never archived, making A correct. Option B is wrong because flashback logs are entirely separate from redo log files; redo logs record transaction changes while flashback logs capture before-images of data blocks specifically for the Flashback Database feature. Option D is wrong because flashback logs are used to restore the database to a prior point in time, not to track errors. Option E is wrong because Oracle automatically clears flashback logs when you disable Flashback Database - no manual cleanup is required.

Memory tip: Think "FRA = Flashback's home, and it never leaves home (no archiving)." Flashback logs are born in the FRA and die there - Oracle handles the lifecycle automatically.

No community discussion yet for this question.