You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups. Which three statements are true about these backups? (Choose three.)

Question

Accepted Answer

B. The backups would be inconsistent. An open database undergoes continuous changes, so data files backed up while the database is running are inconsistent - blocks captured at different points in time without a clean checkpoint. C. The backups would be possible only if the database is running in ARCHIVELOG mode. Online backups require ARCHIVELOG mode because archived redo logs are needed to roll forward the inconsistent backup to a consistent state during recovery; without archiving, Oracle cannot guarantee recoverability. E. The backups need to be restored and the database has to be recovered in case of a media failure. Because the backup is inconsistent, simply restoring the data files is insufficient - archived redo logs must also be applied via media recovery to bring the database to a consistent, usable state.

Answer

A. The backups would be consistent. Consistent backups require the database to be shut down cleanly (offline/cold backup) so all data files share the same SCN; an open database cannot produce a consistent backup.

Answer

D. The backups would be possible only if the database is running in NOARCHIVELOG mode. NOARCHIVELOG mode actually prohibits online backups entirely; it is ARCHIVELOG mode, not NOARCHIVELOG, that enables online backup capability.

You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups. Which three statements are true about these backups? (Choose three.)

Question

Options

How the community answered

Why each option

Topics

Community Discussion