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
Section: (none)
Explanation
Explanation/Reference:
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.