Which two statements are true about this flashback scenario?

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?

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?

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

B.
The database must be MOUNTED for the flashback to succeed.

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

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

E.
The database must be opened with the RESETLOGS option after the flashback is complete.

F.
The database must be opened in read-only mode to check if the database has been flashed
back to the correct SCN.

Explanation:
B: The target database must be mounted with a current control file, that is, the
control file cannot be a backup or have been re-created.
D: You must OPEN RESETLOGS after running FLASHBACK DATABASE. If datafiles are not
flashed back because they are offline, then the RESETLOGS may fail with an error.
Note:
* RMAN uses flashback logs to undo changes to a point before the target time or SCN, and then
uses archived redo logs to recover the database forward to make it consistent. RMAN
automatically restores from backup any archived logs that are needed.
* SCN: System Change Number
* FLASHBACK DATABASE to One Hour Ago: Example
The following command flashes the database by 1/24 of a day, or one hour:
RMAN> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE-1/24);



Leave a Reply 19

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


tamil

tamil

The database needs to be mounted to do the flashback
The database must be opened with the RESETLOGS option after the flashback is complete.

So answer is B and E

tamil

tamil

B is also wrong. It needs to be mount exclusive .
F is correct since we will open the database to check whether it is flashback to required state.

so E and F

test1234

test1234

B is correct. I use it a lot in my work

Mohammad Rafiq

Mohammad Rafiq

B and E

Eugene

Eugene

BF, You can open in read only mode database. And this is the best practice. But also if I sure about SCN – I can not do it. The question why “must be opened” presents here :).

Eugene

Eugene

BF, You can open in read only mode database. And this is the best practice. But also if I sure about SCN – I can not do it. The question why “must be opened” is presented here :).

SK

SK

BE are correct We know exactly that we are flashing back the db before 5 hours. If we were to flashback with scn then BF would be correct.

SUN

SUN

BE is final answer

RS VASAN

RS VASAN

If they ask for 3 choices, then B,E,F are correct.
If they ask for 2 choices, then it would be B, E

praveen

praveen

Thats correct BEF.

F – is used to verify before you perform E

JJ

JJ

B,E
The database is flashed back by time and not by SCN, so why we should check for the SCN???

test1234

test1234

BE – agree with JJ

John

John

F says “must” but it is an optional step, so BE