Multiple choice technology databases

Your database is in NOARCHIEVELOG mode. Since last night’s offline backup the logs in group 1 have been written to twice. This morning the system data file has become corrupted. Up to what point can it be recovered?

  1. Until the last commit.

  2. Cannot be recovered.

  3. Until the last offline backup.

  4. Until the beginning of the last transaction.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In NOARCHIVELOG mode, Oracle does not preserve online redo logs for recovery purposes. Once redo logs are overwritten (they've been written twice here), any changes after the last consistent backup are lost. The database can only be recovered to the point of the last offline backup, which is when the database was in a consistent state.

Keep practicing — related questions