1Z0-062 · Question #172
You executed the following query: Considering that all the redo logs are available, what information can you derive from the output of the preceding query?
The correct answer is C. The approximate time and the lowest system change number (SCN) to which you can flash back. Querying V$FLASHBACK_DATABASE_LOG reveals the oldest SCN and corresponding timestamp to which the database can be flashed back, given available redo logs.
Question
You executed the following query:
Considering that all the redo logs are available, what information can you derive from the output of the preceding query?
Options
- AThe time when the last flashback operation in your database was performed
- BThe time when the first flashback operation in your database was performed
- CThe approximate time and the lowest system change number (SCN) to which you can flash back
- DThe system change number (SCN) and the time when the Flashback Database was enabled in
How the community answered
(44 responses)- A2% (1)
- B5% (2)
- C93% (41)
Why each option
Querying V$FLASHBACK_DATABASE_LOG reveals the oldest SCN and corresponding timestamp to which the database can be flashed back, given available redo logs.
V$FLASHBACK_DATABASE_LOG does not record the timestamp of the most recent flashback operation performed; it tracks the boundary of available flashback data, not operation history.
The view does not record when the first flashback operation was performed; it reflects the oldest recoverable point based on flashback log retention, not operational history.
V$FLASHBACK_DATABASE_LOG contains the OLDEST_FLASHBACK_SCN and OLDEST_FLASHBACK_TIME columns, which indicate the approximate earliest point-in-time and lowest SCN to which Flashback Database can recover. With all redo logs available, this view accurately reflects how far back a flashback operation can reach.
The time when Flashback Database was enabled is found in V$DATABASE via the FLASHBACK_ON column and related metadata, not in V$FLASHBACK_DATABASE_LOG.
Concept tested: Flashback Database log view oldest recoverable SCN
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V-FLASHBACK_DATABASE_LOG.html
Topics
Community Discussion
No community discussion yet for this question.