nerdexam
Oracle

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.

Performing Backup and Recovery

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)
  • A
    2% (1)
  • B
    5% (2)
  • C
    93% (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.

AThe time when the last flashback operation in your database was performed

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.

BThe time when the first flashback operation in your database was performed

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.

CThe approximate time and the lowest system change number (SCN) to which you can flash backCorrect

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.

DThe system change number (SCN) and the time when the Flashback Database was enabled in

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

#Flashback Database#SCN#V$FLASHBACK_DATABASE_LOG#Point-in-time recovery

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice