OCP-1Z0-053-V12.02-286题

286.The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log

files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given

below:

LOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1/archive' LOG_ARCHIVE_DEST_2 = 'SERVICE = stdb1'

DB_RECOVERY_FILE_DEST = '/u01/oradata'

Examine the following RMAN command issued to set the deletion policy for archived log files:

RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO sbt;

Which statement is true regarding what this command accomplishes?

A. All archived redo log files backed up at least twice to tape are deleted.

B. All archived redo log files backed up at least once to tape are eligible for deletion.

C. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.

D. All archived redo log files in local archiving destinations and the flash recovery area backed up at least

twice to tape are eligible for deletion.

Answer: D

答案解析：

参考：归档重做日志删除策略：http://blog.csdn.net/rlhua/article/details/12306189

可以使用CONFIGURE ARCHIVELOG DELETION POLICY命令指定归档重做日志何时才能删除。该删除策略适用于所有归档目标，包括FRA。

归档重做日志可由数据库自动删除，或因用户启动的RMAN 命令而删除：

• 只有FRA 中的日志可由数据库自动删除。对于FRA 中的归档重做日志文件，数据库将尽可能长地保留这些文件，并在需要额外磁盘空间时自动删除符合条件的日志。

• 发出BACKUP ... DELETE INPUT或DELETE ARCHIVELOG时，可以从任何位置（无论在FRA 内部还是外部）手动删除符合条件的日志。

• 默认值为：CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

简化了多组件环境中的归档日志管理

当归档日志由多个组件（例如Streams）使用时，此功能简化了归档日志管理。它还提高了当快速恢复区中的归档日志丢失或无法访问时，备份归档日志时的可用性。

增强了删除策略的配置

仅当任何必需的组件（如Data Guard、Streams、Flashback Database，等等）都不需要归档重做日志时，才能将归档重做日志删除。配置了归档日志删除策略后，该配置会应用到所有归档目标，包括FRA。BACKUP... DELETE INPUT和DELETE... ARCHIVELOG都使用

此配置，FRA 也是。