053试题 286 - Archived Redo Log Deletion Policy

题目：

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.
 
参考答案 D
解析
数据库运行在归档模式。归档存放在三个位置。归档删除的策略是删除备份过2次的归档。
rman的这个参数配置，针对所有的归档位置。包括FRA。所以选择D 。

参考文档：

https://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmconfb.htm#BRADV89439

Configuring an Archived Redo Log Deletion Policy

You can use RMAN to create a persistent configuration that governs when archived redo logs are eligible for deletion from disk.

About Archived Redo Log Deletion Policies

You can use the CONFIGURE ARCHIVELOG DELETION POLICY command to specify when archived redo logs are eligible for deletion. This deletion policy applies to all archiving destinations, including the fast recovery area.

Archived redo logs can be deleted automatically by the database or by user-initiated RMAN commands. Only logs in the fast recovery area can be deleted automatically by the database. For archived redo log files in the fast recovery area, the database retains them as long as possible and automatically deletes eligible logs when additional disk space is required. You can manually delete eligible logs from any location, whether inside or outside the fast recovery area, when you issue BACKUP ... DELETE INPUT or DELETE ARCHIVELOG commands.

END