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