【云贝教育】Oracle 19c OCP 083题库解析(27)

作者：云贝教育郭一军

原创

发布时间：2024-01-11 09:18

浏览量：556

考试科目：1Z0-083

考试题量：85

通过分数：57%

考试时间：150min

本文为云贝教育郭一军（微信：guoyJoe）原创，请尊重知识产权，转发请注明出处，不接受任何抄袭、演绎和未经注明出处的转载。

27 、You issued this command
RMAN> BACKUP RECOVERY AREA FORCE
Which three are true?
A) All Oracle recovery files normally written to the FRA and which have been backed up already to the current FRA are backed up
B) All files in any previous FRA that have not yet been backed up, are backed up
C) All Oracle recovery files normally written to the FRA and which have not yet been backed, are backed up
D) All Oracle recovery files normally written to the FRA and which have been backed up already to in any previous FRA, are backed up
E) All files in the current fast recovery area(FRA)that have not yet been backed up, are backed up
F) All files in the current FRA that have been backed up already, are backed up
G) All files in any previous FRA that have been backed up already, are backed up.

参考答案：AD

解析：

备份在当前和以前所有快速恢复区目标中创建的恢复文件。
备份可以转到SBT和磁盘。要备份到磁盘，必须使用To DESTINATION语法。
恢复文件包括完整备份集和增量备份集、控制文件自动备份、数据文件副本和归档重做日志文件。

关键字：Backs up recovery files created in the current and all previous fast recovery area destinations
做这题的技巧：BACKUP RECOVERY AREA FORCE命令不一定全部备份恢复的文件，All Oracle recovery就是对的，all files是错的

A)对，所有Oracle恢复文件通常写入FRA，并且已经备份到当前FRA
B)错，任何以前FRA中尚未备份的所有文件都已备份
C)对，所有Oracle恢复文件通常写入FRA，但尚未备份，都备份了
D)对，所有正常写入FRA的Oracle恢复文件，并且已经备份与之前任何FRA的数据都有备份
E)错，备份当前快速恢复区(FRA)中所有尚未备份的文件
F)错，当前FRA中已备份的所有文件，均已备份
G)错，任何以前的FRA中已经备份过的所有文件，都已备份。

BACKUP RECOVERY AREA ... per 19c RMAN reference:
Backs up recovery files created in the current and all previous fast recovery area destinations. Backups can go to SBT and disk. To backup to disk, you must use the TO DESTINATION syntax.

Recovery files are full and incremental backup sets, control file autobackups, data file copies, and archived redo log files.
Flashback logs, the current control file, and online redo log files are not backed up.

By default, backup optimization is enabled for this command even if the CONFIGURE BACKUP OPTIMIZATION setting is OFF. You can disable backup optimization for BACKUP RECOVERY AREA by specifying FORCE.

Note: If the fast recovery area is not enabled but was enabled previously, then files created in the previous fast recovery area location are backed up.

Backs up recovery files created in the current and all previous fast recovery area destinations. Backups can go to SBT and disk. To backup to disk, you must use the TO DESTINATION syntax outlined in toDestSpec.

Recovery files are full and incremental backup sets, control file autobackups, data file copies, and archived redo log files. If an archived redo log file is missing or corrupted, then RMAN looks outside of the recovery area for a good copy of the log that it can use for the backup. Flashback logs, the current control file, and online redo log files are not backed up.

By default, backup optimization is enabled for this command even if the CONFIGURE BACKUP OPTIMIZATION setting is OFF. You can disable backup optimization for BACKUP RECOVERY AREA by specifying FORCE.

Note: If the fast recovery area is not enabled but was enabled previously, then files created in the previous fast recovery area location are backed up

SQL> select file_type from v$flash_recovery_area_usage;

FILE_TYPE
-----------------------
CONTROL FILE
REDO LOG
ARCHIVED LOG
BACKUP PIECE
IMAGE COPY
FLASHBACK LOG
FOREIGN ARCHIVED LOG
AUXILIARY DATAFILE COPY