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