Multiple choice technology programming languages

Which two statements about recovery manager (RMAN) backup are true?

  1. Online redo log files can be backed up

  2. RMAN backup can be taken only if the database is configured in ARCHIEVELOG mode.

  3. Only used data blocks can be backed up as backup sets

  4. Archived redo log files are backed up.

  5. Only consistent database backed up can be performed.
Reveal answer Fill a bubble to check yourself
C,D Correct answer
Explanation

RMAN backup can back up only used data blocks (skip empty blocks in datafiles) - this is called unused block compression. Archived redo log files can and should be backed up with RMAN. Online redo log files are NOT backed up by RMAN (they're managed through log switches/archiving). RMAN can backup in both ARCHIVELOG and NOARCHIVELOG mode, though some features require ARCHIVELOG.

Keep practicing — related questions