nerdexam
Oracle

1Z0-062 · Question #113

You want to flash back a test database by five hours. You issue this command: SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24); Which two statements are true about this flashback scenario?

The correct answer is B. The database must be MOUNTED for the flashback to succeed. E. The database must be opened with the RESETLOGS option after the flashback is complete.. FLASHBACK DATABASE requires the database to be in MOUNT state and must be followed by opening with the RESETLOGS option to start a new redo log incarnation.

Performing Backup and Recovery

Question

You want to flash back a test database by five hours. You issue this command:

SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24); Which two statements are true about this flashback scenario?

Options

  • AThe database must have multiplexed redo logs for the flashback to succeed.
  • BThe database must be MOUNTED for the flashback to succeed.
  • CThe database must use block change tracking for the flashback to succeed.
  • DThe database must be opened in restricted mode for the flashback to succeed.
  • EThe database must be opened with the RESETLOGS option after the flashback is complete.
  • FThe database must be opened in read-only mode to check if the database has been flashed back

How the community answered

(41 responses)
  • A
    2% (1)
  • B
    93% (38)
  • D
    5% (2)

Why each option

FLASHBACK DATABASE requires the database to be in MOUNT state and must be followed by opening with the RESETLOGS option to start a new redo log incarnation.

AThe database must have multiplexed redo logs for the flashback to succeed.

Multiplexed redo logs improve recoverability but are not a prerequisite for FLASHBACK DATABASE, which relies on flashback logs written to the fast recovery area and undo data rather than the online redo logs.

BThe database must be MOUNTED for the flashback to succeed.Correct

FLASHBACK DATABASE can only execute when the database is in MOUNT state, not open, because the operation rewrites datafile headers and applies flashback logs to restore blocks to a prior point in time, which is not safe on an open database.

CThe database must use block change tracking for the flashback to succeed.

Block change tracking records changed block addresses to speed up RMAN incremental backups and has no role in the Flashback Database mechanism.

DThe database must be opened in restricted mode for the flashback to succeed.

Restricted mode is not required for a flashback operation; after FLASHBACK DATABASE the correct step is to open with RESETLOGS, optionally in read-only mode first to verify results.

EThe database must be opened with the RESETLOGS option after the flashback is complete.Correct

After FLASHBACK DATABASE completes, ALTER DATABASE OPEN RESETLOGS is mandatory to reset the online redo log sequence and register a new database incarnation; opening without RESETLOGS is rejected by Oracle.

FThe database must be opened in read-only mode to check if the database has been flashed back

Opening in read-only mode is an optional verification step, not a requirement; the standard and complete procedure is to open with RESETLOGS after flashback.

Concept tested: FLASHBACK DATABASE prerequisites and post-flashback open requirements

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/using-flashing-back-database.html

Topics

#Flashback database#Database states#RESETLOGS

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-062 Practice