Multiple choice

MARY used an ALTER DATABASE statement on her database to perform an online control file backup. In which mode is her database operating?

  1. FAILOVER

  2. FASTBACK

  3. ARCHIVELOG

  4. NOARCHIVELOG

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Online control file backups can only be performed when the database is in ARCHIVELOG mode. In NOARCHIVELOG mode, the database must be shut down for consistent backups. The ALTER DATABASE BACKUP CONTROLFILE TO TRACE command works online only in ARCHIVELOG mode.