🎴 Flashcard Mode
DB2 and Oracle Database Systems Quiz
Card1 / 20
Mastered0
Review0
QuestionClick to flip
Which condition in your database forces you to perform only consistent backups?
AnswerClick to flip back
A
The database operates in NOARCHIEVELOG mode.
💡 Explanation:
In NOARCHIVELOG mode, Oracle cannot perform hot/inconsistent backups because there are no archived redo logs to recover transactions. Only consistent (cold) backups are possible where the database is cleanly shut down. ARCHIVELOG mode allows both consistent and inconsistent backups.