What would be the first step to configure Flashback Database?

The database is currently running in the NOARCHIVELOG mode.
What would be the first step to configure Flashback Database?

The database is currently running in the NOARCHIVELOG mode.
What would be the first step to configure Flashback Database?

A.
Enable flashback logging.

B.
Start the database in the ARCHIVELOG mode.

C.
Issue the ALTER DATABASE FLASHBACK ON; command.

D.
Set the FAST_START_MTTR_TARGET initialization parameter.

Explanation:

Here is the problem… the question ask “for the first step”…But the database MUST be in archivelog mode and de flash recovey area MUST be enable, thus I belive the answer correct would be A and B.
Flashback Database uses its own logging mechanism, creating flashback logs which are stored in the flash recovery area. You can only use Flashback Database if flashback logs are available. Therefore, you must set up your database in advance to create flashback logs if you want to take advantage of this feature.
The requirements for enabling Flashback Database are:

* Your database must be running in ARCHIVELOG mode, because archived logs are used in the Flashback Database operation.
* You must have a flash recovery area enabled, because flashback logs can only be stored in the flash recovery area.

REF: Oracle(r) 10g Backup and Recovery Basics, 5-2 and 5-9



Leave a Reply 0

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