Oracle Database Administration II — Question 111

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

Answer options

• A. All archive logs are retained after an archival backup is taken, until the next archival backup is taken of the same database.
• B. The SPFILE is included in the archival backup.
• C. They are never considered obsolete by RMAN.
• D. Archive logs are retained if they are necessary to allow the database to be recovered to a consistent state when an archival backup is restored.
• E. The ARCHIVAL attribute for a backup overrides the RMAN retention policy.
• F. They can optionally be written to a fast recovery area (FRA).
• G. Use of a recovery catalog is always required to support the creation and use of archival backups.

Correct answer: A, B, F

Explanation

The correct answers are A, B, and F because they accurately describe the characteristics of RMAN archival backups. A states that archive logs are kept until the next backup, B confirms that the SPFILE is included, and F notes that the backups can be stored in the FRA. Options C, D, E, and G are incorrect as they misrepresent the RMAN behavior or requirements.