Which three types of files can be automatically placed in the flash recovery area (fast recovery
area in 11g Release 2)? (Choose three.)
A.
Alert log file
B.
Archived redo log files
C.
Control file autobackups
D.
Server Parameter file (SPFILE)
E.
Recovery Manager (RMAN) backup piece
Explanation:
http://www.pafumi.net/Flash_Recovery_Area.html
The Flash Recovery Area (FRA) is a unified storage location for all recovery related files and
activities in an Oracle database.
By defining one init.ora parameter, all RMAN backups, archive logs, control file autobackups, and
datafile copies are automatically written to a specified files system or ASM Disk Group.
Oracle Press 1Z0-053 Exam Guide, Chapter 4: Creating RMAN Backups
The following permanent items are stored in the flash recovery area:
– Control file: Oracle stores one copy of the control file in the flash recovery area during an
installation,which specifies the flash recovery area.
– Online redo log files You can store one mirrored copy from each redo log file group in the flash
recovery area.
The following transient items are stored in the flash recovery area:
– Archived redo log files When you configure the flash recovery area, one set of archived redo
log files is stored in the flash recovery area.
– Flashback logs Flashback logs are stored in the flash recovery area when Flashback Database
is enabled.
– Control file automatic backups RMAN stores control file automatic backups in the flash
recovery area.
When RMAN backs up the first datafile, which is part of the SYSTEM tablespace, the control file is
automatically included in the RMAN backup.
– Datafile copies When you use the RMAN command BACKUP AS COPY, the datafile copies are
stored in the flash recovery area by default.
– RMAN backupsets Files created with the BACKUP AS BACKUPSET command are stored in
the flash recovery area.
– RMAN files By default, RMAN uses the flash recovery area as a staging area for backup and
recovery of the archive log files from disk or tape.