Which three are true about RMAN archival backups with the RESTORE POINT clause? (Choose three.)

Question

Options

• AAll archive logs are retained after an archival backup is taken, until the next archival backup is
• BThe SPFILE is included in the archival backup.
• CThey are never considered obsolete by RMAN.
• DArchive logs are retained if they are necessary to allow the database to be recovered to a
• EThe ARCHIVAL attribute for a backup overrides the RMAN retention policy.
• FThey can optionally be written to a fast recovery area (FRA).
• GUse of a recovery catalog is always required to support the creation and use of archival backups.

• A
  4% (1)
• B
  81% (21)
• F
  4% (1)
• G
  12% (3)

Explanation

B is correct because RMAN archival backups are self-contained and automatically include the SPFILE, making them independently restorable without needing additional components. D is correct because only the archive logs necessary to recover the database to the specified restore point are retained - not all archive logs. E is correct because the ARCHIVAL attribute explicitly exempts the backup from the configured RMAN retention policy, meaning it won't be purged by automated obsolescence rules.

Why the distractors fail:

• A is wrong - archive logs are retained only through what's needed to reach the restore point, not until the next archival backup
• C is close but too absolute - archival backups are immune to the configured retention policy but can still be explicitly marked obsolete or deleted manually
• F is wrong - archival backups cannot be written to the FRA; they must target a location outside it
• G is wrong - a recovery catalog is not required; archival backups work with the control file alone

Memory tip: Think "SPF Protection" - the SPFILE is bundled, only Point-relevant archive logs are kept, and the backup has Force-exemption from the retention policy.

No community discussion yet for this question.