Which three statements are true about Flashback Database?

Which three statements are true about Flashback Database?

Which three statements are true about Flashback Database?

A.
Flashback logs are written sequentially, and are archived.

B.
Flashback Database uses a restored control file to recover a database.

C.
The Oracle database automatically creates, deletes, and resides flashback logs in the Fast
Recovery Area.

D.
Flashback Database can recover a database to the state that it was in before a reset logs
operation.

E.
Flashback Database can recover a data file that was dropped during the span of time of the
flashback.

F.
Flashback logs are used to restore to the blocks’ before images, and then the redo data may be
used to roll forward to the desired flashback time.

Explanation:
* Flashback Database uses its own logging mechanism, creating flashback logs and
storing them in the fast recovery area (C). You can only use Flashback Database if flashback logs
are available. To take advantage of this feature, you must set up your database in advance to
create flashback logs.
* To enable Flashback Database, you configure a fast recovery area and set a flashback retention
target. This retention target specifies how far back you can rewind a database with Flashback
Database.
From that time onwards, at regular intervals, the database copies images of each altered block in
every data file into the flashback logs. These block images can later be reused to reconstruct the
data file contents for any moment at which logs were captured. (F)

Incorrect:
Not E: You cannot use Flashback Database alone to retrieve a dropped data file. If you flash back
a database to a time when a dropped data file existed in the database, only the data file entryis
added to the control file. You can only recover the dropped data file by using RMAN to fully restore
and recover the data file.
Reference: Oracle Database Backup and Recovery User’s Guide 12c R



Leave a Reply 13

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


Ledeboer, Jeroen

Ledeboer, Jeroen

The correct answer is:
C, D, F
B is incorrect. The target database must be mounted with a current control file, that is, the control file cannot be a backup or re-created. The database must run in ARCHIVELOG mode.
D is correct. There’s even a command:
FLASHBACK DATABASE TO BEFORE RESETLOGS;

JanK

JanK

A – FALSE
Oracle-generated logs used to perform flashback database operations. The database can only write flashback logs to the fast recovery area. Flashback logs are written sequentially and are not archived. They cannot be backed up to disk.

B – FALSE
If the database control file is restored from backup or re-created, all accumulated flashback log information is discarded. You cannot use FLASHBACK DATABASE to return to a point in time before the restore or re-creation of a control file.

E – FALSE
Flashback Database can only undo changes to a data file made by Oracle Database. It cannot be used to repair media failures, or to recover from accidental deletion of data files.

http://docs.oracle.com/database/121/BRADV/flashdb.htm#BRADV529
http://docs.oracle.com/database/121/BRADV/glossary.htm#BRADV90169

Mohammad Rafiq

Mohammad Rafiq

C D and F

Jeyoung Kim

Jeyoung Kim

http://docs.oracle.com/database/121/BRADV/flashdb.htm#BRADV286
If the database control file is restored from backup or re-created, all accumulated flashback log information is discarded. You cannot use FLASHBACK DATABASE to return to a point in time before the restore or re-creation of a control file.

It means, can use restored control file with restricted condition.

So, I bet to B,C,F.

SUN

SUN

CDF is final answer.

Yaseen

Yaseen

this question is there in the exam ?

Umaruddin Ansari

Umaruddin Ansari

C,D,F are correct