Which option must you use to check whether a flashback operation can recover the database to the specified time?

On Friday at 11:30 am you decided to flash back the database because of a user error that
occurred at 8:30 am. Which option must you use to check whether a flashback operation can
recover the database to the specified time?

On Friday at 11:30 am you decided to flash back the database because of a user error that
occurred at 8:30 am. Which option must you use to check whether a flashback operation can
recover the database to the specified time?

A.
Check the alert log file

B.
Query the V$FLASHBACK_DATABASE_LOG view

C.
Query the V$RECOVERY_FILE_DEST_SIZE view

D.
Query the V$FLASHBACK_DATABASE_STAT view

E.
Check the value assigned for the UNDO_RETENTION parameter

Explanation:
select oldest_flashback_scn, oldest_flashback_time
from
v$flashback_database_log;
SYBEX Oracle 1Z0-053 Study Guide, Chapter 9: Understanding Flashback Technology
Query the V$FLASHBACK_DATABASE_LOG to determine the amount of space required in the
recovery area to support the flashback activity generated by changes in the database.
The values in the OLDEST_FLASHBACK_SCN and OLDEST_FLASHBACK_TIME columns give
you information regarding how far back you can use Flashback Database.

Oracle Press 1Z0-053 Exam Guide, Chapter 9: Configuring and Using Flashback
You can determine how far back you can flashback the database by querying the V
$FLASHBACK_DATABASE_LOG view. The amount of flashback data retained in the database is
controlled by the initialization parameter and the size of the flash recovery area.



Leave a Reply 0

Your email address will not be published. Required fields are marked *