OCP-1Z0-053-200题-35题-614

来源:互联网 发布:剑雨江湖进阶祝福数据 编辑:程序博客网 时间:2024/06/05 10:35

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.

0 0
原创粉丝点击