QUESTION 35
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
Answer: BCE
同614题:http://blog.csdn.net/rlhua/article/details/13894823
Explanation/Reference:
Section: Flashback Operations & Configuration
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 setof 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 partof 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.