OCP CBT Question 523

Please solve the following question.

You attempted to perform a `FLASHBACK DATABASE TO SCN 1234567` operation to recover from a logical data corruption. The command failed with `ORA-38760: This database instance is not a flashback database target` followed by `ORA-38761: This database was not mounted with the FLASHBACK ON option`. Which steps must you take to enable flashback database and successfully perform the operation?

sqlFLASHBACK DATABASE TO SCN 1234567;-- Error Messages:-- ORA-38760: This database instance is not a flashback database target-- ORA-38761: This database was not mounted with the FLASHBACK ON option

Shut down the database, start in MOUNT mode, set DB_FLASHBACK_RETENTION_TARGET, and then issue ALTER DATABASE FLASHBACK ON;.

Shut down the database, start in MOUNT mode, then issue ALTER DATABASE FLASHBACK ON; and set DB_FLASHBACK_RETENTION_TARGET immediately.

The database must be opened in READ WRITE mode before enabling flashback, then you can immediately flashback.

Flashback database can only be enabled in ARCHIVELOG mode; you must first convert the database to NOARCHIVELOG mode.