Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?

Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)? (Choose three.)

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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Read

Read

After checking out a few of the blog posts on your blog, I really appreciate your way of writing a blog. I book-marked it to my bookmark website list and will be checking back soon. Please visit my web site as well and tell me your opinion.|