Which three RMAN persistent settings can be set for a database?

Question

Options

• Abackup retention policy
• Bdefault backup device type
• Cdefault section size for backups
• Ddefault destinations for backups
• Emultiple backup device types for a single backup

• A
  89% (50)
• C
  4% (2)
• E
  7% (4)

Explanation

RMAN persistent settings are configured via the CONFIGURE command and survive across sessions, stored in the control file. Retention policy (A), default device type (B), and default destinations (D) are all valid CONFIGURE targets - e.g., CONFIGURE RETENTION POLICY TO REDUNDANCY 2, CONFIGURE DEFAULT DEVICE TYPE TO DISK, and CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backup/%U' respectively.

C is wrong because section size is a runtime parameter specified inline in a BACKUP command (e.g., BACKUP SECTION SIZE 10G), not a persistent CONFIGURE setting.

E is wrong because RMAN does not support writing a single backup to multiple device types simultaneously - a backup runs on one device type at a time, even if multiple channels are configured.

Memory tip: Think of the three correct answers as the "Who, Where, How Long" of a backup strategy - What device type (B), Where it goes (D), and How long to keep it (A). These are the strategic defaults you set once and forget; everything else is specified at backup runtime.

No community discussion yet for this question.