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 9

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


Sunil

Sunil

Answer should be B and E. Database need to be open in resetlogs after Flashback Database done

JRD

JRD

The corrects answers are B and D, because you must open resetlogs after running flashback database. If datafiles aren’t flashed back because they’re offline, then the resetlogs may fail with an error.
…..

Flash back the database to the desired time.

In this example, you need to flashback the entire database to the time specified in the TIME clause.

FLASHBACK DATABASE to TIME “TO_DATE(’03/20/12′,’MM/DD/YY’)”;

Open the database read-only and run some queries to verify the database contents.

The following command opens the database in read-only mode:

ALTER DATABASE OPEN READ ONLY;

After confirming that the state of the database is as expected, make the database available for updates by opening it with the RESETLOGS option.

SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER DATABASE OPEN RESETLOGS;

noori

noori

I think database is already in mount state;)

Shawn

Shawn

Sunil is right, the answer is B & E.

The database MUST be mounted in exclusive mode, but not opened before the flashback. Afterwords the database MAY (note, not MUST!) be opened in read-only mode to check if the database has been flashed back to the correct state. Last step is to OPEN with RESETLOGS.

Alex

Alex

This is tricky – should be BFE but F is not a must but optional step, so BE

Read Even more

Read Even more

Whats up very nice website!! Guy .. Excellent .. Superb .. I will bookmark your site and take the feeds also? I’m glad to seek out numerous useful information here in the post, we want develop extra strategies on this regard, thank you for sharing. . . . . .|